SQLite?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

SQLite?

Post 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.
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

Post by mudkicker »

no reply? :(
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post 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
Straterra
Forum Regular
Posts: 527
Joined: Mon Nov 24, 2003 8:46 am
Location: Indianapolis, Indiana
Contact:

Post 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
User avatar
mudkicker
Forum Contributor
Posts: 479
Joined: Wed Jul 09, 2003 6:11 pm
Location: Istanbul, TR
Contact:

Post by mudkicker »

thank you for your replies. i think i will start to use sqlite. :)
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post 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.
User avatar
voodoo9055
Forum Commoner
Posts: 51
Joined: Sat Apr 26, 2003 3:27 pm
Location: Montgomery, AL

Post 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.
ilovetoast
Forum Contributor
Posts: 142
Joined: Thu Jan 15, 2004 7:34 pm

Post 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).
Post Reply