I need really basic storage in a small php web app, only one table (~300 records). I generally use something as postgres but in this particular case, doesn't want to deal with install and backup. I was thinking about firebase as it is free, what do you recommend ?
Firebase would definitely be a good candidate specially for a simple data structure
Firebase recommends a denormalized data structure, as flat as possible. This can be a nightmare to manage though if you have a complex system. For example, if you update a user's information, you have to make sure to update it in all nodes where it might exist. For this, Firebase supports multi-path updates
for future reference: sqlite. serverless sql databases offering in-process speed and low overhead. Especially good for loads of reads (cached stats, scores, historical data etc), less interesting for heavy write-to databases (session databases, chat storage) due to lack of proper locking required for multi-write access.
But quite good for development and quad solutions.
sivaram
Giving life to Ideas
yup you can definitely use firebase cloud firestore or realtime db. But just make sure you don't require a complex querying of records. Both firestore and realtime lacks that ability.