5 ms·
> Would take about the same time as integrating SQLite into a system for the same purpose and would be easily extendable to support features as the system grows
by ehvatum 5y ago
> Would take about the same time as integrating SQLite into a system for the same purpose and would be easily extendable to support features as the system grows.
I find it much easier to add features to my post-2007 projects (when I started using SQLite) for the specific reason that I can open the SQLite file in a GUI and pretty quickly see what’s going on with data organization (schema) and how the customer uses the software I wrote (ie by what columns they actually use/misuse).
Prior to that, there’s various versions of my b-tree library and lots of zips, or linear text indexes, or any combination of whatever fit the need. Data storage implementation needs to be reasoned about in detail for each pre-2007 revisit in ways that don’t happen with SQLite projects.
- heinrich5991 5y agoWhat's the UI you use for viewing SQLite files?
- ehvatum 5y agoAt client site to debug issues and deal with things like bulk product name changes https://sqlitebrowser.org/ https://sqlitebrowser.org/ For more involved work that I do at my shop or on my laptop, DataGrip by Jet Brains is great. Before I got fed up with Apple, I used https://menial.co.uk/base/ https://menial.co.uk/base/ DataGrip’s benefit to me is mainly reworking a customer DB at the ER diagram level, then I manually update my code to match.
- ehvatum 5y agoBy the way, SQLite started out as a TCL extension. It works really well in TCL and good old TCL/TK/SQLite gets CRUD done fast. I almost feel bad looking so heroic.