Hacker News Reader

Comment by cocktailpeanuts | Hacker News Reader

Would be nice to hear how this is database-free. Is it a static site generator? Is it using files?

Why not use a real database ? Files are slow !

Do browsing this page feel slow ? Try browsing older pages, too.

It's not slow at all, is it ? And don't forget the database contains more than 16000 links, and it's on a shared host, with 32000 visitors/day for my website alone. And it's still damn fast. Why ?

The data file is only 3.7 Mb. It's read 99% of the time, and is probably already in the operation system disk cache. So generating a page involves no I/O at all most of the time.

http://sebsauvage.net/wiki/doku.php?id=php:shaarli#why_not_u...

FTA:

  links are stored in a file
    - compact storage
    - no database required
    - easy backup: simply copy the datastore file

That's still a database if you ask me. Just a different type.

Hosting wise it isn't

Who said databases have to be remote?

The "datastore" is a gzip+base64-encoded serialized PHP object written to a file.

PHP has SQLite built-in, which has the same single-file property with a lot better durability, portability, and stability guarantees.

SQLite would be nowhere near the current design in term of performance. Typical shaarli usage involve little update (a dozen a day maximum) an a lot of read (10k+ pages viewed per day on sebsauvage's instance (shaarli's creator, an influent french blogger). Thé file system's cache works really well in this kind of scenario, way better than SQLite.

For the stability guarantees, shaarli exists since 2011 and is used in production by many (several hundred) people without trouble.

Well since sqlite is also single file, would it really decrease file system cache efficiency ?

The crucial distinction as far as the OP is using the term seems to be that such a datastore does not require the user's hosting provider to give them an instance of any of the common DB servers, which typically needs a more expensive plan than the usual baseline of "disk space and an httpd [that supports calling out to one or two scripting languages]".

(Basically it should run on anything more complex than a static site host. Though it's also true that sqlite would probably be a cleaner choice for the datastore without losing any of that benefit.)

Reply on news.ycombinator.com