What are people using (if anything) for looking at SQLite databases ? i am using the SQLite and SQL Server compact toolbox extension for visual studio. (https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolbox) which is OK, but a little clunkly, and really minor annoyance is i can't seem to rename the connections, so when i have more than one open it looks like this. which isn't ideal. - anyone else got a good tool ? https://cdn.discordapp.com/attachments/1337366081857257496/1337366082209583104/image.png?ex=67a72eb9&is=67a5dd39&hm=b1dee0dd8dbec02d52f6ca0f10acd4037e5e41c4770476d6b8404c9627a99a86&

Rider!

I very nearly said except rider 😁

Use the free version just for SQLLite 😄

https://cdn.discordapp.com/attachments/1337366081857257496/1337368670288220180/image.png?ex=67a73122&is=67a5dfa2&hm=bbc235d89d1b18b6a3c0673eb7ea26dc1c6135e4cee9fb38af4a9ee3982661f4& https://cdn.discordapp.com/attachments/1337366081857257496/1337368670527160360/image.png?ex=67a73122&is=67a5dfa2&hm=be13d0632d646ed9719605b6d78b33f0151f8365b7f96dd160e00e54cd9a2fa7& https://cdn.discordapp.com/attachments/1337366081857257496/1337368670808047637/image.png?ex=67a73122&is=67a5dfa2&hm=4076a75ee1c121de4671337076a26063f9666ff51c1030f95d0163f344b9f073& https://cdn.discordapp.com/attachments/1337366081857257496/1337368671068360745/image.png?ex=67a73122&is=67a5dfa2&hm=60f7bcb57f80ce0a99fe4e8300eac125b995c815f37833017317e9a0c10b4527&

Can you rename the connections in the tree?

ohhh.. DB Browser for SQL- gives you pretty JSON, and you can edit it (not sure i would actually want to do this, but..) https://sqlitebrowser.org/ https://cdn.discordapp.com/attachments/1337366081857257496/1337379558189568020/image.png?ex=67a73b45&is=67a5e9c5&hm=f606ff7054ecefc1b2db507da3bb00359ce6c9ce9a97af69170df4e77a9d3c8a&

Many formats, no editing though https://cdn.discordapp.com/attachments/1337366081857257496/1337383650391756810/image.png?ex=67a73f15&is=67a5ed95&hm=4a2778dd26166efdc4709be2ed19529eb1f5c7137d75fb5c5187591228c764ba&

At some point I discovered HeidiSQL. It can connect with Sqlite databases. It works. It's not anything special though

Jetbrains also have an ide specifically geared towards working with most databases including sqlite called 'DataGrip'. I swap between Rider and DataGrip. https://www.jetbrains.com/datagrip/

I haven’t needed to do this for a while, but I used to use an SSMS extension that lets you connect to the db. https://marketplace.visualstudio.com/items?itemName=ErikEJ.SQLServerCompactSQLiteToolboxforSSMS#overview

+1 for DB Browser for SQLite (DB4S), I use it all the time.

yes, +1 from me too

I am enjoying DB Browser , i has one (really small) annoyance, it locks the sqllite file, which means when you are doing a quick tear down of a test site for a clean start (

rm -r .\umbraco\

) it fails 🙁

could you use handle.exe or fshc.exe to get the PID and then kill the process as part of the tear down script?

I spotted this just now if it is useful:

Oh wow, I've wanted that forever. need to watch the video then!

I know right!

I just had to try out migrating a localdb to sqlite, but I keep getting this error: https://cdn.discordapp.com/attachments/1337366081857257496/1349354242653028403/image.png?ex=67d2cb91&is=67d17a11&hm=2727cbd22bf4d3d04afe7138a857add7a59e34a1af6909a4f71ba48c417b1d7a&

Did you watch the video? There are some unsupported properties.