RyanHamilton

12 ms·

1. 91.▲
   by RyanHamilton 2y ago

   Thanks. I've opened an issue to fix the text https://github.com/timeseries/qstudio/issues/55 . The binary file issue should definitely be fixed in 3.04+ >>The interface is highly non-idiomatic Ouch
2. 92.▲
   by RyanHamilton 2y ago

   Woops. Definitely not a consultancy. We make and sell software. The graphic I think you seen had been on the page for years as it came as part of the website template. I had mentally just been blocking it out without realising. I've no
3. 93.▲
   by RyanHamilton 2y ago

   I originally built it for myself to use with one niche database that had no IDE support at all. I then gave it to my team and then others. Years ago I began to sell it and I still have large banks and finance firms that pay to use it with t
4. 94.▲
   by RyanHamilton 2y ago

   Massive thanks for this. I've opened an issue to ensure I improve this: https://github.com/timeseries/qstudio/issues/54 To be honest I've delayed improving Mac as I don't use the platform mysel
5. 95.▲
   by RyanHamilton 2y ago

   Thanks! I think I'm mostly benefitting from it being so old and hardware has got so much faster.
6. 96.▲
   by RyanHamilton 2y ago

   Have you seen much end user feedback on the usefulness of this area? I only just added the AI functionality but even using it myself, I'm still unsure if I will keep using it longer term. Mostly I just use i tto spit out a few sample q
7. 97.▲
   by RyanHamilton 2y ago

   Thanks. I have opened an issue. I do test on Mac but I'll need to try that specific architecture.
8. 98.▲
   by RyanHamilton 2y ago

   Ha Terrible! I don't recommend it at all but it's a great feeling of satisfaction when I walk into a random office and see someone using it. Or more rarely when someone emails thanks.
9. 99.▲
   by RyanHamilton 2y ago

   Yes, you are correct. though I individually email people and historically it's only been people that use one particular database and that work in one sector (Finance). I have corporate paying users for one niche database that allows me
10. 100.▲
    by RyanHamilton 2y ago

    It's interesting to hear your perspective thanks. FYI there is no need to save before shutdown. I stole notepad++s excellent idea of autosaving regularly. Edit: Actually your description reminded me of jailer: https://github
11. 101.▲
    by RyanHamilton 2y ago

    The story is: I made a big push to open source it a few years ago but none of my users seemed to care. They mostly cared it's Free. Doing the boring work of getting the build working on github etc. doesn't seem valuable to my user
12. 102.▲
    by RyanHamilton 2y ago

    A massive shout out to DockingFrames + jsyntaxpane + FlatLaf. Java libraries just don't get the love or attention they deserve. Docking Frames has solved the multi-windows in docks better than any JS library I've used or looked at
13. 103.▲
    by RyanHamilton 2y ago

    It's aimed as an SQL tool for Data Analysts not DBAs. e.g. It has 10+ charts builtin that can be generated directly from queries. It allows creating pivots using a UI. It does not allow DBA tasks like altering columns. It features a u
14. 104.▲
    by RyanHamilton 2y ago

    Year 1 - Getting the first version out that worked for me and my colleagues. Year 2 - Cleaning it up enough to promote wider use. Documentation. Years 3-5 - Minor bug fixes only as I thought qStudio solved the problem. Years 6 - I realised
15. 105.▲
    by RyanHamilton 2y ago

    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/.d
16. 106.▲
    by RyanHamilton 2y ago

    Currently registration is eventually enforced. I need to remove some logic to make it restricted to only happen for one niche database as I use the email to reach out to large finance firms to finance the dev effort. >>Would need to s
17. 107.▲
    by RyanHamilton 2y ago

    I should say a massive thanks to all the users over the years that provided feedback and feature suggestions. Also a big thanks to the excellent JFreeChart/Flatlaf libraries that do most the work to make qStudio look good.
18. 108.▲
    Show HN: 10 Years to Build a Free SQL Editor(timestored.com)

    355 points by RyanHamilton 2y ago|90 comments
19. 109.▲
    by RyanHamilton 2y ago

    Damn that's dissapointing as I actually just recorded a mac demo this week. I got the false impression all macs have java but I guess it was just the one I had. I'm happy to try creating an installer if you are willing to test it.
20. 110.▲
    by RyanHamilton 2y ago

    I recently took a big gamble on DuckDB. I've added it to the core of qStudio a free SQL editor. Now within the editor you can save table results from any database to the local duckdb instance or you can even perform joins amongst any s
21. 111.▲
    by RyanHamilton 2y ago

    For 10 years he sold companies on Big Data they didn't need and he only just realised most people don't have big data. Now he's switched to small data tools we should use/buy that. Is it harsh to say either a) 10 Years
22. 112.▲
    by RyanHamilton 2y ago

    Is there something like this but for desktop? e.g. take this screenshot of my desktop and show it projected onto: 1. A laptop monitor. 2. An ipad screen. 3. A giant TV screen in Times Square.
23. 113.▲
    by RyanHamilton 2y ago

    >Would love to hear from the community on building natural language interfaces to relational data. I produce a free sql editor that allows users to plugin openai to perform text to sql: https://www.timestored.com/qstudio&
24. 114.▲
    by RyanHamilton 2y ago

    To enable the helpful mouse interface, run with this mode and add this to your hidden config file. What's a mode? How do I edit the config file until I fix my editor? This is such a unix answer.
25. 115.▲
    by RyanHamilton 2y ago

    "going private is likely saving 90% over". How's that working out for your private US healthcare system? Some of the most expensive private care in the world. The toilet you mention is in one of the richest most capitilistic
26. 116.▲
    by RyanHamilton 2y ago

    >>I did not find sufficient information in the article to determine if this was a management problem or a personnel issue. She had been working at Cigna 15 years. If she was a bad employee, either she changed personality mid-life or C
27. 117.▲
    by RyanHamilton 2y ago

    Please reread my post, I didn't mention anything historical. I never said who founded it nor who started it. Your arguing against a straw man argument you made up. I am saying today, OSI does not represent the software industry and
28. 118.▲
    by RyanHamilton 2y ago

    OSI isn't the software industry. It's sponsored by Google, amazon then ms via github in order of sponsor donations. It's financed by the hyperscalars. https://opensource.org/sponsors
29. 119.▲
    by RyanHamilton 2y ago

    I agree. Clickhouse is awesomely powerful and fast. I maintain a list of benchmarks, if you know of any speed comparisons please let me know and I will add them to the lsit: https://www.timestored.com/data/time-series-d
30. 120.▲
    by RyanHamilton 2y ago

    If you want to plot time-series charts or many other charts directly from sql queries, qStudio is a free SQL IDE and works with everything including TimescaleDB: https://www.timestored.com/qstudio/database/timescal