Geoffrey Copinblog.sylver.dev·Jul 22, 2024Build your own SQLite, Part 1: Listing tablesAs developers, we use databases all the time. But how do they work? In this series, we'll try to answer that question by building our own SQLite-compatible database from scratch. Source code examples will be provided in Rust, but you are encouraged t...yunfan and 1 other are discussing this2 people are discussing thisDiscuss·2 likes·7.8K readsBuild your own SQLiteRust
Jacob PrallforSQLite Cloudsqlitecloud.hashnode.dev·Jul 15, 2024How to: Add full-text search to HashnodeHere at SQLite Cloud, we’re big fans of Hashnode, the developer blogging platform. Recently, we noticed that there is no “out-of-the-box” full-text search for Hashnode. So, we decided to build a simple solution using SQLite Cloud. After following thi...DiscussHashnode
514sid514sid.hashnode.dev·Jul 13, 2024Seamless Telegram Mini App Authentication with React and NestJS: A Step-by-Step GuideIn this article, I will guide you through implementing seamless authentication for your Telegram Mini App using NestJS for the backend and React for the frontend. Source code React app: https://github.com/514sid/tma_auth_client NestJS app: https://gi...Discuss·39 readsminiapp
Harsha Ssharsha315.hashnode.dev·Jul 11, 2024Agent-AMA: An SQL Querying AI AgentIntroduction: Do you need to access information from a database but don’t know how to write SQL queries? Are you a non-technical person worried about how to get the data you need? Well fret not, Agent-AMA is for your rescue. Imagine having a smart AI...Discussreactprompt
Cloud Tunedcloudtuned.hashnode.dev·Jul 5, 2024Daily Hack #day93 - SQLite StudioSQLite Studio is a single-file binary, single-command SQLite database explorer. It offers the following features: Overview page with common metadata. Tables page with each table's metadata, including the disk size being used by each table. Infinit...DiscussDaily HacksSQLite Studio
Jesus Esquerjme2791dev.hashnode.dev·Jul 3, 2024FeaturedStep-by-Step Guide to Creating a Fullstack Mood Tracker CRUD App with React, Node.js, and SQLite.Introduction Hi all, welcome, and thanks for stopping by! In this step-by-step guide, we will learn how to create a full-stack application with create, read, update, and delete (CRUD) functionality. We will use Node.js and SQLite for the backend, and...dash geometry and 4 others are discussing this5 people are discussing thisDiscuss·68 likes·1.3K readsTutorial
Ryan Murzynorian3737.hashnode.dev·Jul 2, 2024Why? So Many to Many Objects!I fondly remember as a child playing with blocks. One toy in particular rings out to me. The match the block to the hole in the box. It was never actually challenging but I never actually wanted to play by the rules. I always wanted to find a way to ...DiscussPython
Dominik KellerforLow-Code Software Engineeringfive.hashnode.dev·Jun 30, 2024How to Build an SQLite GUI (Fast & Easy Tutorial)In this guide, we will walk through the four essential steps to create an SQLite GUI. These steps include: Creating a new application with Five. Connecting to an SQLite database with Five.Five can connect to your existing SQLite database. Just prov...DiscussSQLite
Jacob PrallforSQLite Cloudsqlitecloud.hashnode.dev·Jun 26, 2024Journal Modes in SQLiteSQLite has been the go-to single-user database for over 20 years. Recent advancements in hardware and distributed consensus have opened up SQLite to more use cases - in particular, SQLite’s ease of use and performance characteristics make it an incre...DiscussSQLite
Rohan Shrivastavarohanblogs.hashnode.dev·Jun 22, 2024Scaling Heights: Integrating PostgreSQL with Node.js for Robust PerformanceIn the realm of modern web development, integrating databases with server-side applications is crucial for storing and managing data efficiently. PostgreSQL (Postgres) stands out as a powerful and versatile relational database management system (RDB...DiscussNode.js