Microsoft MVP Erik Jensen showcases the SQLite / SQL Server Compact Toolbox extension for Visual Studio. This extension adds several features to help your embedded database development efforts, including: scripting of tables and data, importing from SQL Server and CSV files, and much, much more!
⌚ Chapters:
00:00 - Introduction
01:25 - Overview of SQLite
03:45 - Overview of SQLite & SQL Server Compact Toolbox extension
07:55 - Installing and launching the extension
09:30 - Viewing existing data connections
09:55 - Scripting and migrating SQL Server databases
11:25 - Creating a new SQLite database
15:45 - Connecting to an existing SQLite database
18:40 - Editing and viewing data
20:50 - Viewing query results in grids, including grouping and filtering
23:30 - Adding columns and indexes to tables
25:00 - Maintenance tasks for SQLite databases (vacuum and re-index)
26:45 - Creating a database graph
30:20 - What's new in the extension? (spoiler alert: not much!)
31:10 - Discussion of using contributors to help build the extension
33:50 - Discussion of maintaining a mature extension
35:00 - Wrap-up
🔗 SQLite/SQL Server Compact Toolbox extension: https://aka.ms/SQLServerCompactToolbox
🎙️Featuring: Erik Jensen (@ErikEJ), Leslie Richardson (@lyrichardson01), Robert Green
Connect: https://erikej.github.io/
#sqlite #visualstudio
