Hot answers tagged

5 votes

Python SQL insert to MSAccess with VBScript

I'm stuck in the same situation (managing a database with MS Access frontend), so I can't comment on the technologies used here. However, for the VB Script itself, I highly recommend parameterizing ...
ApexPolenta's user avatar
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
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

Only top scored, non community-wiki answers of a minimum length are eligible