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

FlatDB – database designed to persist data using just PHP and flat-files(github.com)

5 points by maxko 10 years ago | 12 comments

throwaway2016a 10 years ago |

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 Hacker News?

Edit: I do, however, applaud any effort to contribute to the open source community. However, for anyone to trust this they would need unit tests and a composer package on Packagist.

voaie 10 years ago | |

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.

throwaway2016a 10 years ago | | |

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.

maxko 10 years ago | |

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.

throwaway2016a 10 years ago | | |

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.

mhuffman 10 years ago |

There is already a super-fast flat-file database system that supports sorting (alphabetically and timestamps), ultra-fast lookup and retrieval, and optimized caching -- it's called a filesystem.

creshal 10 years ago |

So why this and not SQLite? Just to save the dependency? What makes it "secure"?

tmikaeld 10 years ago | |

Also curious about performance, SQLite is very mature and VERY fast.

maxko 10 years ago | |

Sometimes SQLite is not an option and I created FlatDB for my own needs. This is not a replacement for SQLite or other database engine.

Volt 10 years ago | | |

When is it not an option?