I\'m building a self-tracking system to log e.g. my phone\'s accelerometer, the

Question

I'm building a self-tracking system to log e.g. my phone's accelerometer, the keys I type, my mouse activity, and so on.

So which database should I use? My research so far suggests SQLite3, because the database won't be very big - my calculations give around 1 million new (small) records per day, which should be around 15MB per day.

Some software I use already stores its data in an SQLite3 database; would I have to write much special-case code to use the two different types of databases, or would the same code suffice?

Explanation / Answer

I would suggest you keep using SQLite3: most applications that need an embedded database for local/client storage use it, and 20 writes per minutes doesn't sound to me like a lot, all the more so as from what you describe the writes are probably just inserts, which you can easily batch provided that you use SQLite 3.7.11 or up:

INSERT INTO 'tablename'
SELECT 'data1' AS 'column1', 'data2' AS 'column2'
UNION SELECT 'data3', 'data4'
UNION SELECT 'data5', 'data6'
UNION SELECT 'data7', 'data8'

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.