If you want to easy portability of your database use SQLite... but if you
are a great site, doing every time insert and update use another like
postgresql or mysql.
and it depends of the language your are writing your web site, if you PHP
you could use what ever between mysql,postgresql, sqlite or
On Mon, Apr 24, 2006 at 08:54:40PM -0400, Paul Malcher wrote:
> On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
> >
> > Keep in mind, there's *WAY* more Windows users than Linux users; that
> > doesn't mean Windows is a better OS.
>
>
> Indeed also keep in mind both Postgres and MySQL are cro
On 4/24/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
>
> Keep in mind, there's *WAY* more Windows users than Linux users; that
> doesn't mean Windows is a better OS.
Indeed also keep in mind both Postgres and MySQL are cross platform as well.
One final thought: the support you'll be able to get
On Thu, Apr 06, 2006 at 04:58:43AM -0700, Lenster wrote:
> 1) Googling PostgreSQL produced 52,700,000 hits, Googling MySQL produced
> 397,000,000 hits
I'd be much more concerned with the 'hits' you'll find at
http://sql-info.de/mysql/gotchas.html ...
Keep in mind, there's *WAY* more Windows users
My first thought when you asked this: If you have to ask, just go with
MySQL. If for no other reason than to ease learning. As you said
before, Googling for each has way different results. I have found
that learning how to do things (with PHP in my case) with Mysql was
easy just because there ar
Hi Len,
The question you are asking is "loaded". Stay with the ansi SQL statements
that SQLite supports and you will be okay. If you need to use the SQLite
extensions now, you will have to write a "translator" in future - not too
difficult. For an experienced programmer (which you will be if the
s
Provided your new database has the features you are using it is simple.
For example we use Sqlite and PostgreSQL and transferring between them
is simple. Even the application program API is similar so a conditional
compile in the programs takes care of that and links appropriately.
JS
Lenste
Thanks Dennis, that's great news - I shall give it a try :-)
--
View this message in context:
http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404628.html#a3793176
Sent from the SQLite forum at Nabble.com.
Sounds like an interesting setup! Maybe off topic, but, would you care
to elaborate on that topic? Server configuration, virtualization
software running, etc.?
[EMAIL PROTECTED] wrote:
Lenster <[EMAIL PROTECTED]> wrote:
The application needs to be available to about twenty users on a daily
Lenster wrote:
I would like to know whether - at some point in the future should it be
necessary - I could convert my entire SQLite databases including tables etc
to another RDMS such as MySQL? Is this straightforward or convoluted?
The .dump command in the sqlite shell will dump your entire
Thanks for your reply Richard
After further Googling and reading the replies I've received here I am
coming around to the idea that SQLite probably is the best choice.
I would like to know whether - at some point in the future should it be
necessary - I could convert my entire SQLite databases
Lenster <[EMAIL PROTECTED]> wrote:
>
> The application needs to be available to about twenty users on a daily
> basis, with most of those users making no more than five 'write'
> transactions a day, and around twenty 'read' transactions a day.
>
The SQLite website is itself backed by SQLite.
Sqlite works very well for web applications unless they are large and
very busy. It is easy to manage and backup and performs well.
For a larger scale operation PostgreSQL would be a better choice than
MySql. If you design your application with care you could switch from
Sqlite to PostgreSQL
2006 6:59 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Most appropriate Web based database? (Newbie)
>
>
>
> Thanks Guys
>
> I appreciate the input.
>
> >Denis Sbragion
> >how critical and complex is the data stored?
> Well the data IS c
Hello Len,
On Thu, April 6, 2006 13:58, Lenster wrote:
> 1) Googling PostgreSQL produced 52,700,000 hits, Googling MySQL produced
> 397,000,000 hits
...
well, this is quite a poor comparison. On the Internet there are many articles
comparing MySQL vs PostgreSQL vs other database engines. As a sta
Thanks Guys
I appreciate the input.
>Denis Sbragion
>how critical and complex is the data stored?
Well the data IS critical but NOT complex
>Gerhard Häring
>From what you have said Gerhard it seems that SQLite is probably upto the
job, however MySQL or PostgreSQL will be more futureproof should
Lenster wrote:
I am investigating which would be the most appropriate RDMS to use for
a new Intranet based application. I have rounded down my choice to two
candidates - SQLite and MySQL.
Ok. I think that PostgreSQL and Firebird are almost always better
choices than MySQL for a database syst
Hello Len,
On Thu, April 6, 2006 10:49, Lenster wrote:
...
> Would I be correct in assuming that MySQL is a safer (longterm) bet?
how critical and complex is the data stored? If it's fairly critical and/or
complex (many tables with relations between them) PostgreSQL may be an even
better choice.
Hi Lenster,
For a Web application you are probably better off with MySQL, it runs as
a seperate process and handles multiple threads really well. I'm
probably going to offend the sqlite people out there, but sqlite is
fantastic for an embedded database, and a web app is not what I would
call
19 matches
Mail list logo