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.
Community Picks·4yFully Typed Web Apps
The secret to fully typed web apps is typing the boundaries. There are plenty of examples of boundaries you’ll encounter on the web. There’s a handy utility I use in almost all my projects to make this slightly nicer on the eyes. It's just a tricky problem because TypeScript doesn’t know your conventions or config.
Honeypot·4yDolt - A SQL Database that Works like Git
Dolt is an SQL-based database that allows you to maintain your database like Git repositories. It combines all the great features of Git and SQL in order to give you an amazing experience. Dolt comes with a powerful CLI similar to Git, and you can apply your knowledge in Git to easily commit, merge, and push database changes. Earn Money from DoltHub Data Bounties.
Quastor Daily·4yBuilding a Scalable Notification Service
Razorpay is one of India’s most valuable fintech startups. The company powers payments for over 8 million businesses in India and has been growing extremely quickly. With the increase in transactions, the Razorpay team encountered a few scalability issues - Database Bottleneck - Read query performance was getting worse and it couldn’t scale to meet the required input/output operations per second.
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·4yLet’s learn, build and sell an API
API is an intermediary between two applications and makes it possible for those two applications to communicate with each other. For example, JokeAPi, The Movie Database, Open Weather API, etc. Let’s build an API service to add, delete, edit and get your daily tasks. We need a database and a server to create anAPI service. We use MongoDB as our database and NodeJs, and ExpressJs for creating a server.
Community Picks·4yDesigning a secure API
API is a bridge that connects two or more programs and it is possible to make companies interact, for example, through payment. In this article, we'll outline ten steps for creating and maintaining a safe API. I API Design First, let's talk about the types of contracts that exist within an API.
freeCodeCamp·4yCode a project three different ways (JavaScript + REST API + Database)
Code a project three different ways (JavaScript + REST API + Database) We just published a course on the freeCodeCamp.org YouTube channel that will teach you how to code a flight widget in JavaScript using multiple methods.
asayer·4yBuild a CRUD app with React and Firebase
Firebase version 9 SDK initiates an API surface that follows a modular approach. In this tutorial, we will build a to-do app with Firebase that will be able to read, edit, and delete Todos. Application Demo: Create, Read, Update, and Delete is referred to as CRUD. The component will be used to display, edit and delete todos. After the imports, create a state named Subject (i.e. and the todos to be added.
freeCodeCamp·4yHow to Architect a Full-Stack Application from Start to Finish
How to Architect a Full-Stack Application from Start to Finish Software architecture is a massive topic. I can give you a simple method you can use to approach the architecture of a full-stack application. Don't build more than what the front-end requires, and try to use the simple data models you created in the database.
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.
Community Picks·4yMonolith vs Microservices: Which should you use
Microservices as a software architecture has made its way into the development teams of popular companies like Netflix and Google. It offers flexibility, scalability and agility for the product or service you’re putting together. But that doesn’t mean it’s a perfect infrastructure, and a lot of companies both big and small still create monoliths.
Discover .NET·4yWhat is Software Architecture?
Software architecture is about making critical decisions early on so your system can evolve without a high cost. Coupling and Cohesion Logical Boundaries are the yin-yangs of software design. Any system will have long-running business processes and workflows that span many logical boundaries. To remove tight coupling, we can leverage asynchronous messaging. Removing direct communication between boundaries means we are also removing temporal coupling.
Real Python·4yChatterBot: Build a Chatbot With Python – Real Python
The ChatterBot library combines language corpora, text processing, machine learning algorithms, and data storage and retrieval. You can build an industry-specific chatbot by training it with relevant data. The chatbot was built and tested with Python 3.10.7 but should also run with older Python versions. If you don’t have all of the prerequisite knowledge before starting this tutorial, that’s okay.
freeCodeCamp·4yThe Best Programming Language to Learn – Beginners Guide to Coding
Coding is one of the most valuable skills to learn today. Coding involves telling a computer what to do using a language both humans and machines understand. HTML and CSS are markup languages, and you use them to create static web pages.
freeCodeCamp·4yComputer Programmer Salary – How Much Do Coders Make?
Coding is one of the most popular and in-demand careers. A computer programmer's salary will generally be lower than someone with a few years of industry experience under their belt. Another option is to learn to code on your own using either free or paid resources such as books, video tutorials, and interactive courses.
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.
The New Stack·4yHow to Use Google Sheets as a Database with React and SSR
How to use Google Sheets as a Database with React and SSR How to Use Google Sheet as a database with React or SSR. Data is sent from the browser to a Serverless Function that securely posts to a Google Sheet. To use Serverless Functions in React you can use either Next.js or Gatsby.
Community Picks·4yHow to Build a Multi-Tenant App with Custom Domains Using Next.js
Use the Platforms Starter Kit to kickstart our Next.js project. In this guide, you'll learn how to build a full-stack multi-tenant application with Custom Domains. You'll need to replace all instances of vercel.pub with your own domain to configure rewrites correctly.
Community Picks·4yBuilding a NestJS REST API using Prisma ORM
Prisma is a next-generation Object Relational Mapper (ORM) It takes a somewhat different approach to traditional ORMs. Instead of classes, Prisma uses a special Schema Definition Language. Prisma runs over the schemas and writes the appropriate migrations depending on the chosen database. For our demo NestJS Prisma application, we will be using SQLite as our database.
