New answers tagged

2 votes

SQLite querybuilder class in python

It's good that there is some logging built-in, but this is not the right way to do it. It is inflexible: the output goes to a file (console is useful for debugging) and the format cannot even be ...
Kate's user avatar
  • 6,400
2 votes

SQLite querybuilder class in python

version use Python 3.6 I'm still not believing the constraint, given that interpreter should come from a venv rather than from /usr/bin, but fine, let's roll with ...
J_H's user avatar
  • 22.1k
0 votes

Improving efficiency of database searches under SQLite (SpatiaLite - QGIS)

I have grouped my databases. Now I have BDC_STAT and BD_TAXREF to search into. I like this way because I don't have to specify the value in the field "COMPART". It is more practical. But in ...
Giene's user avatar
  • 121
2 votes

Improving efficiency of database searches under SQLite (SpatiaLite - QGIS)

I've always heard that[SQL] is a very efficient way of searching databases. Yes. It can be. When used carefully. try and improve the execution speed of my triggers To be clear, procedural logic ...
J_H's user avatar
  • 22.1k

Top 50 recent answers are included