Bulk Insertion in Entity Framework Core - Speeding Up Data Operations
Explore bulk insertion in Entity Framework Core to significantly enhance data operation performance. Compare standard and bulk insertion methods for improved efficiency in database operations.
SQLite Introduction - Beginners Guide to SQL and Databases
Learn SQLite basics, including commands, data manipulation, and joins. Gain practical skills for database management and querying in this beginner-friendly introduction.
Open Source Matters - The Journey of NTT DATA
Explore NTT DATA's journey in open source contributions, from PostgreSQL to Hadoop, and learn about their future focus on confidential computing and Kubernetes operators.
What's Hot in MySQL - A Sneak Peek at Game-Changing Features
Explore the latest MySQL advancements, including performance enhancements, scalability improvements, and new versioning policy. Gain insights into innovative features for both experienced users and newcomers.
The What and Why of Cassandra Data Modeling at Scale
Explore Cassandra data modeling challenges and best practices for high performance at scale, drawing insights from a migration project from DB2 to Cassandra.
SQLite in WebAssembly - A Glimpse into the Future of Shared Libraries
Explore Wasm's potential through a live demo mirroring SQLite between browser tabs and edge, enabling offline-first collaborative workloads and showcasing Wasm's flexibility in various environments.
PostgreSQL Setup with WSL2 for ASP.NET Core and EF Core - Tricking Library Episode 62
Learn to set up PostgreSQL on Windows with WSL2, interact via command line, and use Entity Framework client. Practical guide for ASP.NET Core and C# developers working with databases.
ASP.NET Core, Nuxtjs, PostgreSQL, and Github Actions - Hosting on Linode - Tricking Library Episode 65
Learn to host an ASP.NET Core API and Nuxt.js app on a Linux VM using Linode, with PostgreSQL database integration and GitHub Actions for deployment automation.
Views in SQL - Create View from Single Table - Multiple Tables - Drop View
Learn to create and manage SQL views from single or multiple tables, including syntax for creation and deletion, enhancing database query efficiency and data organization.
Queries on Sailors, Boats & Reserves Table in SQL
Learn SQL queries for sailors and boats database, covering joins, subqueries, and aggregate functions to extract specific information from multiple tables.
The Architecture of a Forever Free, Serverless SQL Database
Explore the internals of a serverless database, including automatic scaling, transaction isolation, resilience, data localization, and cost-effective usage in CockroachDB Serverless.
Bulk Insertion in Entity Framework Core - Doubling Query Speed
Optimize Entity Framework Core data operations with bulk insertion. Compare standard and bulk methods for improved performance in .NET 8 projects using SQLite.
Building a Local SQLite Vector Database for Multi-Modal Image Search
Build a SQLite vector database for image search using embeddings and GPT Vision, enabling cosine similarity queries to find relevant images based on user input.
Tyqu - Typesafe SQL Queries in Scala
Introducing Tyqu: A Scala library for type-safe SQL queries. Leverages Scala 3 features for convenient, functional-style database interactions with compile-time checks and runtime code generation.
Build and Deploy an Authenticated To Do App - Postgres + React + Node.js + Kinsta
Build and deploy an authenticated to-do app using PostgreSQL, React, and Node.js. Learn full-stack development with hands-on experience in database integration, user authentication, and cloud deployment.
React Next.js Food Delivery App Full Tutorial - Full Stack Restaurant App
Build a full-stack food delivery app using Next.js, Prisma, PostgreSQL, Auth.js, Stripe, Docker, React Query, and Zustand. Learn CRUD operations, authentication, state management, and payment integration.
Distributed Databases on the Jamstack
Explore MongoDB for distributed databases on Jamstack. Learn document vs relational databases, security setup, team collaboration, and implementing features like autocomplete with MongoDB Realm.
Hands-on Introduction to Litestream - SQLite Streaming Replication
Explore SQLite streaming replication with Litestream in this hands-on tutorial. Learn installation, database creation, replication, subcommands, and restoration techniques for efficient SQLite management at scale.
Introduction to Timescale - Getting Started with Time-Series Data
Comprehensive introduction to TimescaleDB, covering setup, data import, querying, and advanced geospatial time series analysis with hands-on demonstrations and expert insights.
Create Command in SQL - DDL Commands - Create Database - Create Table - MySQL - Create Query
Learn to create databases and tables in MySQL using SQL DDL commands. Covers database creation, table structure, and basic syntax for defining and organizing data.
Python and MySQL - Create and Insert Query
Learn to create tables and insert data in MySQL using Python, covering syntax, CREATE TABLE, and INSERT queries for efficient database management.