Baptiste Mispelon on Nostr: Today I find myself having to parse ~1 million SQL queries (of various complexity) ...
Today I find myself having to parse ~1 million SQL queries (of various complexity) using #python
Here's a runtime of the few options I tried, in case anyone is interested (incidentally, in the order in which I tried them):
- sqlparse: 1h estimated (I killed the process before it finished)
- sqlglot: finished in about 15 min, failed to parse about 900 queries.
- sqloxide: finished in 2 minutes (!!!), failed to parse 10 queries. 🏆
Here's a runtime of the few options I tried, in case anyone is interested (incidentally, in the order in which I tried them):
- sqlparse: 1h estimated (I killed the process before it finished)
- sqlglot: finished in about 15 min, failed to parse about 900 queries.
- sqloxide: finished in 2 minutes (!!!), failed to parse 10 queries. 🏆