I only have ever used mysql and storing data on .txt files.
How can I achieve a data structure that fits this description?
The database should store prices that are associated with unix timestamps oldest to newest. the database should have a maximum number of rows (100,000). If adding one new row would put the database over its maximum size then it should delete its oldest row.
My thoughts are: Could I set the primary key to be the timestamp? How would I handle keeping the database to a set amount of rows? what would the speed be if I get all the rows at once in a query? What database language would be suited for this?
I only have 3-4 users that will access this app so there wont be a lot of querys. txt files are defiantly not good for (me) storing large data.