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.
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.
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·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.
PostgreSQL·4yPostgreSQL 15 Released!
PostgreSQL 15 builds on the performance improvements of recent releases with noticeable gains for managing workloads in both local and distributed deployments. This release improves the developer experience with the addition of the popular MERGE command, and adds more capabilities for observing the state of the database. The performance improvements extend to its archiving and backup facilities.
Hasura·4yBuilding real-time chat apps with GraphQL streaming subscriptions
With Hasura, you can create chat apps straight from your data models without the need of any other infrastructure. We have built out a realtime chat app that uses the Streaming Subscriptions feature in Hasura. It fetches the last 10 messages from the messages table and then streams all new messages using the newly added Streaming API.
Community Picks·4yHow to set up Python in 2022
Installing the right Python Python 3 is now the right version of Python to use. We should always default to the latest available version. We're going to work on projects where we have a Pipfile managing dependencies. For local development, I recommend Postgres.app, which the easiest way to manage a database server on your laptop.
Dev Genius·4yData Engineering Best Practices: Tech stack with PostgreSQL, DB, Airflow and Redash
Data Engineering is a set of operations aimed at creating mechanisms and conditions for efficient access and flow of data. It includes setting up infrastructures that support consistent and maintainable physical and virtual environments for the use of data analysts and scientists.
Hasura·4yPostgreSQL 15 released: Top things to know
Postgres 15 is a stable release of their latest major version of their major version 15. Let us look at the top features and changes in this release and how it will impact usage going forward. The MERGE command is one of the newest additions to the Postgres DB with the v15 release. Most vendors currently support the latest Postgres v14.4 stable release.
Pointer·4yts-safeql/safeql: Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.
SafeQL was built with monorepos and microservices in mind. It's easy to use with multiple database clients, including Prisma, Sequelize, Postgres, and more. SafeQL automatically infers the type of the query result based on the query itself. 1665766642.51667130s SafeQL works with any Postgres client, including prisma,Sequelize,.
Hasura·4yTop PostgreSQL Database Free Tier Solutions
Neon is a company that provides fully managed serverless Postgres databases. It automatically scales your database based on the project workload and only charges you for the amount of resources used. Fly.io Fly is a global distribution platform that allows you to deploy and run applications close to the users.
LogRocket·4yHow to configure indexes in Prisma
Prisma defaults to this syntax: tablename. The fieldsargument is the only required argument on this list. The nameargument allows you to set a name for an index being defined map. This argument is essential for these types, especially for cases where the full value would exceed MySQL’s limits for index sizes sort.