Databases

Databases

Working with relational databases.

Many projects work with relational databases and many of our IDEs make this a first-class part of the workflow by integrating DataGrip, our SQL IDE.

tip

Automate checks for your Django project
Extend Django's system check framework to turn painful code reviews into a joy.

tip

Demystifying nulls and blanks in Django
What is the difference between blank=True and null=True anyway?

tip

Speed up your Django queries
Optimising queries beyond the N + 1 problem.

tip

View Database Definitions
View the definitions of database entities quickly in the Database Tool Window

YouTube

Beyond Relational With Entity Framework
Giorgi Dalakishvili

tip

Working with Multiple Databases in a JetBrains IDE
Oh drat! In your latest project, you need to use data from multiple different databases - and worse still, they’re different database types!

tip

Working with SQLite Databases in any JetBrains IDE
In this video, you’ll see how you can skip messing around with the command line and connect to your database just by dragging and dropping.

YouTube

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!

tip

Connect from the IDE to a postgreSQL database
Gain access to the database from the IDE and do all the work in the same window.

YouTube

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.

tip

Quickly Explore Database Tables in any JetBrains IDE
How does exploring your database without writing a single line of SQL sound?

YouTube

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.

tip

Turbocharging SQL Queries
Want to take your SQL query speed to the next level? This video will explore how your JetBrains IDE can help you achieve faster SQL queries.

YouTube

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?

YouTube

Working with SQL and databases in Rider
In this webinar, we'll show the basics of writing SQL queries and working with data in Rider. All described is also relevant to the dedicated database IDE called DataGrip and all other IntelliJ-based IDEs.

tip

Write SQL queries using popular database packages
Work with SQL queries and get completion and other features automatically.

tip

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.

tip

Query MongoDB databases
Run any queries you want against the database from the comfort of your IDE.

YouTube

DataGrip Overview
This is the overview video of DataGrip, the SQL IDE from JetBrains. We'll tell you about what DataGrip can do and how it can save you time

Part of tutorial

Setting Up a Database in MongoDB Atlas
Connect MongoDB smoothly by connecting through Pycharm Professional to explore the database GUI.

tip

Query MongoDB databases using SQL statements
Run MongoDB queries in SQL format from the comfort of your IDE.

JetBrains Blog

Webinar Summary - Working with SQL and Databases in IntelliJ IDEA
On October 16, 2020, we hosted the live webinar ‘Working with SQL and Databases in IntelliJ IDEA’ by Maksim Sobolevskiy, Product Marketing Manager for Database Tools at JetBrains.

tip

Database Visualization
Visualize the structure of a database with diagrams

YouTube

Database Performance Tips with Django
Most performance problems in web applications come down to one thing, the database. In this webinar, veteran Python developer Andrew Brookins helps you squeeze every ounce of database performance from your Django application.

YouTube

Create SQLite Connection
In this very short video you will learn how to drag-and-drop a .sqlite database file onto the Database tool to create a connection.

tip

Create SQLite Database Connection By Drag-and-Drop
Drag-and-drop a .sqlite database file onto the Database tool to create a connection.