RE: [cgiapp] What's the best "free" DB for a web-based app?

This is a pretty difficult to answer question. How heavy do we expect the
usage to be? What kind of system will it be running on?

In general, I've found that MySQL has the best GUI applications. The MySQL
Query Browser makes writing scripts and executing arbitrary SQL statements
on the database a breeze. I've heard arguments that postgresql is a better
database platform; the claim is that postgres is more functional and runs
faster (I don't know how this changed with MySQL 5).

If your site is going to be real light traffic, then you can use SQLite,
which is file-based. Writes to the DB require file locking but reads are
concurrent.

Push comes to shove, a well designed program will not have a lot of
dependency on the database. All of your SQL statements should be aggregated
in a single place, and if you use DBI (and fairly vanilla syntax) then you
can completely change the platform just by changing the DSN.

Josh


--
Josh Danziger
Josh@xxxxxxxxxxxx
-----Original Message-----
From: John Armstrong [mailto:john_armstrong@xxxxxxxxxx]
Sent: Tuesday, November 29, 2005 8:02 PM
To: dbi-users@xxxxxxxx
Cc: cgiapp@xxxxxxxxxxxxxxxxx
Subject: [cgiapp] What's the best "free" DB for a web-based app?


Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? We want no licensing obligations (no Oracle,
Sequal Server, etc.). We want to go with Perl because it's the best
programming language invented by humans.


---------------------------------------------------------------------
Web Archive: http://www.mail-archive.com/cgiapp@xxxxxxxxxxxxxxxxx/
http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: cgiapp-unsubscribe@xxxxxxxxxxxxxxxxx
For additional commands, e-mail: cgiapp-help@xxxxxxxxxxxxxxxxx
.

Relevant Pages

  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)