joanolo questions

joanolo answers

• Slow regex query on 80M record in PostgreSQL
• Producing date from year and month values in PostgreSQL
• SQL join arbitrary information to form a mixed list
• MySQL calculate time difference between multiple rows based on status field
• Database structure and queries for a Twitter-like posts timeline
• Can a View of multiple tables be used for Full-Text-Search?
• Insert POINT into postgres database
• Populate random data from another table
• PostgreSQL - Right Index choice for a status field (varchar)
• Postgresql parallel bulk INSERT with worker don't parallelize