Re: simultaneous multiple requests to very simple database

From: Eric S. Johansson (esj_at_harvee.org)
Date: 01/18/05 

To: python-list@python.org
Date: Tue, 18 Jan 2005 17:33:26 -0500

Thomas Bartkus wrote:
> "Eric S. Johansson" <esj@harvee.org> wrote in message
> news:mailman.859.1106065617.22381.python-list@python.org...
> <snip>
>
>>at this point, I know they will be some kind souls suggesting various
>>SQL solutions. While I appreciate the idea, unfortunately I do not have
>>time to puzzle out yet another component. Someday I will figure it out
>>because I really liked what I see with SQL lite but unfortunately, today
>>is not that day (unless they will give me their work, home and cell
>>phone numbers so I can call when I am stuck. ;-)
>
> <snip>
>
> Forgive me if this reply sounds a bit glib. But I do mean it without malice.

understood and taken in that spirit.

> Do you seriously expect to write your own (database) solution and that this
> will save you time and effort over learning an existing (SQL) solution?
>
> Because -
> If you are seeking to "save time" on "puzzles", you are certainly going
> about it the wrong way.

one thing I learned a long time ago was to respect the nagging voice in
the back of my head that says "there is something wrong". Right now
with databases, that voice is not nagging but screaming. So I made my
query to try and prove that intuition wrong. So far, that has not happened.

When I look at databases, I see a bunch of very good solutions that are
either overly complex or heavyweight on one hand and very nice and
simple but unable to deal with concurrency on the other. two sets of
point solutions that try to stretch themselves and the developers to fit
other application contexts.

99.9 percent of what I do (and I suspect this could be true for others)
could be satisfied by a slightly enhanced super dictionary with a record
level locking. but, the database world does not fit this model. It has
a great deal more complication then what is frequently necessary.

If I ever find the time, I will try to build such a beast probably
around Metakit. The only reason for reluctance is that I have spent too
many hours tracking down concurrency problems at the OS level way to
many years ago and so I do not create multithreaded applications lightly.

so in conclusion, my only reason for querying was to see if I was
missing a solution. So far, I have not found any work using because
they add orders of magnitude more complexity than simple dbm with file
locking. Obviously, the simple solution has horrible performance right
now I need simplicity implementation.

thanks for your commentary.

---eric

Relevant Pages

  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Relational-to-OOP Tax
    ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
    (comp.object)
  • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
    ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
    (php.general)
  • DataArchitect Version 3.5 Now On HP-UX
    ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
    (comp.sys.hp.mpe)