Skip to main content

New answers tagged

3 votes
Accepted

Database schema for project management app

not null As a general rule of thumb, I always encourage folks designing a new schema to automatically tack on a NOT NULL column constraint. Sometimes it will prove to be a mistake, in which case you ...
J_H's user avatar
  • 30.8k
0 votes

QGIS - SpatiaLite - Getting info from contained and nearest features

As you recommended, I added the pk (or id / pkuid) values in my code (this is how I understand it) and worked on a small sample. This indeed helped me understand some of my mistakes, and now the ...
Giene's user avatar
  • 159
1 vote

QGIS - SpatiaLite - Getting info from contained and nearest features

distinct Names like Dval would be better as d_val. Queries that start out as "only needing sqlite" will sometimes ...
J_H's user avatar
  • 30.8k

Top 50 recent answers are included