Re:Show HN: 10 Years to Build a Free SQL Editor
by numlocked on Monday June 03, 2024 @09:37AM
(#40562507)
Ah! I figured it out. User error. I had hit "open file" instead of "open database" and the application decided to open the 30mb sqlite DB as text (e.g. a sql query), including syntax highlighting. Simply letting it grind away for 10 minutes or so allowed it actually open the file, at which point I could close the tab and performance is back to normal. Look forward to experimenting!
Re:Show HN: 10 Years to Build a Free SQL Editor
by jchw on Monday June 03, 2024 @10:50AM
(#40563181)
Hey, that's some amazing QA work. If I were the developer, I'd add a quick check to see if the file appears to be a SQLite database and do something useful in that case.
Re:Show HN: 10 Years to Build a Free SQL Editor
by semi on Monday June 03, 2024 @10:39PM
(#40570166)
Probably good to have some basic checks too if it's expecting a text file of SQL queries- like a dismissible warning if it's over a certain size or doesn't appear to be plain text
Re:Show HN: 10 Years to Build a Free SQL Editor
by RyanHamilton on Monday June 03, 2024 @12:51PM
(#40564547)
Thanks for letting me know and great QA. Another user reported this just last week and I hopefully have it fixed: https://github.com/timeseries/qstudio/issues/49 qStudio 3.04+ now only opens .sqlite/.db/.parquet as data files not for text editing.
edit: Apple silicon, which I note because the process type in activity monitor is 'Intel'