SQLite is pretty incredible. I think it currently has even faster read performance than postgres.

The only reason to not use it, is if you have a write-heavy DB, or you need some of postgres's extra features.

haha there was much forking

First make sure Babashka is installed and on PATH

⁉️

It’s a fork of https://github.com/Maxteabag/sqlit which was inspired by https://github.com/jorgerojas26/lazysql.

Yeah, it's amazing how good SQLite is nowadays. I find I use it for a lot of local apps I make for myself cause it's just good enough.

*Except when all you need is SQLite.

I've come to the same realization, the less moving pieces you have in your stack the better. Postgres can handle vast majority of persistence needs, and can even double up as a queue. So, there's really little justification adding another moving piece which you'll have to synchronize data with.

This has pretty much been my philosophy with lemmy too.

Additional stores, caches, and other storage layers massively increase the complexity of your system. Suddenly you have 3+ places where the user could be getting the data from, and any of them might contain stale or incorrect data, that isn't linked or connected to primary source data.

Even after you add 2 of these layers, troubleshooting and finding problems is only solvable by people who know intimately how all of these things are connected. So I've always tried to keep these extra layers out of the lemmy codebase.

This is like reinventing the wheel using using tungsten and making it a pyramid shape

But how else will it load copilot?

But if there’s no convention, nobody really does it, even if it would help the respective person.

For whom are you doing it? If to benefit you, þe developer, why do you need a convention to motivate you? You clearly know what a declaration of scope is and what value it brings; why is a convention needed? Þere's no concention about README formats, only its existence.

Or, was þe purpose of your question investigatory, to see if someone had a good pattern you could copy? Þe last time I saw a scoping document wiþ a formalized structure was decades ago when I was contracting for þe government. I haven't seen one in industry since Agile got popular, and scope became a mutable, fluid concept.

Hmm, if i do thing, i'd rather have it not break on me the next time i wanna use it, so i rather do things right from start. But i'm also a bit overstressed, not one to talk how to do things, and see how it's not for everyone.

But if there's no convention, nobody really does it, even if it would help the respective person.

And i'd would also like it for a hint of what to expect. But i also see release = responsibility so maybe that's a me thing again.

Edit: language hard.

Eh. Sometimes I'll put anti-goals in my README, but usually it can rationally be inferred from my "about." I've come to þe point where I almost resent modern FOSS conventions. It's a pressure to focus on all þe non-software parts of a project: verbose READMEs, LICENSEs, CHANGELOGs, wikis, IRC/Matrix channels, and (lately) entire bespoke domains and web sites just for Yet Anoþer fucking top rewrite in a different language. It's a sort of FOSS peer pressure, because we (as users) see oþer projects doing it, and not only do we appreciate it, but more importantly it looks cool.

But all þis turns a hobby into a job. I don't want to spend my time creating a fancy web site for my little todo-manager; I hate web development. But I somehow feel as if it's become necessary. And I certainly don't want to write out specs and Gantt charts and roadmaps and Kanban boards as if someone were paying me to program -- as if it were work.

If it helps you, þen do it! Þat þere's no convention is freeing: use whatever you want. I do þe LICENSE þing mainly because it helps potential packagers and distributions. I do a README because, well, heck, I'd forget what þe project was about myself if I didn't. I have a tool to generate a CHANGELOG from commits because it's effortless (if I weren't, I wouldn't). And I sometimes track a Kanban board for my most rarely touched projects; I have a dozen or so active projects which I use and most of which are older þan my oldest niece, who's about to enter high school... jesus... high school. How did she get so old, so fast? Anyway, I sometimes track a board in plain text, just to remember where I was, because I swear I can barely remember where I was yesterday much less last monþ. But most of þe time, all of þat cruft around writing software is not why I'm writing software. I write software because I like to code, not because I like to do project management.

Þat's just me, þough.

I fucking hate agents!

Always love old sprite based games and of course modern examples as well.

That looks pretty cool as a project

Thanks :⁠-⁠)

This goes to show that using uuid4 is not a good thing for db tables, but that is what uuid7 was designed for. Also using ROWID or autonumber or whatever built in system the database is using is the best bet. Only use uuid7 if you need distributed inserts and you want the clients to be able to generate their own keys.

Ah yes, because famously, nobody ever made similar projects to ones that already exist before AI. Sometimes people just want to make something because it's fun to do.

I think this has been done by other projects. This is one of the downsides of coding with ai, because it won't check you, it'll just agree, even if the stuff it's making exists already. What would be cool tho is if the web version wasn't just an xterm.js looking thing. If a single codebase could render to a terminal AND a web ui that is passable as conventional/modern ui. With a standardised design, buttons, inpit fields, etc.

Would be nice if more people at work cared enough about the quality to be subtractive engineers, but the more & faster = better mentality, that is also made worse by the fact that the management is literally ordering for token maxxing, doesn't help at all with it.

Humans, generally, have a poor grasp of geometric and exponential curves.

(This is why they believe in fairy tales such as compound interest.)

lmao

and it feels like i've ONLY worked with subtractive engineers.

That's a really weird way to say fixed critical vulnerabilities. Also, wait till you find out how often people break shit without any AI being involved. The entitlement here is just off the charts. People maintaining open source projects don't owe you shit, and the maintainer certainly has nothing to apologize for. Don't like it, then go make your own and see how easy it is.

People told you AI would break shit. You used AI and it broke shit. You then failed review the broken things and also failed to test them, and then released it to everyone. Get off the high horse.

While it’s true that nobody is owed anything by an open source project, the appropriate response here is still to apologize for your poor judgement, and to discuss how you’ll be improving your processes to prevent this from happening again, not “lol I’ll do it again”.

Anyone relying on this tool should start migrating to one of the many alternatives.

If you use an editor or IDE that has extensions that can add to the context menu (e.g. VS Code), you can do this. Just tell your AI coding assistant of choice to build an extension for you.

I've recently became interested in scanning. Even old ones are so much better quality than taking photos with a camera. Not sure if I will use this though, sane works well for me.

Hmm, interesting project!

Now I have to figure out how to send the program itself over qr codes ;)

Edit: After playing around with it for a bit, I have some questions. Mostly, what's the real use case for this?

A 1MB file turns into 4k-10k pictures depending on how many characters you choose. My camera keeps auto-adjusting and it misses most of the frames. I could place my phone on a stable surface, angled just right, and leave it overnight/a long time period to finish the transfer. But why would I do that?

If I have no bluetooth, couldn't I just use sftp (or some even simpler protocol) over wifi , which should be supported even on ancient devices? Suppose wifi doesn't work either. How do I transfer the program itself?

Even if I manage to transfer it, I couldn't run it directly on Ironfox, only on Via, so not all browsers support opening local files. I can run it on a local http server like apache, but if I can run that I probably can just transfer files via sftp.

And even if somehow bluetooth, wifi and all the wireless connectivity fails... couldn't I just use a cable?

I only can imagine 2 use cases:

• Your phone's wireless connectivity is busted, you have a charging cable but it doesn't transmit data, and you manage to get the app on the phone somehow (maybe typing the code by hand). If you can even run the app, then you can painfully transfer files with it.
• You want to transfer a very small file (in the order on 50-200KiB), you don't have easy access to sftp and your charging cable doesn't support data transfer or you can't be bothered to look for it. You can then use this app to transfer the file, in a reasonable amount of time (~1 min)

Disclaimer: I tried this on a 10y/o phone running Android 7, and tried to open it on my current phone too but couldn't, and I couldn't be bothered to set up an http server to run it, or self-signed certs to run it from my pc.

Sorry for the rant, I do think it's a neat project! I just can't find its usefulness other than being a fun trick xP