All Questions
Tagged with database-design spatialite
2 questions
0
votes
1
answer
2k
views
Adding“last modified” and “created” column in SQLite/SpatiaLite table
I am designing a new db schema for a SQLite/SpatiaLite database.
Each table should get two extra columns called modified and created which should be automatically change as soon a row gets inserted ...
4
votes
2
answers
1k
views
What's a good way store borehole data in SQLite / SpatiaLite?
I have a bunch of bores / wells with downhole data. The 'header' info for each borehole can easily go into a single table, but I'm wondering how best to store the downhole log data. Typically they are ...