KKrishal Karna·Aug 14, 2025Introduction to Databases and MySQLUnderstand essential database concepts including Data, DBMS, software, Primary Key, and other fundamentals. Perfect for beginners, students, and for all8 min read·completesql.hashnode.dev
SSharif Uddin·Jul 23, 2025How to Disable Foreign Key Checks in MySQL .sql File to Fix Database Import ErrorsLearn how to disable foreign key checks in MySQL .sql files to prevent import errors. Use SET FOREIGN_KEY_CHECKS = 0 to fix foreign key constraint issues.2 min read·sharif-web-dev.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20252. Tables, Entities, and RDBMSIn a database design design we are discuss these three important topics - Tables, Entities and RDBMS. You may ask why ? Aren’t you digressing from the topic ? I would like to say that we would be using these concepts as the building blocks of our des...4 min read·vedicschema.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20251. Databases, Database Design and SQLIn today’s modern digital world dominated by Artificial Intelligence and Machine Learning, data is the new fuel. Data is at the core of every application - from fitness apps, healthcare and e-commerce to banking and social media. We use databases to ...3 min read·vedicschema.hashnode.dev
GGanesh Rama Hegde·Apr 5, 20253. SQL (Structured Query Language) - Part 1What is SQL ? SQL (Structured Query Language) is the standard language used to create, read, update, and delete data in a relational database. Why is SQL important ? It allows us to communicate with the database and manage data effectively. Types of ...4 min read·vedicschema.hashnode.dev
DDanny Crasto·Dec 24, 2024Foreign Key with missing indexesRelational databases have references to other tables via 1-Many relationships using a foreign key. CREATE TABLE Bar( id int NOT NULL, name varchar(128), PRIMARY KEY (id) ); CREATE TABLE Foo ( id int NOT NULL,...2 min read·blog.danwald.me
RRohan·Nov 24, 2024Django ORM: Accessing foreign key objectsOne to many, many to one relationships For demonstration, let’s create a Django project and start an app call books. We will take the example of the relationship between books and reviews and create two simple models for them. As you know, one book c...4 min read·rohansblog.hashnode.dev
DDataWisoka·Jul 3, 2024Choosing the Right Database: Data modeling in Postgres vs DynamoDBCrafting the Blueprint for Your Data - Relational Precision vs. NoSQL Flexibility7 min read·datawisoka.com
RRicardo Ribeiro·Jun 5, 2024Coletando ids do banco de dados (.NET x SQL SERVER)Criando um método que facilite o manejo das chaves do banco dentro do Visual Studio2 min read·kaitozr.hashnode.dev
JJatu Naazneen·Feb 18, 2024Data Organization: Flattened vs. Nested Foreign KeysDiscover the pros and cons of nested foreign keys versus flattened foreign keys in database design. Learn how to optimize data organization.3 min read·blog.naazweb.com