Will serendipity support flat file?

[skyroam]

I like flat file.And I do not mind efficiency in big traffic.
I am afraid to solve mysql preblems.
So I have only one stable virtual host without sql.
But there is no php blog that works and appears as well as serendipity.
Appreciate for you very much if possilbe!

[nohn]

do you have sqlite support?

[skyroam]

I do not know whether sqlite is available in the server.
I have only a virtualhost id for the server.No shell is aviable.I can only connet to the server by ftp or http.
Is there some way to detect the avialability of sqlite in the server?

I don't think I am so luck.
But it is a chance at all ,I will contact with the administrators of the server if no method can be used to detect
sqlite .

[Guest]

I do not know whether sqlite is available in the server.
I have only a virtualhost id for the server.No shell is aviable.I can only connet to the server by ftp or http.
Is there some way to detect the avialability of sqlite in the server?

I don't think I am so luck.
But it is a chance at all ,I will contact with the administrators of the server if no method can be used to detect
sqlite .

you can. Just put a file on the server named somewhat.php that contains

<?php
phpinfo();
?>

and take a look at that file with your webbrowser

[skyroam]

Oh,thank you.I have forgot this good function,:D
'./configure' '--with-mysql=/usr/local/mysql/' '--with-apxs=/usr/local/apache/bin/apxs' '--with-gd' '--with-zlib' '--with-freetype-dir=/usr/' '--with-png-dir=/usr/' '--with-jpeg-dir=/usr/' '--disable-posix' '--enable-memory-limit' '--enable-zend-multibyte' '--with-iconv' '--enable-inline-optimization' '--enable-magic-quotes' '--enable-ftp'
PHP Version 4.3.10

System Linux vip 2.4.22-1.2199.nptl #1 Wed Aug 4 12:21:48 EDT 2004 i686
Build Date Dec 20 2004 15:57:04

It seemed that sqlit option was not definitely seted .
Does sqlite was compiled in to php4.3.10 by default?

[garvinhicking]

Hi skyroam!

No, SQLite became only default since PHP 5.0. But you can use the PEAR installer to download the PECL sqlite package if you have shell access. Otherwise you're more or less screwed and will need to rely on database backends.

Serendipity is much too advanced to operate on singular flat files, a database emulation like SQLite is really needed.

We won't ever support a custom-made flatfile format, since we rely on SQL...

Regards,
Garvin

[cdrom600]

See http://www.c-worker.ch/txtdbapi/index_eng.php
It looks like it could possibly work with s9y...

[garvinhicking]

txtdbapi does not seem to support LEFT OUTER JOINS and some aggregated functions, which we use.

SQLite is much more suitable for this...

Regards,
Garvin

[jstarkweather]

For high-traffic sites there will always be a need for less interaction with MySQL and blogs loaded as flat HTML. I don't see why this couldn't be done looking at your blog pages. Certainly the backend would need to be PHP driven and allow bloggers to publish their blogs via a flat file.

Until someone figures this out (or I do it myself) I guess I will rely on 3rd party sites to push blogging to my community.

Jim

[garvinhicking]

High-traffic sites should use a generic caching system, and not rely on flatfile DB support. In fact, high-traffic sites will prefer MySQL because it's much faster than flatfiles are, because of internal caching. We support SQLite for this, that's sufficient.

We're talking about flatfile DB support here, not flatfile caching/pregeneration. Pregeneration creates more problems than it solves, see moveableType. A cache like PEAR::Cache is always recommended.

Regards,
Garvin