Hashnode·4yThe Complete Modern React Developer 2022
This course will give you the skills and knowledge to become a Software Developer across the full stack. We will be building a super basic Twitter clone that has CRUD functionality for posting, reading and deleting tweets. In this section you will learn how to setup a Node backend using both Express.js and Nestjs. And as a bonus you will also learn some DevOps when we put a MongoDB and Postgres database inside of a Docker container.
DEV·4yFree Alternatives to Heroku
Heroku has brought an end to free dynos and Postgres databases. Other free platforms can be used to host Django (Python) powered web applications for free. Fly and Render seems to offer Postgres on a free plan. Railway doesn't have a free tier, but basic usage is quite cheap.
Community Picks·3yThe complete guide to System Design in 2022
System Design is the process of defining the architecture, interfaces, and data for a system that satisfies specific requirements. System design meets the needs of your business or organization through coherent and efficient systems. The complete guide to System Design Interview in 2022 is available.
Community Picks·4yDDD, Hexagonal, Onion, Clean, CQRS, … How I put it all together
Ports & Adapters architecture identifies three fundamental blocks of code in a system. In most languages and in its most simple form, the Port will be an Interface, but it might actually be composed of several Interfaces and DTOs.
ByteByteGo·4yEP30: Why is PostgreSQL the most loved database
The ByteByteGo talent collective has 100 candidates live at this moment, and over 300+ applications from the best companies out there. The collective's members will have exclusive access to opportunities at high-growth startups and world-class companies such as Meta, Stripe, Snowflake, etc.
freeCodeCamp·3yHow to Build Your Own SaaS – PagerDuty Clone
Ania Kubów creates popular software tutorials on both the freeCodeCamp channel and her own channel. In this course, Ania will teach you how to build a dashboard to let you know if your app is down. This is a clone of the popular software as a service app called PagerDuty.
freeCodeCamp·4yLearn NestJS by Building a CRUD API
NestJS is a framework for building efficient, scalable Node.js web applications. It is a complete development kit for building scalable server-side apps. You will learn how to create a bookmarks API from scratch using NestJS, Docker, Postgres, Passport.js, Prisma and pactum.
DEV·4yDatabase GUIs in JavaScript
Traditional tools are often written in Java, C++ or Delphi and they use good old JDBC, ODBC or ADO.NET drivers for accessing database. Almost all tools are open-source. If you know about other tool not listed in this article, you could write about it in comments below. For SQLlite I actually use Firefox.
Quastor Daily·4yHow Notion Sharded Their Postgres Database
How Notion Sharded Their Postgres Database is a web/mobile app for creating your personal workspace. You can store notes, tasks, wikis, kanban boards and other things in a Notion workspace. Sharding adds an increased maintenance burden, constraints in the application code and much more architectural complexity. The Notion team looked at the hardware constraints they were dealing with.
EverSQL·4yHow I became a better CTO using these 8 resources
Google offers 25 lessons, 30+ exercises, real case studies, and lectures from Google experts. The SaaS CTO Security Checklist provides actionable security best practices CTOs can use to harden their security. JavaScript is a bird's eye view of JavaScript, its benefits, patterns, and more.
Supabase·3yWhat's new in Postgres 15?
The Postgres community released version 15 (stable) in October 2022. The permission model is more secure permission is revoked from all users except the database owner. It makes permission assigning more tunable ( details) Sorting rows of data is a frequent operation inside the Postgres code.
Supabase·4yImplementing "seen by" functionality with Postgres
Use HyperLogLog to build a simple database for a social media site. Use hstore to create a quick & dirty prototype with integer IDs. The easiest way to do this is to maintain a counter on every post in the posts table. Scaling up is the new (and old) scaling out.
Community Picks·4yHow to Build a Fullstack App with Next.js, Prisma, and PostgreSQL
Next.js is a next-generation ORM that can be used to access a database in Node.js and TypeScript applications. In this guide, you'll learn how to implement a fullstack sample blogging application using the following technologies. You'll use a single PrismaClient instance that you can import into any file where it's needed. You can create a new User record by calling prisma.create() or retrieve all the Post records from the database.
Supabase·3yNew Supabase Docs, built with Next.js
New Supabase Docs, built with Next.js, are a new version of Supabase's documentation tool. For a developer tool, documentation is more than a resource - it’s part of the product. For the past two years at Supabase, this part of our product hasn't been great.
Better Programming·4yWriting My First Microservice Using Go
Go is an open source programming language supported by Google. The biggest companies using Go are Google, Netflix, Dropbox, Uber, Meta, Twitch, etc. With Go, you can create cloud & network services, web applications, and command-line interfaces. It’s a great solution to aggregate, collect, store and visualize logs from your applications.
LogRocket·4yPrisma vs. Thin Backend
Prisma enables you to access your database straight from Node.js and TypeScript application code. Thin Backend provides you with an IDE that has custom business logic and serverless functions. Prisma is a type-safe query builder that is an alternative to Sequelize and TypeORM.
Semaphore·4yDockerizing a Node.js Web Application
Docker is an open platform for building, shipping and running distributed applications. We’ll be using a basic Express application as our example Node.js application to run in our Docker container. We will write an addressbook API that stores people’s names in a database.
Dev Genius·4yGet started with Docker and Docker Compose
Docker is a set of platform as a service (PaaS) products that use OS-level virtualization to deliver software in packages called containers. The service has both free and premium tiers. The software that hosts the containers is called Docker Engine. Get started with Docker and Docker Compose.
TigerData (Creators of TimescaleDB)·4yPostgreSQL + TimescaleDB: 1000x Faster Queries, 90% Data Compression, and Much More
TimescaleDB can dramatically improve query performance by 1000x or more, reduce storage utilization by 90% or more. Timescale provides two methods to reduce the amount of data being stored, compression and downsampling using continuous aggregates.
Supabase·4ySupabase Vault
Supabase Vault is a Postgres extension for managing secrets and encryption inside your database. For self-hosting, pgsodium supports a variety of ways to place the root key into Postgres. To see the decrypted data, there is a special view created called vault. The actual raw key is not available to you in SQL, it is managed entirely outside of the SQL language in the Postgres server. If you take a backup or pause your project, that data remains encrypted.
Hacker News·4yNeon — Serverless, Fault-Tolerant, Branchable Postgres
Compute is fully client-compatible with Postgres because it is Postgres! Neon adjusts the amount of resources dedicated to the compute. Compute activates on an incoming connection and shuts down to save resources on inactivity. On Demand Scalability. We separated storage and compute to make on demand scalability possible.
LogRocket·4yComparing four popular NestJS ORMs
Object-relational mapping (ORM) is a technique that abstracts your database tables to data objects in memory. ORMs are used to make database access easier, as developers won’t need to write raw queries. For convenience, NestJS provides tight integrations with TypeORM and Sequelize out of the box.
Supabase·4yPostgres Full Text Search vs the rest
Postgres has built-in Full Text Search which we can use instead of cobbling together our own with like. Postgres can do some basic searching using select and comparison tools like like. The LIKE operator as used in the query above will match only the term "Avengers%". For our experiments we'll use SQLite FTS5 and TypeSense TypeSense.