sqlite
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.
-
Ask HN: Where do I find good code to read?
the right amount of context + easy-to-use tooling
- Code culture; follow industry best practices and make it clear where & why you deviate
My personal favorite one: `make todo_list`
We use keywords (TODO, OPTIMIZE, HACK, etc…) through the codebase and make them easily searchable with make helpers.
Ref: https://github.com/pokt-network/pocket/blob/main/Makefile#L5...
- GitHub Pull Request Workflow (20 minute video comment)
sqlite
-
Understanding SQL vs. NoSQL Databases: A Beginner's Guide
SQL (Structured Query Language) databases are relational databases. They organize data into tables with rows and columns, and they use SQL for querying and managing data. Examples include MySQL, PostgreSQL, and SQLite.
- Ask HN: Tips to get started on my own server
-
How to choose the right type of database
SQLite: A lightweight, self-contained SQL database, best for standalone applications, embedded systems, or small-scale applications not requiring a client/server DBMS.
-
NoSQL Postgres: Add MongoDB compatibility to your Supabase projects with FerretDB
FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.
-
Ask HN: Where do I find good code to read?
Rust stdlib code is quite high quality although not particularly dense due to large amount of comments. Start from the docs, and click any source link: https://doc.rust-lang.org/std/vec/struct.Vec.html
Sqlite is supposedly high quality C code: https://github.com/smparkes/sqlite
For videos of someone (Casey Muratori) writing video game code and debugging it, Handmade Hero: https://handmadehero.org/
A blog post about how to write code by the same author: https://caseymuratori.com/blog_0015
For how to implement a fairly advanced type system, Typing Haskell in Haskell: https://gist.github.com/chrisdone/0075a16b32bfd4f62b7b
But, honestly, you're probably better off writing code yourself and learning by doing.
What are some alternatives?
Refactoring-Summary - Summary of "Refactoring: Improving the Design of Existing Code" by Martin Fowler
clara-rules - Forward-chaining rules in Clojure(Script)
retlang
clean-code - Book review: A Handbook of Agile Software Craftsmanship
mx-chain-go - ⚡ The official implementation of the MultiversX blockchain protocol, written in golang.
The-Simpsons-Hit-and-Run - Stolen (and slightly cleaned up) version of The Simpsons: Hit & Run original source code from 2003
htmx - </> htmx - high power tools for HTML
pytudes - Python programs, usually short, of considerable difficulty, to perfect particular skills.
deno_std - deno standard modules
kakoune - mawww's experiment for a better code editor