cvilsmeier

12 ms·

1.
by cvilsmeier 1y ago
According to my private tests, using STATIC instead of TRANSIENT does not yield a significant performance boost (maybe 1 to 5 percent, if at all).
2.
by cvilsmeier 1y ago
You're right. A table. I've included one.
3.
by cvilsmeier 1y ago
Thank you.
4.
by cvilsmeier 1y ago
You are correct: Multiple connections means multiple sqinn subprocesses.
5.
Benchmarks for Golang SQLite Drivers(github.com)
92 points by cvilsmeier 1y ago|35 comments
6.
by cvilsmeier 3y ago
> How come Zombiezen came out faster ? I’d expect the opposite (OP here) Honestly, me too. Maybe it has to do with leaving out that database/sql driver layer. I guess it would need another round of pprof to find out the real reason
7.
by cvilsmeier 3y ago
Nothing wrong with it, but there are other drivers that cross-compile better and are faster.
8.
by cvilsmeier 3y ago
For sqinn it's because of its design: Shuffling that much data over process boundaries takes time. For zombie, more pprof would be needed to explain the behaviour.
9.
by cvilsmeier 3y ago
Yes, in fact the benchmark started out as a comparison between sqinn and mattn. (There was no modernc at that time.)
10.
by cvilsmeier 3y ago
Maybe because Go devs are more allergic to 'non-Go' solutions that Java devs are to 'non-Java' solutions? (Explain: Java's xerial driver is a DLL/SO wrapped in a Java library)
11.
by cvilsmeier 3y ago
Sqinn author here. Yes, sqinn performs quite well compared to the 'standard' mattn driver. The only use case it clearly breaks down is when SELECTing very large (gigabytes) resultsets.
12.
I benchmarked six Go SQLite drivers(github.com)
192 points by cvilsmeier 3y ago|60 comments
13.
by cvilsmeier 3y ago
If you want to monitor custom app metrics and server resource usage, you can also try Monibot. It's not comparable to catalyst, though.
14.
Show HN: Web App Monitoring for Go Developers(monibot.io)
1 points by cvilsmeier 3y ago|0 comments
15.
Show HN: Do you trust your website monitoring?(upordown.monibot.io)
1 points by cvilsmeier 3y ago|0 comments
16.
by cvilsmeier 3y ago
I did: https://monibot.io
17.
by cvilsmeier 3y ago
I'm a developer. I write web apps and run them on linux servers. I keep an eye on them to make sure all apps are running smoothly. But, as the number of apps and servers grows, manual monitoring takes more and more time, so I need an a
18.
I want a WebApp monitoring tool for DevOps. Here is how it should work(monibot.io)
1 points by cvilsmeier 3y ago|3 comments
19.
by cvilsmeier 3y ago
I use it for SQLite Database access in Go and Java. Java lets you theoretically interface with C code, but it's a lot of JNI/DLL/SO work. It's much easier for me to just os/exec (or Runtime/exec in Java) and se
20.
by cvilsmeier 3y ago
> But compiling the non-go assistant process is not going to be any easier than cgo, right? Right. But you have to do it only once, or you can download a pre-built library from https://github.com/cvilsmeier/sqinn&#x
21.
by cvilsmeier 3y ago
> you may as well run MySQL You're right, there are use-cases where SQLite is not appropriate. But nothing beats the ease of installation/backup/maintenance of SQLite compared to server databases like MySQL or Postgres. An
22.
by cvilsmeier 3y ago
> Wow, that sounds incredibly inefficient! That's exactly what I thought, too. But, to my own surprise, it's as fast as CGO solutions, in most cases even faster. You may check here: https://github.com/cvilsmeier
23.
by cvilsmeier 3y ago
Thank you! Nice to hear :-) Use the code any way you want, it's unlicensed.
24.
by cvilsmeier 3y ago
Sqinn author here. Nothing against CGO, but I develop/deploy on Win/Linux, and cross-compiling CGO is very painful. Regarding performance: To my own surprise, Sqinn out-performs mattn (and others) for normal workloads, see https:
25.
Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go(github.com)
113 points by cvilsmeier 3y ago|61 comments