4 ms·
This is me learning sqlite basics to start a more ambitious project tracking changes in grafana.
by gwynforthewyn 2y ago
This is me learning sqlite basics to start a more ambitious project tracking changes in grafana.
- tharkun__ 2y agoI'm really sorry as this may sound condescending. It isn't meant like that. I'm just old. As in, when I started my career I worked on an application that was written 15 years earlier. It taught me a lot. As in around 1990. Guess what? It used database triggers to keep a record of every change ever made to any table in an "archive" table. When I joined the project I was able to see every single change any user made ever since the application was built. And yes you very probably bought a product that was planned and administered through that application. So to try and save this post: go learn and explore! I do implore you to try and look around and away from specifics like the technology you are using being SQLite. Look beyond. Look at the concepts. Figure out that things repeat in history. Every generation re-invents some wheels. Recognize them and try to recognize if there are slight differences and improvements in the re-inventions or if it's just more layers upon layers. Or in this case is it just that SQLite is gaining/having more and more features of "real databases" even though it's mostly touted as an "embedded database"?
- gwynforthewyn 2y agoLearning and exploring is what I was sharing in this blog post! I’ve thought of tinkering with sqlite for the last ten years, and I finally did and shared it with you all :)