News for hackers. Stuff that matters.
Re:Show HN: 10 Years to Build a Free SQL Editor by numlocked on Monday June 03, 2024 @09:32AM (#40562465)
Hi - I am trying to run this on an Intel Mac. I got it to launch once, and attempted to open a small (~30mb) sqlite DB, and got a crash. It now hangs/freezes as soon as the application opens (taking over > a full core of CPU e.g. 120% plus utilization in Activity Monitor), even after deleting and re-downloading the .jar file. Any ideas? Would love to check this out!

edit: Apple silicon, which I note because the process type in activity monitor is 'Intel'

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.