whatgotdone
pq
whatgotdone | pq | |
---|---|---|
5 | 28 | |
139 | 8,765 | |
- | 0.9% | |
7.6 | 3.2 | |
16 days ago | 2 months ago | |
Go | Go | |
Apache License 2.0 | MIT License |
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.
whatgotdone
- What Got Done
- How to monetize an open-source project?
- Any free database for new saas
-
Keep a Knowledge Log
I wrote a tool specifically for this, mostly inspired by the Snippets tool at Google. I've been publishing my weekly log in it every week for almost three years:
https://whatgotdone.com/michael/2021-12-03
The code is all open source if you're interested in playing around with it:
https://github.com/mtlynch/whatgotdone
-
Back to basics: Writing an application using Go and PostgreSQL
I had the same objection to SQLite, and then I heard about Litestream, and it won me over.[0]
Litestream watches your SQLite database and then streams changes to a cloud storage provider (e.g., S3, Backblaze). You get the performance and simplicity of writing SQLite to the local filesystem, but it's syncing to the cloud. And the cool part is that you don't have to change any of your application code to do it - as far as your app is concerned, it's writing to a local SQLite file.
I wrote a little log uploading utility for my business that uses Litestream, and it's been fantastic.[1] It essentially carries around its data with it, so I can deploy my app to Heroku, blow away the instance and then launch it on fly.io, and it pops up with the exact same data.[2]
I'm currently in the process of rewriting an open-source AppEngine app to use SQLite + Litestream instead of Google Firestore.[2] It's such a relief to get away from all the complexity of GCP and Firestore and get back to simple SQLite.
[0] https://litestream.io/
[1] https://mtlynch.io/litestream/
[2] https://asciinema.org/a/I2HcYheYayeh7aHj23QSY9Vyf/embed?size...
[3] https://github.com/mtlynch/whatgotdone/pull/639
pq
-
Authentication system using Golang and Sveltekit - Initialization and setup
Following the completion of the series — Secure and performant full-stack authentication system using rust (actix-web) and sveltekit and Secure and performant full-stack authentication system using Python (Django) and SvelteKit — I felt I should keep the streak by building an equivalent system in PURE go with very minimal external dependencies. We won't use any fancy web framework apart from httprouter and other basic dependencies including a database driver (pq), and redis client. As usual, we'll be using SvelteKit at the front end, favouring JSDoc instead of TypeScript. The combination is ecstatic!
- Ask HN: Slimvoice Alternative?
- Fly.io and Tailscale Saved Notado
- Restful API with Golang practical approach
-
Connect REST API to database with Go
Go’s standard library was not built to include any specific database drivers. So we need to install a third party package. In this case we are going to install https://github.com/lib/pq. Run following command:
-
Getting EOF when connecting to a database using sqlx
For Postgres the driver comes from "github.com/lib/pq" and then it is just "postgres".
-
Is this a proper setup in Go for a postgres api?
With regards to 2. -- also, it looks like there's an important unfixed issue https://github.com/lib/pq/issues/939. I haven't verified whether the issue is up to date.
-
Connect to postgres database using connection string?
Postgres (pure Go): https://github.com/lib/pq [*]Postgres (uses cgo): https://github.com/jbarham/gopgsqldriver Postgres (pure Go): https://github.com/jackc/pgx [*]
-
Golang future web frameworks!
lib/pq 7.3k Stars, Used by 63k
-
psql driver that supports the sql.NamedArgs & sql.Named?
I am using the lib/pq driver. is there a driver that does allow for this syntax or is there something I can change?
What are some alternatives?
go-mockgen-tool - Go/Golang mock generation for interfaces via code generation
pgx - PostgreSQL driver and toolkit for Go
pgxtutorial - Example of how to build a web service using Go, PostgreSQL, and gRPC
go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package
impl - impl generates method stubs for implementing an interface.
sqlx - general purpose extensions to golang's database/sql
litestream - Streaming replication for SQLite.
goriak - goriak - Go language driver for Riak KV
go - The Go programming language
gofreetds - Go Sql Server database driver.
go-mssqldb - Microsoft SQL server driver written in go language