Ask HN: I am looking for a light-weight, fast database

#1

Post by baritalia » Sat, Dec 29, 2012, 12:15 PM UTC

What do you recommend?

Re: Ask HN: I am looking for a light-weight, fast database

#2

Post by kghose » Sat, Dec 29, 2012, 12:45 PM UTC

I've had good luck using sqlite3 for both a hobby project (a photo organizer http://github.com/kghose/Chhobi) as well as for work (neural data analysis)

Re: Ask HN: I am looking for a light-weight, fast database

#3

Post by dotmanish » Sat, Dec 29, 2012, 12:56 PM UTC

What's the use case? Are you looking for mobile platform compatible database, or for web backends?

Re: Ask HN: I am looking for a light-weight, fast database

#4

Post by ishbits » Sat, Dec 29, 2012, 5:07 PM UTC

kghose wrote: post #2

I've had good luck using sqlite3 for both a hobby project (a photo organizer http://github.com/kghose/Chhobi ) as well as for work (neural data analysis)

I've had good luck with SQlite as well, until I have multiple writers, or even concurrent readers or writers.

Re: Ask HN: I am looking for a light-weight, fast database

#5

Post by jfaucett » Sat, Dec 29, 2012, 8:11 PM UTC

It depends on what you need. sqlite if you need SQL queries /indexes,etc, try leveldb if key/value store will work, its fast and micro.

Re: Ask HN: I am looking for a light-weight, fast database

#6

Post by ssjvackar » Sun, Dec 30, 2012, 12:40 AM UTC

MongoDB is 'lightweight' in the sense it's easy to setup and persistence of both simple and complex objects is a breeze. The query interface is a bit ugly but it may be worth a look.