SQLite Toolbox Extension for Visual Studio

117Likes

4,220Views

Mar 32025

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

Transcript

Follow along using the transcript.

Microsoft Visual Studio

334K subscribers

SQLite Toolbox Extension for Visual Studio

Chapters View all

Introduction

Introduction

Introduction

Overview of SQLite

Overview of SQLite

Overview of SQLite

Overview of SQLite & SQL Server Compact Toolbox extension

Overview of SQLite & SQL Server Compact Toolbox extension

Overview of SQLite & SQL Server Compact Toolbox extension

Installing and launching the extension

Installing and launching the extension

Installing and launching the extension

Viewing existing data connections

Viewing existing data connections

Viewing existing data connections

Scripting and migrating SQL Server databases

Scripting and migrating SQL Server databases

Scripting and migrating SQL Server databases

Creating a new SQLite database

Creating a new SQLite database

Creating a new SQLite database

Connecting to an existing SQLite database

Connecting to an existing SQLite database

Connecting to an existing SQLite database

Microsoft Visual Studio

SQLite Toolbox Extension for Visual Studio

Comments 5

Chapters

Introduction

Introduction

Introduction

Overview of SQLite

Overview of SQLite

Overview of SQLite

Overview of SQLite & SQL Server Compact Toolbox extension

Overview of SQLite & SQL Server Compact Toolbox extension

Overview of SQLite & SQL Server Compact Toolbox extension

Installing and launching the extension

Installing and launching the extension

Installing and launching the extension

Viewing existing data connections

Viewing existing data connections

Viewing existing data connections

Scripting and migrating SQL Server databases

Scripting and migrating SQL Server databases

Scripting and migrating SQL Server databases

Creating a new SQLite database

Creating a new SQLite database

Creating a new SQLite database

Connecting to an existing SQLite database

Connecting to an existing SQLite database

Connecting to an existing SQLite database

Editing and viewing data

Editing and viewing data

Editing and viewing data

Viewing query results in grids, including grouping and filtering

Viewing query results in grids, including grouping and filtering

Viewing query results in grids, including grouping and filtering

Adding columns and indexes to tables

Adding columns and indexes to tables

Adding columns and indexes to tables

Maintenance tasks for SQLite databases (vacuum and re-index)

Maintenance tasks for SQLite databases (vacuum and re-index)

Maintenance tasks for SQLite databases (vacuum and re-index)

Creating a database graph

Creating a database graph

Creating a database graph

What's new in the extension? (spoiler alert: not much!)

What's new in the extension? (spoiler alert: not much!)

What's new in the extension? (spoiler alert: not much!)

Discussion of using contributors to help build the extension

Discussion of using contributors to help build the extension

Discussion of using contributors to help build the extension

Discussion of maintaining a mature extension

Discussion of maintaining a mature extension

Discussion of maintaining a mature extension

Wrap-up

Wrap-up

Chapters

Chapters