Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

sqlite

Codes here !

Moderators: macek, egami, gesf

sqlite

Postby markie » Wed Jul 16, 2003 1:32 am

Anybody tried sqlite yet?

markie
markie
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Jul 16, 2003 1:29 am

Postby Oleg Butuzov » Wed Jul 16, 2003 3:39 am

i have download sqlite and php 5 but ididnt work with this stuff yet. But as i now google use this db.
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am

Postby swirlee » Wed Jul 16, 2003 7:26 am

Pejone wrote:But as i now google use this db.


No, they don't. I don't know what they do use, but you can be 100% certain that it's not SQLite. SQLite is not designed to handle huge databases (Google's database is many, many GB) or large numbers of simultaneous connections, both of which are essential to Google. Not to mention that it's typeless, which isn't a big deal for little databases (and makes a programmer's job a little easier sometimes), but can cause a huge performance hit on big databases (in most databases, the data structure for a particular column type is optimized for that data type, but in a typeless database such optimization is impossible).

Okay, I did a little searching (on Google :wink:) and found this article that claims that Google built their database software from scratch. Which makes sense. The article says that it's a flat-file database, though, which surprises me. No idea how accurate the article is.

Erp. Now I found a number of articles that claim that Google uses MySQL for "some parts" of their site. I'm guessing, though, that they still use a homebrew database to store the actual "guts" of the search database.
User avatar
swirlee
Moderator
Moderator
 
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

still curious

Postby markie » Wed Jul 16, 2003 8:05 am

ok, that is interesting... but I'm still curious as to how to connect to sqlite using php..is this possible?

cheers
markie
New php-forum User
New php-forum User
 
Posts: 2
Joined: Wed Jul 16, 2003 1:29 am

Postby swirlee » Wed Jul 16, 2003 8:13 am

Until PHP5 is out, I recommend using the PEAR SQLite library:
http://pear.php.net/package-info.php?package=SQLite
User avatar
swirlee
Moderator
Moderator
 
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

Postby Oleg Butuzov » Wed Jul 16, 2003 9:32 pm

Thanks sweerle. =)
Oleg Butuzov
Last Samuray
Last Samuray
 
Posts: 831
Joined: Sun Jun 02, 2002 3:09 am


Return to mySQL & php coding

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.