LordOfDarknessdevtriet.hashnode.dev·an hour agoKickstart Your SQL Journey: Setting Up Your SQLite Environment on Day 2If you’re just starting with SQL, SQLite is one of the best database systems to use. Its lightweight, serverless architecture makes it easy to set up and perfect for small-scale projects or learning SQL fundamentals. On Day 2 of your SQL journey, we’...DiscussSQL
Brayden Wilmothbraydenwilmoth.hashnode.dev·16 hours agoPre and Post Query HooksToday in celebration of the launch week announcement from Outerbase we’re releasing a blog post that digs into a part of StarbaseDB that makes it more expansive than ever with feature capabilities. If you haven’t yet seen the Outerbase announcement t...Discussstarbasedb
LordOfDarknessdevtriet.hashnode.dev·Dec 1, 2024Introduction to SQL: Day 1 - A Beginner's Guide to DatabasesIt is known in the programming world that there are a variety of languages for a diversity of tasks. We, as humans, can’t master every single programming language out there. We can just look at each of them and learn the basics. So, over the next 15 ...DiscussSQL
Joseph Jegedejosephjegede.hashnode.dev·Nov 29, 2024SQLite for Starters: Manage a Musician Database and Export to Excel (CSV)Let’s start with the basics SQL, short for Structured Query Language, is a tool for managing and working with relational databases. These databases store information in a table format, where rows are individual entries and columns categorise the data...DiscussSQL
Ugo Umeokeeurocode.hashnode.dev·Nov 29, 2024Quick Guide to Identity Endpoints in .NET 8+Identity management is a critical aspect of modern web applications, providing the infrastructure necessary for managing users, roles, authentication, and authorization. With .NET 8, Microsoft has further streamlined the process by introducing enhanc...DiscussC#
Emma GenesenforSQLite Cloudsqlitecloud.hashnode.dev·Nov 19, 2024Release Notes: Introducing Database Studio in SQLite CloudFollow along with updates and improvements made to SQLite Cloud on LinkedIn and Hashnode. Welcome to our monthly release notes! In this edition, we’re bringing you some major updates to the SQLite Cloud dashboard. Database Studio We’re excited to ann...DiscussSQLite
Geoffrey Copinblog.sylver.dev·Nov 18, 2024Build your own SQLite, Part 3: SQL parsing 101After discovering the SQLite file format and implementing the .tables command in part 1 and part 2 of this series, we're ready to tackle the next big challenge: writing our own SQL parser from scratch. As the SQL dialect supported by SQLite is quite ...Discuss·2 likes·9.7K readsBuild your own SQLiteRust
Anix Lynchanixblog.hashnode.dev·Nov 16, 2024SQLite Northwind 1# Create DatabaseStep 1: Create a New Folder Create a folder named sqlite_db in drive E (or any preferred location on your computer). This folder will store your database files. Step 2: Create a New Python Script Open a new Python script and save it as create_dat...DiscussSQLite
Bryan Samuel Jamesorder-processing-system.hashnode.dev·Nov 12, 2024Mastering Order Processing Systems: A Comprehensive Guide to Building Efficient Business Solutions with PythonPart 6: Creating the User Interface - Introduction to Tkinter Introduction To make our order processing system user-friendly, we’ll build a graphical user interface (GUI) using Tkinter, Python's standard GUI toolkit. Tkinter allows us to create windo...Discuss#OrderProcessing
Arthur Arizaarthurariza.hashnode.dev·Nov 6, 2024Setting up a productive development environment for Rails 8 with tmuxThis guide provides a tmux script for setting up a Rails development environment, complete with multiple windows for common tasks. Follow along to configure it, customize it, and streamline your workflow. TLDR Here’s the final script for those in a h...Discuss·46 readsRails 8