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
2  2955 
It sounds like pySqlite would fit your needs perfectly.
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.or g> wrote in message
news:uA******** **********@news 2.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Carsten Gehling |
last post by:
Oh how often this subject may come up...
The thing is, I've come to the decision of abandoning PHP as much as
possible (old projects still remain...), and use Python for all purposes.
Reason: One language to fit it all (instead of having one language for
webprogramming, one for batches, etc...)
I stand now at the point where I must choose a framework for my web
application development. I've skimmed a few: mod_python, pso and Zope....
|
by: Carsten Gehling |
last post by:
> -----Oprindelig meddelelse-----
> Fra: python-list-admin@python.org
> På vegne af David McNab
> Sendt: 17. juli 2003 01:32
> Til: python-list@python.org
> Emne: Re: Choosing the right framework
> I've been working on an HTML generation framework called 'pyWeb'. Just
> posted to this ng yesterday, calling for testers.
>
|
by: Jean de Largentaye |
last post by:
Hi,
I need to parse a subset of C (a header file), and generate some unit
tests for the functions listed in it. I thus need to parse the code,
then rewrite function calls with wrong parameters. What I call "shaking
the broken tree" :)
I chose to make my UT-generator in Python 2.4. However, I am now
encountering problems in choosing the right parser for the job. I
struggle in choosing between the inappropriate, the out-of-date, the...
|
by: Jonas Hei |
last post by:
I need to decided between Standard and Enterprise Edition (Cost is a
criteria - but its secondary to performance - <!--and I am not paying for
it myself-->)
The server spec under consideration: Dual Xeon, 1GB RAM, 36GB - RAID 1
(Dell PowerEdge 1850).
Application: Windows 2003 Std Server, ASP.NET, MS SQL Server 2000 based
data driven web application.
|
by: Mike L. Bell |
last post by:
Pulling our hair out over this one. We have two databases. One is used
for OLTP. The other hosts old closed transactions and is mainly used
for reporting. Every month we identify rows in the primary (OLTP)
database that are eligible to be moved and ship them over. Been doing
this for over a year without any problems.
After last weekend's move everything went sour on our history
database. A set of canned queries started taking orders of...
| | |
by: PepsiDrinker |
last post by:
Hello! :^)
I am trying to implement a class library for dealing with time series.
I have to use time series with seasonable component and without it.
Also, time series can be stored in memory or in a database.
The problem is to make 4 following classes:
1. non-seasonable and storable in memory
2. seasonable and storable in memory
3. non-seasonable and storable in database
4. seasonable and storable in database
|
by: pedro8ae |
last post by:
My database has the data from events that happened in several dates
this is different event happening in the same day. this database manage
a Help Desk where calls happened often.
how to create a report that allows the user pick or select a specific
date to print?
ex. I want to print all the events that happend on 08/17-2006, but
later I want to print a report of all the events that happend on August
15 2006.
|
by: hansBKK |
last post by:
Upfront disclaimer - I am a relative newbie, just starting out learning
about PHP, mostly by researching, installing and playing with different
scripts. I am looking for a host that will provide the right environment
for this - running a wide variety of PHP applications. I realise that
security is also important, but for now flexibility is more important to
me.
Note that I'm **not** looking for people to recommend hosting companies,
I...
|
by: Frank Swarbrick |
last post by:
Are there advantages to choosing, say, IBM-1252 over UTF-8? If my PC
application uses code page 1252 will it perform better because no code page
translation is required? I assume so. What type of performance hit might I
expect when connecting to a UTF-8 database? What advantages would I get by
using a UTF-8 database? Obviously it can store the entire Unicode 'plane'
(or whatever that's called), but if my PC can't display it anyway what...
|
by: script07 |
last post by:
Hello,
I don't know where to post the following query:
"A friend of mine created a Lotus Approach database where all his clients' data is stored.
The data is now located in an Excel spreadsheets.
We would like to create a website where his customers can access their data via a username and a login.
I am familiar with designing websites but I never connected it with a database.
Can someone advise me further?"
At the moment, I also have...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
