468,284 Members | 1,492 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,284 developers. It's quick & easy.

Choosing the right database-system for a small project

I've got a rather small project, small in the sense that there's not a lot
of different tables needed in the database/storage-system, but there will be
alot of data and the clients must be able to scan thru huge amounts of data
very fast ( Not serial scanning, but lookups by key, preferrably several
keys pr record, ie. I need to lookup people both by SSN and by
first/last-name etc. )

So far I've used MySQL, mainly because I need something that installs easily
on both Linux and Windows. But I don't need a big user-management system, I
need something light, a bit more flexible than shelve, and as I said earlier
I need to lookup data by several key-fields.

I've also looked at MetaKit and this seems like just my kind of thing. Easy
to use and install. Remember that I've only looked at the docs, not tried
anything for real. Another contender is SQLLite. It's very important that
the system is easy to install. Anything more than "copy these files in this
folder" or run this install-program on Windows is unacceptable, and anything
more than configure/make/make install without lots of other library
dependancies on Linux is also out of the question.

Can anybody share experiences with these solutions? Speed, flexibility,
installation issues? I intend to use this with Twisted so if there are any
blocking issues I need to consider please let me know. Any other system I
should take a look at ??

Thanks a bunch,
Thomas
Jul 18 '05 #1
2 2630
It sounds like pySqlite would fit your needs perfectly.
Jul 18 '05 #2
Now I've looked closer at SQLite and MetaKit and they both seem great. I've
looked for some sort of comparison but with little luck. Can anybody comment
on what would
be the pros and cons when the two are compared to each other ?

I liked the fact that SQLite worked like a real SQL-database, but I also
liked the way records turned into well-known Python-objects when fetched in
MetaKit.

Any comment, especially on speed and limitations found when using these two
are interesting.

Regards,
Thomas
"Thomas Weholt ( PRIVAT )" <20**@weholt.org> wrote in message
news:uA******************@news2.e.nsc.no...
I've got a rather small project, small in the sense that there's not a lot
of different tables needed in the database/storage-system, but there will be alot of data and the clients must be able to scan thru huge amounts of data very fast ( Not serial scanning, but lookups by key, preferrably several
keys pr record, ie. I need to lookup people both by SSN and by
first/last-name etc. )

So far I've used MySQL, mainly because I need something that installs easily on both Linux and Windows. But I don't need a big user-management system, I need something light, a bit more flexible than shelve, and as I said earlier I need to lookup data by several key-fields.

I've also looked at MetaKit and this seems like just my kind of thing. Easy to use and install. Remember that I've only looked at the docs, not tried
anything for real. Another contender is SQLLite. It's very important that
the system is easy to install. Anything more than "copy these files in this folder" or run this install-program on Windows is unacceptable, and anything more than configure/make/make install without lots of other library
dependancies on Linux is also out of the question.

Can anybody share experiences with these solutions? Speed, flexibility,
installation issues? I intend to use this with Twisted so if there are any
blocking issues I need to consider please let me know. Any other system I
should take a look at ??

Thanks a bunch,
Thomas

Jul 18 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Carsten Gehling | last post: by
reply views Thread by Carsten Gehling | last post: by
11 posts views Thread by Jean de Largentaye | last post: by
4 posts views Thread by Jonas Hei | last post: by
1 post views Thread by Mike L. Bell | last post: by
2 posts views Thread by PepsiDrinker | last post: by
4 posts views Thread by pedro8ae | last post: by
3 posts views Thread by Frank Swarbrick | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.