Installation and usage of SQLite in Windows

Installation and usage of SQLite in Windows

Bisqwit

2 месяца назад

4,978 Просмотров

SUBTITLES/CAPTIONS ARE AVAILABLE. ENABLE THEM IF YOU NEED THEM.
Tutorial for installing and using the SQLite commandline tool in Windows.
Supplementary material for the Helsinki University course Tietokantojen perusteet / Introduction to Databases, compulsory part of the basic studies in Computer Science.

Тэги:

#databases #relational_database #sql #tutorial #bisqwit #university_of_helsinki
Ссылки и html тэги не поддерживаются


Комментарии:

@focuseletronica
@focuseletronica - 02.09.2024 13:52

O conteúdo aqui é fantástico... Que bom ver você postar mais uma obra prima. Grato por compartilhar conhecimento.

Ответить
@AkshayKumarX
@AkshayKumarX - 02.09.2024 13:52

Hello Bisqwit's students, you have been blessed to be able to receive an education from the man, the myth and the legend himself.

Ответить
@SuperNolane
@SuperNolane - 02.09.2024 13:53

Kiitos videosta!

Ответить
- 02.09.2024 13:57

For people learning finnish language, this is really cool!

Ответить
@LasRozasDeMadrid
@LasRozasDeMadrid - 02.09.2024 14:00

Repent, you infidels! I knew he would come back!

Ответить
@Humble_Electronic_Musician
@Humble_Electronic_Musician - 02.09.2024 14:00

I don't speak Finish, but still am very happy with a new Bisqwit video!

Ответить
@matias-dev
@matias-dev - 02.09.2024 14:01

I don't remember why i had notifications on but this was a great tutorial, thank you for making it, will try it out this way!

Ответить
@petereskileskilsson
@petereskileskilsson - 02.09.2024 14:02

Thanks for the video! Do you think the NES was the defining console for our generation, Gen X?

Ответить
@GameBacardi
@GameBacardi - 02.09.2024 14:12

He Hei!

Ответить
@yurikhramov656
@yurikhramov656 - 02.09.2024 14:14

OMG! Windows ??? Wtf is wrong with you ?

Ответить
@sneak3009
@sneak3009 - 02.09.2024 14:27

I neither need a guide on this topic nor speak Finnish yet here I am. Your students are lucky.

Ответить
@kelo.0
@kelo.0 - 02.09.2024 14:28

Holding shift and right clicking on an empty spot in the explorer window shows an option to open the CMD.exe pointing to the current directory too.

Ответить
@lMINERl
@lMINERl - 02.09.2024 14:32

nice to see you back

Ответить
@Logicatube
@Logicatube - 02.09.2024 14:48

Bisqwit is genius

Ответить
@felixgertrude9311
@felixgertrude9311 - 02.09.2024 14:54

SQLite is the GOAT

Ответить
@philo23
@philo23 - 02.09.2024 15:00

pro tip: If you click on the address bar, replace the address with “cmd” and hit enter, it opens cmd up to the current folder

Ответить
@leocarvalho8051
@leocarvalho8051 - 02.09.2024 15:03

Why english title if video not in english?

Ответить
@woj95
@woj95 - 02.09.2024 15:07

I was expecting him speaking English, and at first didn't understand a thing and thought I had a stroke 😂

Ответить
@yyny0
@yyny0 - 02.09.2024 15:09

One confusing part about CD is that it will not change directory to another drive, so `cd "D:\..."` won't work, and you will have to type `D:` to switch drives as well.

Ответить
@channel11121
@channel11121 - 02.09.2024 15:21

Please do more Finnish-language videos :)

Ответить
@vildis.
@vildis. - 02.09.2024 15:40

Voit myös kirjottaa "cmd" suoraan resurssienhallinnan polun kohtaan joka avaa cmd:n kasioon suoraan

Ответить
@0xdeadbeef131
@0xdeadbeef131 - 02.09.2024 16:53

Goat uploaded

Ответить
@DiggOlive
@DiggOlive - 02.09.2024 16:58

(Translator's note: pista means dot)

Ответить
@JoeBurnett
@JoeBurnett - 02.09.2024 17:10

Good to see you back. Thank goodness for English subtitles!

Ответить
@slipcurve1410
@slipcurve1410 - 02.09.2024 17:21

I wasn't sure if this was SQLite instructions or a tech support scam in Finnish.

Ответить
@Rahul-ys3yh
@Rahul-ys3yh - 02.09.2024 18:06

Hello Bisqwit, looking forward for the multi-threading from ground-up series from you since a long time. Please consider our request.

Ответить
@jaans3712
@jaans3712 - 02.09.2024 19:31

Näin sinut tänä kesänä Citymarketissa. Sulla oli törkeen siistit oranssit shortsit jalassa! Kunnon kesämies 🔥

Ответить
@Mobay18
@Mobay18 - 02.09.2024 20:14

Pretty cool, I used SQLite from a dev environment before, but never knew interacting with it was so easy outside of the dev environment.

Ответить
@kallebanan1924
@kallebanan1924 - 02.09.2024 21:16

Wait so are you a teacher now?

Ответить
@GrepGaming
@GrepGaming - 02.09.2024 22:39

Writing my chip-8 interpreter in rust after doing it in c++. Love the channel

Ответить
@BradenBest
@BradenBest - 02.09.2024 23:57

supplemental information:
* cd stands for change directory
* if you use a command a lot, you don't have to navigate to its directory every time to run it, you can go into your environment variables settings and add the directory where the exe is located to your %PATH%, and then you can use the program (sqlite3 in this case) anywhere you want as if it were a regular command
* you can change your environment variables by opening explorer, right clicking "This PC" or "My Computer" (depends on windows version), properties, advanced system settings, environment variables (button on the bottom), if you just look around a bit, you'll find it

Ответить
@JoLiKMC
@JoLiKMC - 03.09.2024 00:22

Finnish, huh? Alright. Appreciate the tutorial, and appreciate the subtitles. As always, this was informative. Thank you.

Ответить
@Veso266
@Veso266 - 03.09.2024 03:14

Yey a new video

Thats the longest finish video I have seen from u

Do u always speak that fast, or is this some kind of dialect, cuz this sounds like a computer (the flow of voice is so consistent and fast) :)

Ответить
@kenoxys
@kenoxys - 03.09.2024 05:43

Installation and usage of SQLite in Linux

Ответить
@Amberlynn_Reid
@Amberlynn_Reid - 03.09.2024 08:47

This is like how they installed jetfuel lite on the twin towers

Ответить
@educate9946
@educate9946 - 03.09.2024 14:19

I worked as a teaching assistant ten years ago, trying my best to explain how to set PATH and so on in Windows. It was, well, let's call it exciting. This reminds me of that.

Ответить
@weegeeweeg
@weegeeweeg - 03.09.2024 22:18

Thanks Bisqwit. I don't know Finnish and I don't like Windows 8 or higher but I like your videos.

Ответить
@EzequielCarvalho
@EzequielCarvalho - 04.09.2024 04:34

I missed your videos. Hugs from Brazil

Ответить
@taeril8442
@taeril8442 - 04.09.2024 07:41

Yay! New video :) I prefer to type in Explorer alt+d to highlight path (you've done it with mouse) and then type there cmd. Faster and I'm already in right directory :D Reopening database was great moment to tell that it can be done also as command line argument, with filename completions and less typing (no .open). Overall looks like good introduction, but it's hard to judge at what total beginners can trip, and how to balance density of given knowledge.

Ответить
@acos21
@acos21 - 04.09.2024 08:17

I will be honest: after 8 months silence from you i expected something more when i saw the new video notification.

Ответить
@v3ldin
@v3ldin - 04.09.2024 10:11

Finish**Finish Precomipled binaries for Windows Finish**Finish**Finish

Ответить
@woahhhhhh9571
@woahhhhhh9571 - 04.09.2024 20:26

precompiled binaries for windows 🗣🗣🗣

Ответить
@grumpyssandbox8363
@grumpyssandbox8363 - 05.09.2024 01:35

Glad you're doing well Bisqwit! Wishing you the best!

Ответить
@gnu-lynx2501
@gnu-lynx2501 - 06.09.2024 02:33

not the Bisqwit I expected :( lol sql windows :D

Ответить
@jlmg3543
@jlmg3543 - 06.09.2024 05:24

Paren todo, Bisqwit subio video!!

Ответить
@chetana9802
@chetana9802 - 06.09.2024 20:29

Would be nice to add English Audio

Ответить
@GiygasForPresident
@GiygasForPresident - 07.09.2024 15:29

Can you do one for Debian/Ubuntu?

Ответить
@crenio5
@crenio5 - 18.09.2024 03:10

Do you have gallstone problems?

Ответить
@darealshinji
@darealshinji - 24.09.2024 00:26

Installation through winget package manager command is possible too.

Ответить
@m4rt_
@m4rt_ - 27.09.2024 12:33

Reminds me of the time I had to try and solve an issue I had, and the only resource I found on it was a video tutorial in German
... I don't speak German.

Ответить