Databases

Tips and content for development using databases.

Databases

Latest tips

View Database Definitions
View the definitions of database entities quickly in the Database Tool Window
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
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.
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.

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