Best of PostgreSQL — September 2023
- 1
- 2
- 3
freeCodeCamp·3y
The SQL Handbook – A Free Course for Web Developers
The SQL Handbook is a free and open text-based handbook for Web Developers. Try the interactive version of this SQL course on Boot.dev, complete with coding challenges and projects. Watch the video walkthrough of this course on FreeCodeCamp's YouTube channel.
- 4
Full Stack Project Tutorial – Create A Notes App Using React and Node.js
Learn how to create a full stack notes app using React and Node.js. The tutorial covers building the UI, connecting it to the backend, and adding features like validation and error handling. By the end of the tutorial, readers will have a functional notes app that they can use as a starting point for their own projects.
- 5
Pointer·3y
electric-sql/electric: Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.
ElectricSQL is a local-first software platform that makes it easy to develop high-quality, modern apps with instant reactivity, real-time multi-user collaboration and conflict-free offline support. ElectricSQL gives you instant local- first for your Postgres-based system. The app code talks directly to an embedded local database and data syncs.
- 6
Pythagora-io/gpt-pilot: Dev tool that writes scalable apps from scratch while the developer oversees the implementation
GPT Pilot is a research project to see how can GPT-4 be used to generate fully working, production-ready, apps. The main idea is that AI can write most of the code for an app (maybe 95%) but for the rest 5%, a developer is and will be needed until we get full AGI.
- 7
TigerData (Creators of TimescaleDB)·3y
PostgreSQL Performance Tuning, Part II: Key Parameters
The ‘max_worker_processes’ parameter determines the maximum number of worker processes you can start. The default value is two, but somewhere around a quarter to a half of your CPU count is a good option. In Timescale, we start at two and progressively increase it as your CPU increases to match half your CPU.
- 8
Community Picks·3y
How we made our Go microservice 24x faster
Go is a Go server that processes git commits by request, sometimes processing thousands of commits in one single request. In this blog post, let’s take a look at some recent optimization strategies the OpenSauced pizza micro-service recently underwent. For simplicity in our examples, we’ll be using an arbitrary table.
- 9
chartbrew/chartbrew: Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
Chartbrew is an open-source web application that can connect directly to databases and APIs. It features a chart builder, editable dashboards, embedable charts, query & requests editor, and team capabilities.
- 10
Postgres 16: The exciting and the unnoticed
Postgres 16 came out last week - and this year it arrived earlier than the last few years. In addition, Postgres releases minor versions of each major release every 3 months or so with bug fixes and security fixes. No new features are released in minor versions, and that's what makes major version releases so exciting.
- 11
- 12
Hacker News·3y
Choose Postgres queue technology
Adriano Caloiaro: Postgres queue tech is a thing of beauty, but far from mainstream. He says Postgres isn’t suitably scalable for anyone’s queueing needs. The cult of scalability fractures, but they congeal around new principles like operational simplicity, maintainability, understandability.
