Working with SQLite Databases in any JetBrains IDE

Working with SQLite databases is easier than you think! 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. You’ll also find out all of the great functionality our IDEs have for working with SQLite databases, including code completion and inspections for SQL, interactive data tables, and a huge range of data extraction formats.

[lizleigh]

This is great - if I had discovered this a few months ago, I might have saved myself quite a bit of heartache and work. It may have solved quite a few issues for me even now. Many thanks.

[mborus]

This is really useful. One hint about this:

If you're writing a new program, you will probably have to start creating the sqlite database from scratch a few times. In the properties of the database connection in the IDE you can select "auto-disconnect" after a few seconds. The default value tells the IDE to keep a connection open. This blocks you from deleting and recreating the database under the same name. If you auto-disconnect, the IDE will still reconnect whenever needed, but you can delete the database any time you like.

[neatnateable]

Such a great video. Thanks for the education, personality, and humor!

[jesprotech]

Looks like we can work with SQLite pretty much in the same way like with PostgreSQL or other databases that the JetBrains IDE already supports. That's a plus point! 👍

[atgamerzpro]

yeah got it thanks jetbrain for launching this awsome IDE

[psychotrout]

I definitely love the way this was presented :D Also cool tooling :D

[mustafakurtulus]

I love how happy about this feature lol.

[AR-etmh]

I am totally new with SQLite . I receive my computer and now interesting to learn SQLite. May i please know how to start. I dont even know if this is already include in the computer. I am using macbook. Thank you

[decline]

"...in any JetBrains IDE" <= except WebStorm, where you have to pay for the plugin. Which is a shame if you are a NodeJS developer :/

[sen]

Hi. I'm using IntelliJ IDEA (2021.3, I think) and can't seem to find any "Database" window even with double-shift. Is it a plugin or a more recent feature, or am I just doing something wrong?

[samschmitt]

How can I actually use a SQLite data source within a Java project? Should have the necessary drivers but cannot figure out how to get the connection in the program itself.

[quintencabo]

I didn't know you could drag drop like that. That is very nice

[sergkornev]

what an interesting map in the background, what is shown on it? i mean colors

[SherrieffRose]

How do you create a sqlite database from scratch in datagrip

[manuelvega.]

I have used the paid extension in WebStorm, is it this extension that you are talking about or is it now in the IDE?

[suntrop]

Why not something like MySQL with a gui?

[barbarosatmaca]

is that an ethnicity map on the background ?

[playful_bite]

Feels incomplete without an actual pasta recipe.