• 0 Posts
  • 106 Comments
Joined 1 year ago
cake
Cake day: June 1st, 2023

help-circle

  • Not saying there’s any reason to switch, but I believe you can load CSV’s into sqlite.

    Datasette would be something that I would try for CSV’s as well, that seems like an interesting piece of technology I haven’t had reason to use yet.

    Finally there’s always Jupiter Notebook and any respectable DataFrame-solution.

    Not to knock spreadsheet-solutions too much - I certainly see their value and use them frequently - but if I had to do something that warranted writing VBA, I’d probably reach for a tool I could combine with some form of VCS like Git at least.




  • While Rust would probably have been a good choice for implementing a new browser, I don’t think Swift deserves the criticism it’s getting in this thread:

    • Swift was created by the same person who created Rust, and has many of the same nice traits
    • Swift is a modern language that is easy for plenty of developers to pick up; I’d place it in the same family as Rust and Kotlin
    • Swift grants access to a large pool of native iOS/Mac developers





  • It’s not out of the question to have ‘memory leaks’ - apps accumulating more memory by keeping around references to more and more objects - but memory leaks in the stricter sense of not deallocating objects that you no longer have references to is less likely. Regardless, the OOM killer will come for your app, no matter how good you’ve been about managing your memory, as long as someone else wants to have the memory and you’re the one who has been active the least recently.











    • General purpose LLMs are starting to replace everyday queries I used to posit to Google. Perplexity can be quite good for this.
    • Copilot as enhanced autocomplete when writing code. A particularly good use-case is writing tests: with a few test cases already written, a sufficiently good test name will most often generate a well-written test case.
    • LLMs for lazy generation of SQL queries can sometimes be quite nice.
    • Writing assistance for things I find myself struggling to get written by myself. A writing unblocking tool, if you will.

    It’s reducing the effort and time I have to put into some things, and I appreciate that. It’s far from perfect, but it doesn’t have to be perfect to be useful.