HN user

mano78

69 karma
Posts0
Comments40
View on HN
No posts found.
UnDUNE II 2 months ago

I didn't remember you can actually build a structure without putting it on concrete slabs.

Anyways, It's a marvellous work of love.

The first and the last two positive comments are from physicists…? And: if it explains something the other theory does not, maybe it’s worth considering, and applying the scientific method to. It may be bulls**, it may be that some pieces of it have merit, this is how science works. I think.

Not even an AI, there are simpler ways. But as an italian, I will be in the pitchforks-armed horrified mob if this will be proposed. Not a chance.

I’ve been self-hosting it for three months now, and I am happy. I came from Joplin; I lost the offline access, but it’s much more “expressive” and nice, so to speak. I don’t miss any other feature, even in the pro version. Doesn’t depend on other docker containers, I just used authelia for auth, and while it uses its own file format I backup the data volume and it’s possible to export manually in simple markdown. The web UI is responsive for mobile use and yes, I am happy. Fits my case better than the others.

I wonder why the error in nomenclature… it’s Palazzo Te, from the name of the islet, but even English Wikipedia gives “palazzo del te”, that would mean “of the tea”. Very nice place nevertheless.

Just the right time. I’m travelling now to go and deploy a software system I wrote for a NGO, at their place, for free. I am anonymous here so I am not bragging or such: I know many people doing the same, it’s a form of voluntary work, it benefits them, I know how to do it, and I am having fun. Everyone wins.

I am using sqlite where a simple persistence layer is needed, both as the sole in the project or along with a full-fledged database. There are many such projects, once you realize that a database is just an abstraction; for example, for caching in a larger project, or to store results for a subsection of the project. But of course also for smaller, standalone projects.

Also, take a look at ws4sqlite (https://germ.gitbook.io/ws4sqlite/) for a middle ground between SQLite (embedded) and rqlite/dqlite: it's "normal" sqlite addressable via web services. May be useful in some scenarios.

thanks for your comments, really interesting. I'll come back to this post for ideas ;-). I like the precondition, maybe I'd like to structure it so that it passes when 1+ rows are returned and fails if 0 rows... should be equivalent and doesn't make any assumption on rows _and_ columns being there... but I'll think about it. Thank you again!

Hi! It doesn't add much to what SQLite allows. It's allowed if database is set as read only and you don't opt-out of default WAL mode; if not, the transactions are serialized. Even so, you rarely notice it, because SQLite is quite fast.

Concurrency at the HTTP layer is permitted, though. Basically what is done is to set 1 max connection on the connection pool.

I didn't find any concurrency issue; it isn't based on sqlite alone, the underlying layer (go-sqlite3) has a connection pool that I set to 1. I have a test case on this, and it works fine (as far as I can see). If you care to take a look at it, I'd like to have your opinion.

About performances: I was blown out, yes. SQLite is an amazing piece of software, I just had to do my stuff while treating it with respect :-).