FlatDB – database designed to persist data using just PHP and flat-files • Hacker News Board

Re: FlatDB – database designed to persist data using just PHP and flat-files

#11

Post by throwaway2016a » Thu, May 12, 2016, 4:22 PM UTC

voaie wrote: post #10

throwaway2016a wrote: post #3

At what point does it stop being a flat file and start being an actual database albeit one implemented in a bit of a round about way? With that said, PHP has sqlite support built in since 5.0 and sqlite3 since 5.3 so I see no reason to use this over that. Maybe the author can elaborate. I remember writing code to do stuff like this in C way back when because there were literally no other choices. Also, why is this on…

This is useful for some free web hosting sites with some limits (if file creation is not forbidden ;), also useful for simple personal blog system (composer is unnecessary). Well, not great, but usable. The write method is not reliable for asynchronous operations.

You don't need composer on the server you are running it on to still benefit from package management. You just do an install then deploy your vendors director.

Re: FlatDB – database designed to persist data using just PHP and flat-files

#12

Post by throwaway2016a » Thu, May 12, 2016, 4:28 PM UTC

maxko wrote: post #9

throwaway2016a wrote: post #3

At what point does it stop being a flat file and start being an actual database albeit one implemented in a bit of a round about way? With that said, PHP has sqlite support built in since 5.0 and sqlite3 since 5.3 so I see no reason to use this over that. Maybe the author can elaborate. I remember writing code to do stuff like this in C way back when because there were literally no other choices. Also, why is this on…

As I mentioned in other comments, it's not an replacement for SQLite or any other database engine. I created this script for my own needs and shared it because it may be useful for other developers.

Yeah, and I mentioned, I appreciate anyone contributing to open source so I actually feel a little bad being critical. I was just wondering what the use case is. Especially since Sqlite3 is installed by default (probably also on shared hosts) and has the same requirements (all it needs is the ability to read and write a file).

Aside from that, I'm leery of Hacker News being a place where brand new open source contributions gets submitted (regardless of quality). There are other places for that.

Re: FlatDB – database designed to persist data using just PHP and flat-files

#13

Post by throwaway2016a » Thu, May 12, 2016, 4:35 PM UTC

maxko wrote: post #8

Volt wrote: post #7

Earlier quoted context omitted.

When is it not an option?

Please correct me if I'm wrong but SQLite database could be downloaded from web-browser. There is a some ways to prevent it by keeping db files above www/ dir or via htaccess, however what you will do if you have only limited access to www/ folder and .htaccess aren't supported?

The server you are describing I have never seen... even in the 90s. I have never seen a server where .htaccess was disabled AND you couldn't go one level up from www/public_html/htdocs/etc.

So now curiosity has gotten the best of me... is this a private lan or something? The only thing I can think of it is one of those situations where a University gives you a website but it is really really locked down.

Also, try starting it with a dot (".mytest.html") as a lot of servers prevent hosting up files that start with a dot.