Intro

Demo app overview (win form app)

What is SQLite

How to create and build SQLite Database: DB Browser for SQLite

Database Structure

Adding the Database to the project

Adding the Connection string

SQLite and Dapper NUGet packages

Data access setup

Retrieving data form DB: LoadPeople()

Sending data to DB: SavePerson()

Wiring up the Demo app

Workings with the Database

Summary and concluding remarks

Course Introduction

SQLite Tools

Data Types

Getters and Setters

Exception handling

Cursor Factory

Inserting a Row

Local Variables

Viewing Data

Conclusion

What is SQLite?

Create a.NET Core console app

Installing the SQLite NuGet Package

Specify connection metadata

Create a Table

Inserting data

Create an SQLite Command object

Close connection

Running the application

Conclusion

Intro

Creating a new solution with a Blazor server project

Visual Studio version

Installing NuGet packages

Creating a code-first database with EF

Creating a simple Blazor front-end

Publishing to Azure (App Service)

Outro

Database Context Class

Product Model

Wrapper around Sqlite

Sqlite Flags

Create a Table

Updating an Item

Simple Template Design Pattern

Add the Database Context as a Dependency

Clone Method

Build the App

Intro to SQLite

Install SQLite Extension

Install Database Viewer

Initialize Database Manually

Automate Database Initialization

Connection String

Code Review

Run Code to Create DB file

Add DB Viewer Connection

Overview

DB Browser

Database Connections

Add Database Connections

Using Database Connections Built-In Authorization and Access Control

Log In

Link an Existing Database to Our Production

NET 6 🚀 EF Core & SQLite with Code First Migrations

Create a new Web API Project

Install Entity Framework Core Tools & NuGet Packages

Add the Connection String for SQLite

Create a New Entity

Implement the DataContext

Register the DataContext

Utilize Code First Migrations

Fixing the Connection String

Use the DB Browser for SQLite

Add a Controller with GET & POST Methods

Test Everything

Intro

Database Options & Installing SQLite-net

Database Service & SQLite Setup

Basic CRUD operations

Database with MVVM

Wrap-up

Intro

Download the SQLite3.c file

Install SQLite3

Create a directory for the database

Create table

SELECT function

Open database and evaluate SQL statements

Summary

SQLite3::execute()

Code review

Intro

Note App XML

List View Java

SQLite Helper

Save Data

Edit Data

Delete Data

Demo of the finished app

Setting up our project

Adding the model

Creating the database helper

Implementing Insert

Implementing update

Implementing delete

Implementing retrieve list of models

Editing the UI

Testing the app

Introduction to Chroma localhost

Current Chroma Version on Github

Pulling in the latest chroma docker image

Run ChromaDB on docker - no custom configuration

Uploading our first embedding

Problems and caveats to running with no persistence

Run ChromaDB WITH PERSISTENCE!

Define where storage should be saved

What ChromaDB Storage looks like

Reboot ChromaDB docker but use existing data!

Run ChromaDB on Docker with persistence AND private API keys

Conclusion on how to best run docker locally - thanks!

Intro

Setting up

Creating a data source

Customizing prefixes

Running the code

Preventing SQL Injection

Using the getPrefix method

Updating Prefixes

Create prepared statement

Conclusion

Intro

Installing Composer

Starting with the index.php file

Setting up the server

Installing Postman

Adding Routes

Connecting to the Database

Routes continued...

Using DBAL for Database Queries

Understanding Dependency Injection

Route to get all players

Route to get a single player

Route to add a new player

Getting input data using Body Parser Middleware

Route to update a player

Route to delete a player

Authentication

Request data validation

Handling Errors

Storing credentials in dotenv file

Final Notes