faenz
ws4sqlite
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
faenz
-
Running a funny experiment with my free web-analytics
Two years back, I created a little web analytics tool for my side projects and I called Faenz. It's open source and self-hostable, available on GitHub at https://github.com/a-chris/faenz.
I've recently given it an update and came up with the idea of creating a demo version that's accessible to everyone.
How does it work?
You can add your own website, blog or e-commerce site and keep track of the visits it receives. Your website stats will be visible to others, and you'll get to check out everyone else's stats too. You won't be allowed to edit/delete a website, you should reach out to me for that.
I find it to be a fun experiment to see how people handle SEO or just to discover some cool new websites :)
The demo is available here https://faenz.acmecorp.dev/
- Il Garante della privacy Italiana dichiara lo stop all’uso di Google Analytics per il trasferimento dei dato negli USA senza garanzie adeguate
-
Small tip to shrink your Docker images size
Here is the project I'm working on: Faenz Analytics
- Ask HN: Have you used SQLite as a primary database?
-
Ask HN: Have you created programs for only your personal use?
I've built several personal projects to be honest; background jobs, tasks automation, telegram bots to find a house to rent or buy, most of them are kept provate.
The two I'm most proud of are a web analytics that, coincidentally, I've made public today after a few weeks of work:
https://github.com/a-chris/faenz
I developed it for collect data for my personal website and it is working well so far, really happy of it.
The other one is a Google Chrome extension to manage bookmark because I think the default one is a mess and very unpratical to use. I haven't worked on it for a while:
https://github.com/a-chris/peffect-bookmarks-manager
ws4sqlite
-
ws4sqlite v0.12.1 released - connect to sqlite via HTTP/"REST"
If you are interested, feel free to browse the git repo, read the documentation (with a tutorial) or connect to the discord channel.
-
Ask HN: Have you used SQLite as a primary database?
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.
-
Hacker News top posts: Mar 11, 2022
Ws4sqlite: Query SQLite via HTTP\ (30 comments)
- Ws4sqlite: Query SQLite via HTTP
-
A remote JSON interface for SQLite, in Go
ws4sqlite is a web service layer on one (or more) SQLite databases. It’s written in Go, over mattn's go-sqlite3, and allows to use HTTP POST requests to submit SQL statements to a database, in a transaction. It can “serve” multiple databases at once, supports authentication, “stored queries”, in-memory databases, maintenance (vacuum/backups), batching and several other security features and configurations.
What are some alternatives?
termdbms - A TUI for viewing and editing database files.
tuql - Automatically create a GraphQL server from a SQLite database or a SQL file
dqlite - Embeddable, replicated and fault-tolerant SQL engine.
dashera - DasherA is a Data General DASHER D200/D210 terminal emulator
Sqinn-Go - Golang SQLite without cgo
sqlite-s3-query - Python functions to query SQLite files stored on S3
barrier - Open-source KVM software
sqlite3vfshttp - Go sqlite3 http vfs: query sqlite databases over http with range headers
go-sqlite3 - sqlite3 driver for go using database/sql
uptime
ExtPay - The JavaScript library for ExtensionPay.com — payments for your browser extensions, no server needed.
nimforum - Lightweight alternative to Discourse written in Nim