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.

Getting Started with Redis in Go

Tutorial

Getting Started with Redis in Go
Using Redis in a Go Project
Transactions

Part of tutorial

Transactions
Using Redis Transactions for Data Integrity
Best Practices

Part of tutorial

Best Practices
Essential Techniques to Ensure Efficiency and Success with Redis
Conclusion

Part of tutorial

Conclusion
Considerations and Next Steps
Redis & GoLand

Part of tutorial

Redis & GoLand
Streamlining GoLand and Redis Setup for Smooth Development
Pipelines: Running Redis Commands in Batches

Part of tutorial

Pipelines: Running Redis Commands in Batches
Efficiency in Bulk - Maximizing Performance with Redis Pipelines
Learn Redis by Coding

Part of tutorial

Learn Redis by Coding
Unlocking Key Concepts Through Six Interactive Demos
Pub-Sub Messaging

Part of tutorial

Pub-Sub Messaging
Simplifying Communication Between Applications
What Is Redis?

Part of tutorial

What Is Redis?
Unlocking the Power of Redis - A Practical Guide for Go Developers
Expiring Keys

Part of tutorial

Expiring Keys
Redis Key Expiry - Maximizing Data Efficiency with Time-Based Management
New Project

Part of tutorial

New Project
From Concept to Code - Crafting Your Project's Foundation
Prerequisites

Part of tutorial

Prerequisites
Install and Resolve Dependencies to Work With Redis
Getting and Setting a Value

Part of tutorial

Getting and Setting a Value
Efficient Data Handling - Redis Retrieval and Storage Capabilities
Automate checks for your Django project

Tip

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

Tip

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

Tip

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

Tip

View Database Definitions
View the definitions of database entities quickly in the Database Tool Window
Working with Multiple Databases in a JetBrains IDE

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!
Working with SQLite Databases in any JetBrains IDE

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.
Synthesizing a Database With Kotlin

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!
Connect from the IDE to a postgreSQL database

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.
Zero to Document Hero - Introduction to MongoDB

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.
Quickly Explore Database Tables in any JetBrains IDE

Tip

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

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.
Turbocharging SQL Queries

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.
5 Tips for Combining Python and SQL in Datalore

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?
Working with SQL and databases in Rider

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.
Write SQL queries using popular database packages

Tip

Write SQL queries using popular database packages
Work with SQL queries and get completion and other features automatically.
Connect from the IDE to a MongoDB database

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.
Query MongoDB databases

Tip

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

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
Setting Up a Database in MongoDB Atlas

Part of tutorial

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

Tip

Query MongoDB databases using SQL statements
Run MongoDB queries in SQL format from the comfort of your IDE.
Webinar Summary - Working with SQL and Databases in IntelliJ IDEA

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.
Database Visualization

Tip

Database Visualization
Visualize the structure of a database with diagrams
Database Performance Tips with Django

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.
Create SQLite Connection

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.
Create SQLite Database Connection By Drag-and-Drop

Tip

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