joanolo questions

joanolo answers

• Scalable way to search for (similar) strings in a database
• Returned data type information_schema.identifier does not match expected type
• Postgres aggregate results based on 2 columns
• 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