I am looking for a DB to store list of float numbers. And has a good support in pyhton. I have found some options but not sure which one is the best.. Probably all DBs are good for this.
I will need one primary key, so probably some SQL db. Which one has to best support in python and is easy to use? Which one is the best to store lists of numbers in? I do not expect high volume of data. Max few thousands or records.
Thanks for your recommendation and your opinion. :)

  • How large is the data set?
    – Eric S
    Jul 31 '19 at 14:20
  • each list will have 125 values that looks like "0.456145678" i will have few hundreds max few thousands of these lists. the performance should not be problem.
    – jv95
    Aug 1 '19 at 11:40
  • Perhaps just use a simple CSV file, one row per record?
    – knb
    Dec 29 '19 at 21:06

I'm not an expert at this, but for small data sets that will fit in RAM, I think the standard recommendation is the SQLite library. I used this once on a small project and it worked very well. Depending on what you want to do with the data, you might well be served using Pandas dataframes, however you don't provide enough information to assess that.

  • The final solution is to go for MySQL :) It has very good python support and works well. Also I would personally never go on production with SQLite. Thanks
    – jv95
    Aug 3 '19 at 19:21
  • @jv95 If you are considering MySQL, you should probably also consider MariaDB and PostgreSQL.
    – Eric S
    Aug 3 '19 at 19:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.