All Questions
3 questions
5
votes
2
answers
782
views
Searching for a word in a list of tuple extracted from a db via SQL
Python 3.6 and Sqlite3.
I have a database with something like 300K entries, each entry has several fields (date, username, etc) and a "text" one. I have a list of 200 words and for each word i have ...
- 249
3
votes
1
answer
2k
views
Transforming stored procedures using Python regular expressions
I have to add some extra logic to about 80 similar stored procedures on my DWH server.
I thought that it would take pretty much the same time if I do it with Python and lots of googling (I have no ...
- 133
5
votes
2
answers
135
views
Replacing MySQL's AUTO_INCREMENT with Postgres' SERIAL
I am making changes to a Python script that converts MySQL scripts to PostgreSQL, and I want to replace strings such as id INTEGER NOT NULL AUTO_INCREMENT with <...
- 153