Page 1 of 1

SQLite?

Posted: Sun Feb 15, 2004 4:12 am
by mudkicker
Hi people!

I just read on php.net that PHP 5 beta 4 is realeased and i just wanted to look at SQLite's website but i don't have any clue to use this new database. We can still use mysql but it's not bundled, i know that.

but...

should we continue using mysql or sqlite is better and try to learn how to code to use it?

any info about it will be appreciated. thank you.

Posted: Sun Feb 15, 2004 1:43 pm
by mudkicker
no reply? :(

Posted: Sun Feb 15, 2004 2:42 pm
by patrikG
Whether or not to stick with mySQL is up for discussion - individually. The licensing change means that you can still develop open source/free PHP applications, but if you are developing them for commercial purposes, you'd have to pay license fees. If PHP bundled with MySQL is a hobby to you - stick with it. If you earn your living with it: think about Postgres or SQLite or any of the other free databases.

There is a nice discussion here: http://www.sitepoint.com/forums/showthread.php?t=115514

and quite indepth look at SQLite at:
http://www.hwaci.com/sw/sqlite/lang.html

Posted: Sun Feb 15, 2004 3:36 pm
by Straterra
I currently use SQLite because my server is too slow to run MySQL. It is usefull for smaller applications and I even wrote a music management system with SQLite. I would be more than happy to answer any questions you may have about SQLite, but I 100% recommend it!


The link for my management system is viewtopic.php?t=16773 or http://eckclan.sytes.net/music.php

Posted: Sun Feb 15, 2004 4:22 pm
by mudkicker
thank you for your replies. i think i will start to use sqlite. :)

Posted: Sun Feb 15, 2004 7:32 pm
by McGruff
I don' know what they think they're going to achieve except a widespread move to firebird or postgres - possibly no bad thing.

Posted: Mon Feb 23, 2004 1:07 pm
by voodoo9055
I just want to know one thing. Would I need to install something on my web host to get sqlLite to work?

I am writing PHP scripts for the sole purpose of making money off of it. Any other reason is a waste of my hard earned time.

Posted: Mon Feb 23, 2004 8:55 pm
by ilovetoast
First off, I for one am enthusiastic about SQLite and the bundling switch for PHP. It is an awesome db that is more than enough for 75%+ of all PHP projects I've ever seen/heard of. It is more than enough to handle virtually anything you did with MySQL.

The few things it doesn't do, MySQL doesn't really do well anyways. MySQL is not a true RDBMS, as everyone here knows. If you truely need an RDBMS you shouldn't be using MySQL anyways. Postgres or Sybase or Oracle or Frontbase or any of several others are better options.

Only problem is really for Winblows server users. SQLite works great on Winblows. Postgres does not. Oh well, add that as reason number #598 why I thank God every day I don't use Winblows.

To answer your question voodoo, yes. You have to have SQLite somewhere, just as with MySQL you have to have MySQL somewhere. It is a tiny thing and I assume it will be bundled with PHP5 (I'm not sure as I haven't touched the beta).