Hey all.
I have been playing around with nginx lately on my lan, attempting to dive into PHP development again.

When it comes to storing and accessing data, what options are available?

I have never really liked MySQL (or the SQL syntax in general), and i have had hours of headaches trying to write my own flat-file storage system.

I recently looked at SQLite which seems nearer to what i am looking for, although it feels just as awkward as any other SQL database management.

I'm looking for a lean database system (no cruft, no bloat) that can tie in with php/nginx easily. Anyone have ideas/experience with something entirely different to the SQL syntax?

I have no idea what you mean by "cruft" and "bloat", but how about MongoDB?

There's (roughly) 3 ways of 'storing data' in a 'database' that are currently popular.

1. SQL: very handy if you need reliable txns https://en.wikipedia.org/wiki/ACID
2. so-called 'No-SQL' like mongodb - personally I find the syntax a bit fiddly but YMMV
3. flat file - write your own code.

At the end of the day, if its anything other than trivial store/lookup stuff, you're going to have to put some effort in.

I suggest you carry on with your research until you find a method that suits you.

HTH

Maybe i worded that wrong
I was trying to say, something like a small library would be more preferable than running a server/daemon/client etc. As the reason why i try to like sqlite more than (for example) MySQL.


Thanks! I will look into NoSQL, i've heard the term before but it wasn't coming up in searches. Cheers.