search

danpros / htmly

Simple and fast databaseless PHP blogging platform, and Flat-File CMS
https://www.htmly.com
GNU General Public License v2.0
1.1k stars 268 forks source link

SQlite3? #145

Closed Xarcell closed 9 years ago

Xarcell commented 9 years ago

Has there ever been consideration for SQLite3? It would still be a flat-file system, just not database-less.

ncang commented 9 years ago

i don't know, just see the tagline "Databaseless Blogging Platform"

Xarcell commented 9 years ago

Some advantages would be that it's quicker, and if your site ever outgrows it you can always port it to MYSQL. Currently like it is or with SQlite, you'll start seeing performance issues after daily 100K views 1K online at once. That's not something most bloggers have to worry about, but then 100K/1K isn't really alot either.

It's just an adjustment solution I think. Gives HTMLy the ability to grow with you.

Xarcell commented 9 years ago

It's true adopting SQLite would mean it's no longer database-less, but it still means it's just a file and there no database to setup. Most major entities are adopting SQLite: Mozilla Firefox/Thunderbird, Google Business Apps, Adobe Reader/Lightroom, Dropbox, Skype, Apple iProducts, Microsoft Games, etc...

The only big issue is the db file gets locked when being written to. So comments could be an issue, but if your using FB/Disqis comments then there's no problem.

ncang commented 9 years ago

my record on HTMLy is more than 500 online at once (real / no bot) . You know what happened? server down, when upgrading everything goes back to normal.

fahmi182 commented 9 years ago

HTMLy have cache static, 500 online on vps 512MB Ram, only 30% Cpu used. :)

Xarcell commented 9 years ago

I'm still a fan of SQLite. However, there are plenty of other blogs that support sqlite3, but not that many that support file upload. After more careful consideration, I think HTMLy should stay as it is. So I'm gonna close this issue.