Exploring SQLite with C: How to Download Latest SQLite3; Querying a database with C and SQL

preview_player
Показать описание

In this video, I decided to have some fun with SQLite3. I want to build a CLI program that prints a menu of products and allows the user to place orders. In this video, we got to the point where we can print a list of products.

This video is not really a tutorial, but a recording of my own research, which I am doing purely for fun. Do not try this at home!
  1. Make Programming Fun Again
Рекомендации по теме
Exploring SQLite with 0:58:43

Exploring SQLite with C: How to Download Latest SQLite3; Querying a database with C and SQL

The Best Ways 0:02:11

The Best Ways to Retrieve Foreign Key Values in SQLite with C#

Exploring the New 0:46:52

Exploring the New World : Remote Exploitation of SQLite and Curl

Most Used DB 0:00:43

Most Used DB Engine SQLite #code #programming #data

Exploring SQLite-vec - 0:58:50

Exploring SQLite-vec - new features for a great tool

Fastest Way to 0:01:31

Fastest Way to Find Nearest Coordinates in C- with SQLite

How to Effectively 0:02:36

How to Effectively Use SQLite SELECT ... IN with String Arrays in C-

justanotherdot• Let's explore 1:29:51

justanotherdot• Let's explore SQLite! no.3

Metabase+SQLite DB: Metabase 0:01:57

Metabase+SQLite DB: Metabase Connect & Visualize SQLite DB Directly

How to Create 0:01:48

How to Create a SQLite Database in Objective-C Using Xcode

How to Create 0:02:12

How to Create a C++ 32-bit DLL for Accessing SQLite Database

How to Open 0:02:10

How to Open SQLite Files

C# and SQLite 0:05:00

C# and SQLite (Preview) Simple and Advanced Search (plus Copy/Paste feature)

SQL database in 0:19:18

SQL database in Julia - SQLite tutorial

Introduction to SQLite 0:02:04

Introduction to SQLite Creating a Simple User Database

Troubleshooting SQLite Preparation 0:01:29

Troubleshooting SQLite Preparation Statements in C Code

Resolving the C# 0:02:11

Resolving the C# SQLite Database Locked Error

justanotherdot• Let's explore 1:26:54

justanotherdot• Let's explore SQLite! no.2

How to Properly 0:02:01

How to Properly Handle Wrong Username and Password in C# with SQLite

Introduction to Sqlite 0:14:51

Introduction to Sqlite for Beginners: Full Sqlite3 DB Tutorial

How to connect 0:04:28

How to connect SQLite datbase with Visual Studio Code?

How to Handle 0:02:00

How to Handle SQLite Sequence Table Issues in C# Entity Framework Core

Solving the SQLite 0:02:04

Solving the SQLite String Value Issue in C#

Resolving NULL Value 0:01:46

Resolving NULL Value Crashes in SQLite with C Programming

Комментарии
Автор

Te zmienne z przedrostkami 'z', 'n', 'p' itd. - gość (Hipp) już tak pisze. Wziął ten styl chyba z TCLa. Taka jakaś notacja węgierska.

Taka ciekawostka, że typy kolumn są domyślnie w SQLite tylko dokumentacją. Możesz nawet zadeklarować typ dosłownie 'Eyjafjallajokull'. Tak to dynamicznie przydziela typ podczas inserta i moża różne typy wartości w kolumnie mieszać.

Co do unixepoch - to w miarę niedawne rozszerzenie. Wcześniej trzeba było kombinować z strftime. Co do pierwszego to przydaje się jeszcze opcjonalny argument 'subsec' - domyślnie zwraca tylko sekundy.

kpg_wlkp
Автор

Please please please let's explore how to make a websocket client that will connect to a wss:// end point, send a message and display the reply. I'm talking about connecting to an echo server, anything wss that is not local. Then we can store the result to a mysql db, it will be like a continuation of this project :)

OpenTillDusk
visit shbcf.ru