Databases

Tips and content for development using databases.

Databases

Latest tips

Automate checks for your Django project
Extend Django's system check framework to turn painful code reviews into a joy.
Demystifying nulls and blanks in Django
What is the difference between blank=True and null=True anyway?
Speed up your Django queries
Optimising queries beyond the N + 1 problem.
View Database Definitions
View the definitions of database entities quickly in the Database Tool Window

Latest links

Synthesizing a Database With Kotlin
In this episode of Talking Kotlin, we discuss how Synthesized uses Kotlin together with custom DSLs and OpenAPI to do just that!
Zero to Document Hero - Introduction to MongoDB
Once upon a time, relational databases, or RDMS (think SQL), were the only data store in town. But now there’s a competitor, a group of non-SQL (aka NoSQL) databases, including document databases such as MongoDB.
Working with SQL and databases in WebStorm
In this webinar, we’ll show the basics of writing SQL queries and working with data using the Database Tools and SQL plugin for WebStorm.
5 Tips for Combining Python and SQL in Datalore
SQL is extremely good for data retrieval and calculating basic statistics, whereas Python comes into its own when you need in-depth, flexible exploratory data analysis or data science. What if you could use both programming languages inside of one tool?

NoSQL with MongoDB

Zero to Document Hero - Introduction to MongoDB
Once upon a time, relational databases, or RDMS (think SQL), were the only data store in town. But now there’s a competitor, a group of non-SQL (aka NoSQL) databases, including document databases such as MongoDB.
Connect from the IDE to a MongoDB database
Gain access to the database from the IDE and do all the work in the same window.
Query MongoDB databases
Run any queries you want against the database from the comfort of your IDE.
Query MongoDB databases using SQL statements
Run MongoDB queries in SQL format from the comfort of your IDE.

Spring Boot – Marco Codes

H2 Database - Intro
Working with an H2 Database
Spring Data JDBC - Repositories
Working with Spring Data JDBC

Data access in .NET

Basics of Entity Framework Core
Working with databases using an object relational mapper
Basics of ADO.NET
Working with databases using DbConnection, DbCommand, and DbDataReader
Basics of Dapper
Working with databases using Open Source