Installation and usage of SQLite in Windows

[@AkshayKumarX]

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

[@DiggOlive]

wake up babe, we're moving to finland

[@Humble_Electronic_Musician]

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

[@Bisqwit]

As usual with my videos, captions are provided!

[@Humble_Electronic_Musician]

@@Bisqwit Thanks 🙂 I watched without subtitles, without knowing Finish and could still follow along perfectly. So very clear video 👍 God bless you!

[@JoeBurnett]

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

[@GrepGaming]

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

[@matias-dev]

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!

For people learning finnish language, this is really cool!

[@channel11121]

It is!

[@oramatash]

that language sounds like ta ta ta ta ta ta ta tapatapatapatapa

[@Bisqwit]

Finnish is very rhythmical indeed. In fact, phoneme length plays a crucial role in Finnish.

[@sneak3009]

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

[@grumpyssandbox8363]

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

[@philo23]

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

[@Bisqwit]

Confirmed. I only learned this when I asked for reviews and verification from Discord users. Not many people in general seem to know it.

[@Chriva]

I salute you for that trick! :D

[@BradenBest]

what the fuck? That's so weird. I'll have to remember that. There used to be a thing where you could right click in a folder and there was an option to "open command window here", but I haven't seen that option in years

[@Chriva]

@@BradenBest They've replaced it with powershell or, if you have installed it, Microsoft terminal. Seem to recall one having to push shift as you right-click to un-hide the option on some unknown prior version of Windows in the past but could be misremembering.

[@philo23]

@@BradenBest ~as far as I know, it'll work with any .exe in your $PATH that accepts a folder as its first argument~ edit: ignore me, this is wrong

[@educate9946]

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.

[@Mobay18]

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

[@EzequielCarvalho]

I missed your videos. Hugs from Brazil

[@petereskileskilsson]

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

[@Bisqwit]

I have no idea how the generation designations go, but I am inclined to agree with that assessment.

[@taeril8442]

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.

[@Bisqwit]

Yes, alt+d and cmd would have been more efficient. I learned of both only after I had made this video. I contemplated whether to remake that part, but I then thought, it doesn’t really do harm to teach the “cd” command, as it subtly reinforces the concept of current working directory, that comes up time to time again. I also covered the usage of the commandline argument later in the video, but starting with .open seemed to flow better when the sqlite instance was already open. Thank you for the comment, I appreciate it.

[@darealshinji]

Installation through winget package manager command is possible too.

[@Bisqwit]

@@darealshinjiOn which systems? Never heard of it.

[@bug1083]

@@Bisqwit It's a package manager built into Windows. However, I'm ensure if this package manager is Windows 11 only or supported and installed on both 10 and 11.

[@JoLiKMC]

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

[@lMINERl]

nice to see you back

[@yyny0]

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.

[@Bisqwit]

That's true. Should have thought of that. There's always something. Not only is it a hostile platform for developers, it's also a hostile platform for tutorial writers.

[@charlesthethobe9300]

Or use the /d switch `cd /d "E:\..."` It changes both the directory and the current drive.

[@BradenBest]

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

[@Bisqwit]

Good tips. However, %PATH% does not set the current working directory, which determines where the database files will be accessed from.

[@BradenBest]

@@Bisqwit True, and I see that as a benefit--rather than have all your databases in the same folder as sqlite3, you can organize them in the way that makes the most sense.

[@Bisqwit]

The reason this video was made is because students keep having trouble with their database file locations. They download the file in some folder, launch sqlite and try to access the file, but they only end up creating a blank database in some completely unrelated folder. It is the single most time-consuming recurring thing that comes up when I assist the students.

[@vildis.]

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

[@focuseletronica]

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

[@channel11121]

Please do more Finnish-language videos :)

[@Veso266]

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) :)

[@Bisqwit]

I actually spoke slower than normal in this video…

[@Veso266]

@@Bisqwit oh ok, what kind of accent are u speaking Because if you see how this guy speaks: kzbin.info/www/bejne/haPXf2mkZtt7nJo Its way slower Sorry for personal questions, just a foreigner intrasted in finish :)

[@Bisqwit]

Different people speak differently. Here probably the important difference is that Lauri was not reading a script, but pausing to think and to choose his words, etc. I was mostly speaking kirjakieli, literal language, while Lauri mostly speaks Tampere dialect (which is just common Southern Finnish, with slight pronounciation differences).

[@Veso266]

@@Bisqwit you saw my comment Wow, I thought I was censored again :) I do wonder how to bypass this comment scanning, maybe encode my letters with different character set or something

[@Bisqwit]

@@Veso266 Actually those methods are easily detectable by an algorithm and reek of spam&scam. The only thing they fool is humans.

[@Rahul-ys3yh]

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

[@Bisqwit]

Didn’t I already make a video series on parallelism?

[@crenio5]

Do you have gallstone problems?

[@Bisqwit]

Not that I know. Why?

[@kelo.0]

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.

[@Bisqwit]

@@kelo.0 Only on some Windows versions or installations. Doesn't do so on mine.

[@weegeeweeg]

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

[@m4rt_]

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.

[@Bisqwit]

This video, though, has subtitles.

[@SuperNolane]

Kiitos videosta!

[@acos21]

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

[@Bisqwit]

I know, and I am sorry. This video was not really meant for this channel’s primary audience either, as it was written for some particular course, but I thought, can’t do harm to publish it either. I have previously published similar videos on my Extra channel instead (kzbin.infovideos). However, those videos were more closely tied with the course’s tasks, while this was a bit more general.

[@felixgertrude9311]

SQLite is the GOAT

[@GiygasForPresident]

Can you do one for Debian/Ubuntu?

[@Bisqwit]

The desktop environments for Linux are so numerous that I don't think I can even give a general instruction how to launch a terminal window. I mean, I could hit alt-F2 and type xterm, but does that shortkey even work on anything other than Cinnamon? Many systems don't have xterm installed, they've got some other terminal. Debian has /usr/bin/x-terminal-emulator, but do other Linux distributions have the same? Does Ubuntu? Does Kubbli? I don't know.

[@GiygasForPresident]

@@Bisqwit Yeah, 99% of the time, I don't even use a desktop environment, I do everything by CLI to save resources on the machine.

[@jlmg3543]

Paren todo, Bisqwit subio video!!

[@woj95]

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

[@Logicatube]

Bisqwit is genius

[@0xdeadbeef131]

Goat uploaded

[@lrobertiii]

Did not expect this

[@ivandelgadov.6806]

Saludos desde república dominicana.

[@Bisqwit]

Hello!

[@kenoxys]

Installation and usage of SQLite in Linux

[@chetana9802]

Would be nice to add English Audio

[@Bisqwit]

KZbin videos can only have one audio track (or at least, I don’t have means to add another track without replacing the current one, and even then KZbin only provides means to replace it with some stock music).

[@leocarvalho8051]

Why english title if video not in english?

[@Bisqwit]

Title, description, and subtitles are all provided in both Finnish and English. Audio, however can only be one language.

[@DiggOlive]

Titles are automatically presented by KZbin based on your device's region settings.

[@leocarvalho8051]

@@DiggOlive oh ok. Any way to disable it as a user? I used to skip every indian channel because most were in hindi

​@@Bisqwit Actually, KZbin now allows for different audio tracks that viewers can select in the player. (I'm not suggesting that you have to do that extra work, I'm just pointing out the possibility.)

[@Arti9m]

I do not believe multiple audio tracks are available to everyone. Is this functionality even out of testing phase?

[@woahhhhhh9571]

precompiled binaries for windows 🗣🗣🗣

[@Bisqwit]

Okay okay😒. I added in the video description now: SUBTITLES/CAPTIONS ARE AVAILABLE. ENABLE THEM IF YOU NEED THEM. Looks like I have to explicitly say that, or otherwise people don’t realize that subtitles are a thing that exists.🙄

[@gnu-lynx2501]

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

[@Amberlynn_Reid]

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

[@DiggOlive]

(Translator's note: pista means dot)

[@Bisqwit]

Piste

[@v3ldin]

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

[@Bisqwit]

@@v3ldin Subtitles - did you forget to enable?

[@LasRozasDeMadrid]

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

[@kallebanan1924]

Wait so are you a teacher now?

[@Bisqwit]

I have helped with the teaching and designing material for certain CS courses for two years already, as a side job.

[@kallebanan1924]

@@Bisqwit Ah, I see, I think I heard a few years ago that you had started going to university to become a teacher. I was surprised to see this video, because it made me think that thought were done! "That went fast", I thought.

[@Bisqwit]

Well, I did actually graduate already. But this video is unrelated to that.

[@kallebanan1924]

@@Bisqwit Wow, isn't it supposed to be like 5 years? Well done either way!

[@Bisqwit]

@kallebanan1924 Yes, I did in 3 years what should nominally take 5 years and then some. Thank you.

[@GameBacardi]

He Hei!

[@Bisqwit]

Hei hei

[@slipcurve1410]

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

[@yurikhramov656]

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

[@Bisqwit]

Many of the students use Windows, and explaining the concept of current working directory takes way too much of my energy. A video tutorial works better.