Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.
The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.
-Sterling
"A business that makes nothing but money is a poor kind of business."
- Henry Ford
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.
We should add
--without-kitchen-sink
to disable all these new bundled extensions.
George
At 10:38 PM 6/22/2003 -0400, Sterling Hughes wrote:
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.
On one hand I think having 1.5MB in our release tree is quite a lot (can
anything be removed)? On the other hand, I think bundling and enabling this
by default will really help lots of small users who have a web account but
no DB access.
So I'm around a +0 :)
Andi
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
i object strongly. sterling, why have you gotten into the
enable-all, bundle-all mode lately? what do you gain?
thies
>
> > Hey,
> >
> > Unless anyone objects I'm going to enable the sqlite extension by
>
> i object strongly. sterling, why have you gotten into the
> enable-all, bundle-all mode lately? what do you gain?
>
Well, I wouldn't say I'm in the enable-all, bundle-all mode. But I'll
talk a little bit about why SQLite is über-cool, and why I think should
always be enabled.
Many times in PHP you don't really need a RDBM. Whether its building a
weblog system, writing a Polling system, or a small content management
system. In these cases many people either misuse a RDBM, causing major
headaches, or they use flatfiles, which cause even larger headaches.
Whoops, I forgot to lock. Whoops, I used `fread()` on 20k of data, when I
only need 2k. Whoops, I seek'ed through an entire directory, searching
for a file. Whoops, this is getting annoying, isn't it? ;-)
In these cases, where you don't have the necessity of a transaction
based environment, and you aren't write-heavy, SQLite is a godsend. It
provides a very intelligent file management and indexing system, coupled
with a data abstraction interface - SQL. I imagine SQLite to be used
inplace of custom flatfile systems, and custom flatfile management. Its
a small, low-level library that manages optimizes and manages file
access and manipulation.
Did I mention it also cooks your toast?
The second reason I want this enabled by default is that SQLite is the
end-to-end solution. No database server required. This means when
installed on shared hosting providers, they don't have to worry about
permissions management, performance issues, access partitioning,
replication, etc. You as the PHP user also don't need to worry about
not having an SQL-esque solution available (it supports a larger subset
of ANSI 92 then MySQL btw). SQLite is very respectful of permissions,
etc. And, we can make it respect PHP safe mode, open base dir, etc.
This makes it very shared host friendly.
So why bundle and enable by default?
Well three reasons.
a) It provides a very low memory footprint. Its initialization costs
you nothing, and it only hurts you if you use it. Compare this to
libmysql which caused 13% of total execution time in CGI mode, just to
find the MySQL port (I fixed this, but still).
b) Its a very small code size. Compare sqlite and mbstring for
example. 1.9 mb, for the PHP extension, and the source code is
absolutely nothing.
c) In order for it to be useful for shared hosts, it needs to be always
enabled. SQLite isn't yet very popular, and not many people know about
it. Having something like this always available can be a great boon to
portable application development with PHP.
-Sterling
--
"A business that makes nothing but money is a poor kind of business."
- Henry Ford
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.
I've no problem if we distribute it by default, but I'm not sure if we
need to enable it by default.
Derick
--
"Interpreting what the GPL actually means is a job best left to those
that read the future by examining animal entrails."
Derick Rethans http://derickrethans.nl/
International PHP Magazine http://php-mag.net/
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.
+1
Best regards,
Per Lundberg / Capio ApS
Phone: +46-18-4186040
Fax: +46-18-4186049
Web: http://www.nobolt.com
I think it's a good idea.
Zeev
At 05:38 23/06/2003, Sterling Hughes wrote:
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.-Sterling
"A business that makes nothing but money is a poor kind of business."
- Henry Ford
-1
As always I'm against any enable by default thinking.
Why, oh why, are we making this wonderful configure script
completely useless?
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.-Sterling
---------------------------------------------------------------<
Dan Kalowsky "I'll walk a thousand miles just
http://www.deadmime.org/~dank to slip this skin."
dank-nom@aps-deadmime.org - "Streets of Philadelphia",
kalowsky@php.net Bruce Springsteen
As always I'm against any enable by default thinking.
Why, oh why, are we making this wonderful configure script
completely useless?
In a perfect world nothing would be enabled by default and each user would
enable just the extensions they wont. In reality however, most people use
shared webhosts and have no control over PHP and in many cases web hosts will
refuse to modify their PHP installation. The same webhosts (judging from my
personal experience with at least 4-5 dosen hosting companies) usually rely
on the default configuration options, with only non-default options being the
ones relating to safe_mode. What this means if we disable MySQL by default,
the stock php will no longer come with a built-in database support. This IMHO
is very bad, since large number of php scripts require a database of some
sort.
Enabling by the extension by default would also accelerate it's addoption by
distributable script authors, who won't have to worry about availability of
the extension. I think we can all agree that MySQL's popularity with PHP is
largely the result of it nearly always being avaliable.
Ilia
Where/when it was decided to be included in the main
distribution in the first place?
--Jani
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.-Sterling
Nevermind, I was just wondering about the PHP_4_3 branch
having it too, but that's propably just temporary thing.
--Jani
Where/when it was decided to be included in the main
distribution in the first place?--Jani
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.-Sterling
--
https://www.paypal.com/xclick/business=sniper@php.net&no_note=1&tax=0¤cy_code=EUR
Yeah, I was surprised to see it on the 4_3 branch as well. I don't think
it should be there.
I would like to suggest a 4.4 release at some point after we get 4.3.3 out
the door with the aim being to bridge users from 4.x to 5.x. It would
look as much like 5.x as is feasible, but be based on the 4.x codebase so
people will have an easier migration path and we spread the pain out a
little bit. And sqlite would fit into such a release quite well.
-Rasmus
Nevermind, I was just wondering about the PHP_4_3 branch having it too, but that's propably just temporary thing. --JaniWhere/when it was decided to be included in the main
distribution in the first place?--Jani
Hey,
Unless anyone objects I'm going to enable the sqlite extension by
default for PHP5. The extension comes with the bundled sqlite library
which is 1.5mb in total (cd ext/sqlite/libsqlite/src/; du -ch *.c *.h),
and is a good alternative to using MySQL for small sites.The sqlite library is licensed to the public domain and provides a
complete database solution in a small library - no server required. For
more information take a look at http://www.hwaci.com/sw/sqlite/.-Sterling
--
https://www.paypal.com/xclick/business=sniper@php.net&no_note=1&tax=0¤cy_code=EUR