Flat file database layer

[joho1968]

Considering the speed and "lightweight-ness" of Flight, wouldn't a "flat file database" class/module be a perfect fit? Storing stuff in JSON encoded files, possibly in a designated directory (optional)? I'm just thinking out loud ...

I get that "AnySQL" DB is a great idea for more complex applications, but for smaller things, maybe JSON encoded text files would further improve Flight's exposure to smallish and fast things.

Or, perhaps this is a very implementation dependent issue? 🤔

[n0nag0n]

I don't hate the idea. You're talking about something similar like Fat Free's Jig component? https://fatfreeframework.com/3.9/jig I'd also have to think through if that's a core component or if that is a different package altogether.

[joho1968]

Yeah, something similar to that. I personally believe that "flat file database" functionality is a good idea to have in core since storage/retrieval is part of most apps. Not having to mess around with "AnySQL" is nice. But I get that you may want to keep the "core" as tight as possible.

[n0nag0n]

Was thinking more about this today, and wondered if an existing library will scratch the itch and we can put it in the documentation for the site as a plugin? https://sleekdb.github.io/ Is one I found that seems robust and simple.