Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
peter_msd's user avatar
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 ...
a different ben's user avatar