CariDotMy

 Forgot password?
 Register

ADVERTISEMENT

View: 2557|Reply: 2

SQLite..Anybody?

[Copy link]
Post time 12-7-2006 12:50 AM | Show all posts |Read mode
Have any body tested/played around with SQLite?
SQLite ni dibundle sekali dengan PHP 5. Tak payah server SQL lain. Ada PHP5 boleh pakai SQLite terus. Database on your file system.
Ingat nak build website guna benda nih.
Reply

Use magic Report


ADVERTISEMENT


Post time 12-7-2006 10:26 AM | Show all posts
Ada download hari tu ngan PHP5 tapi tak guna tu sebab dah ada SQL. Ko cubalah and citer kat sini apa2 kelebihan/kelemahan SQLite tu.
Reply

Use magic Report

Post time 12-7-2006 12:41 PM | Show all posts
Aku pun tak pernah cuba.
Tapi dari website http://www.zend.com/php5/articles/php5-sqlite.php

Introduction
In recent months you have probably heard about the new database extension for PHP: SQLite. By most accounts SQLite seems to be the best thing since sliced bread, offering a fast SQL interface to a flat file database, and creating an elegant alternative to bulky database interfaces, without the functionality or speed loss one might expect. In this article we will explore this wondrous new extension, and hopefully validate some of the benefits it is rumored to have.


What is SQLite?
SQLite is an embedded database library that implements a large subset of the SQL 92 standard. Its claim to fame is the combination of both the database engine and the interface (to said engine) within a single library, as well as the ability to store all the data in a single file. I terms of functionality SQLite resides somewhere between MySQL and PostgreSQL. However, when it comes to performance, SQLite is often 2-3 times faster (or even more). This is thanks to a highly tuned internal architecture, and the elimination of server-to-client and client-to-server communication.

All this is combined into a package that is only slightly larger than the MySQL client library, an impressive feat considering you get an entire database system with it. Utilizing a highly efficient memory infrastructure, SQLite maintains its small size in a tiny memory footprint, far smaller then that of any other database system. This makes SQLite a very handy tool that can efficiently be applied to virtually any task requiring a database.

What's in it for me?
Besides speed and efficiency SQLite has a number of other advantages that make it an ideal solution for many tasks. Because SQLite's databases are simple files, there is no need for administrative staff to spend time creating a complex permission structure to protect user databases. This is automatically handled by file system permissions, which also means that (in space restricted environments) no special rules are needed to keep track of user disk space. The users benefit from the ability to create as many databases as they desire and have absolute control over those databases.

The fact that a database is just a single file makes SQLite very portable across servers. SQLite also eliminates the need for database daemon processes that could eat significant amount of memory and other resources, even when the database system is liberally used.



http://sqlite.org/speed.html

Executive Summary
A series of tests were run to measure the relative performance of SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41. The following are general conclusions drawn from these experiments:

SQLite 2.7.6 is significantly faster (sometimes as much as 10 or 20 times faster) than the default PostgreSQL 7.1.3 installation on RedHat 7.2 for most common operations.

SQLite 2.7.6 is often faster (sometimes more than twice as fast) than MySQL 3.23.41 for most common operations.

SQLite does not execute CREATE INDEX or DROP TABLE as fast as the other databases. But this is not seen as a problem because those are infrequent operations.

SQLite works best if you group multiple operations together into a single transaction.

The results presented here come with the following caveats:

These tests did not attempt to measure multi-user performance or optimization of complex queries involving multiple joins and subqueries.

These tests are on a relatively small (approximately 14 megabyte) database. They do not measure how well the database engines scale to larger problems.
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

 

ADVERTISEMENT


Forum Hot Topic
...BYE 2024, HELLO 2025...
seribulan...BYE 2024, HELLO 2025...
Views : 54993 Replies : 13
...AZAM TAHUN 2025...
seribulan...AZAM TAHUN 2025...
Views : 55522 Replies : 25
[Netflix 2021] SQUID GAME Season 1,2,3 - Lee Jung Jae, Lee Byung Hun, Wi Ha Joon, Gong Yoo ~ 26 Dec 2024 (Season 2), 2025 (Final Season)
Rahah[Netflix 2021] SQUID GAME Season 1,2,3 -
Views : 29125 Replies : 254
...CHAT HUMANITARY...HAPPY NEW YEAR...
seribulan...CHAT HUMANITARY...HAPPY NEW YEAR...
Views : 44248 Replies : 29
V82: HANIS HAIZI B. ABD HAMID Melarikan Diri Dari Bayar Cukai LHDN Ke Los Angeles CA
anony-mousV82: HANIS HAIZI B. ABD HAMID Melarikan
Views : 11125 Replies : 449
New Chapter 01: FATTAH AMIN ~ Bebaskanlah mimpi-mimpi terindah
codenamedreamNew Chapter 01: FATTAH AMIN ~ Bebaskanla
Views : 47200 Replies : 1958
siri ikonik Korea, Squid Game 2 ditayangkan di Neflix hari ini
YgBenarsiri ikonik Korea, Squid Game 2 ditayang
Views : 13087 Replies : 5
Instafamous Rempit (kak yah, kak zah & the geng) part 3
hotmakInstafamous Rempit (kak yah, kak zah & t
Views : 232317 Replies : 1832
madu gula tok matahari
aaanf14madu gula tok matahari
Views : 109982 Replies : 1152
Acikpor vs. Ngai, isu tajaan MARA dikorek
maklukpenggodaAcikpor vs. Ngai, isu tajaan MARA dikore
Views : 52274 Replies : 1477

 

ADVERTISEMENT


 


ADVERTISEMENT
Follow Us

ADVERTISEMENT


Mobile|Archiver|Mobile*default|About Us|CariDotMy

28-12-2024 06:51 AM GMT+8 , Processed in 0.044592 second(s), 17 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

Quick Reply To Top Return to the list