SQLite Tutorial For Beginners - Make A Database In No Time

[@escocoward]

Great tutorial, this was just what I needed to get familiar with SQL syntax. Thank you so much, all the way from Nigeria!!!

[@peetuskytta6031]

Great tutorial Avery and I liked that you actually delivered what the video title says. Thanks! This made starting with SQL a lot easier :)

[@omnihorse7618]

Man, Thank you so much for making this video, It was simple and I now understand it so clearly. Hope you keep making videos and merry christmas!

[@jarreed0]

Thanks man! I really appreciate that. Merry Christmas to you too

[@dystopic-q9m]

1k congrats boi

[@jasiu889]

thanks, I was looking only on fat sql servers in docker etc on Mac, this is great tutorial

[@stwaters92]

Congrats on getting over 300 subs

[@jarreed0]

Appreciate it

[@sunilkeshava4727]

Great short video to explain the SQlite database. Thanks for making the video!

[@jarreed0]

Thanks! In hindsight I wish I had made it a little higher quality

[@hassanyahya400]

I enjoyed the video, it's quite easy to start with

[@ptahX]

I've been looking at videos on this for a few hours - first one I found that was actually to the point and well explained so far. Subscribed and liked, did you happen to make a C# or C++ interface for this ? - Thank you once again !

[@jarreed0]

Thanks so much! I haven't yet (been a little busy lately) but I plan on doing that.

[@jackmandingo7037]

Good! Starting to practice now... Thanks bro!

[@szymon5811]

Any tips? 'sqlitebrowser' is not recognized as an internal or external command, operable program or batch file.

[@badreenjaffer561]

Great Video!

[@emilkronholm6246]

Very good! Thx brotha

[@TechNena]

This was very helpful. Thanks for making it super clear

[@hassanyahya400]

Thanks for making this video

[@zandersmith1]

Thanks for making this!

[@ThePasteete]

You have a very nice voice :) subscribed

[@mozpi]

Great video to get started!

[@user-florin]

Thank you! This is a really useful video.

[@stephenwilkinson4535]

hey could you do a video of how to use SQLite and python to setup user authentication

[@ArikCool]

Great Video Favour

[@TheVerbalAxiom]

Very educational, thanks for this!

[@kornelijekovac9793]

sqlite> .open test1.db Error: unknown command or invalid arguments: "open". Enter ".help" for help

[@DavidRodriguez-qq6fh]

Thank you!

[@sebastianstettler4701]

super helpful! Thank you!

[@rutunjparikh2775]

excellent! thanks man!

[@jetsonherrera7538]

Dude 1.44k now? Nice !!

[@jarreed0]

thanks man!

[@KACHEmain]

Great vid!

[@sevenkashtan]

Earned my sub

[@julivanespi]

Great vid

[@Soccercrazyigboman]

Wait, how do you do this on Windows computers?

[@jarreed0]

All the commands should be the same. And can be done from the command prompt I believe

[@robertweekes5783]

Run command .mode box To see nice lines around your entries and headers 📦

[@sergio7470]

Doesn't the database need to be stored on a server? Where is all the data saved?

[@jarreed0]

It doesn't been to be on a server. And you just access the db the way I should in the video or with other APIs (I have a video showing how to access the data with Python).

[@aditibahadur8081]

What about making a large database? Is there a way to automate that?

[@navjotsingh2251]

I guess using python (or some other scripting language) you could write a script that automatically creates tables and does things you need.

[@tontondatu]

Hey Avery, awesome tutorial. Thank you so much for the upload. Quick one, do you a tutorial or code on how to display sqlite data into a HTML file? Even if I have to pay for it.

[@jarreed0]

I don't have any tutorial out on how to do that sadly. But it's not super complicated. You can either look to see how to do it with JavaScript or how to use it with Python (and with that you would have to have have python work in the site as well, I usually use CGI for that).

[@1skeeta4u]

What is the highest level of database infrastructure with SQL lite?

[@cryptonicchronic8111]

asking for 300 subs lol youre almost at 3k right on!

[@jarreed0]

yes sir!

[@jainilvora7167]

Please send me the download link to download sqllite

[@jarreed0]

Should be able to get it at sqlite.org

[@willowens1438]

W tutorial bro

[@akibosnjak8694]

I'm using this to build an Ionic / Cordova app.

[@harshitagoyal7134]

great video

[@asuka8951]

Hi i have question, is it possible to connect sqlite with ionic framework?

[@jarreed0]

I have never done it myself, but I believe so. Here is an example that I found: ionicframework.com/docs/native/sqlite

[@OhlordyOh]

nice

[@iwasgroomed]

300 to 6k is wild tho

[@oleh7711]

thanks ♥

[@aromakc]

there are less tutorials on sqlite and c++. It would be helpful.

[@jarreed0]

Thanks for the idea!

[@aromakc]

@@jarreed0 Hoping soon. Cause I have a project to be done using above 😂. Will appreciate though. 👍

[@galk32]

great tutorial, thank you

[@cbseclasstutions815]

full xampp course in 1 vedeo- kzbin.info/www/bejne/pqSmdmuVma1lndE

[@mostafaghobashy2724]

bro u talking abt 300 subs U R 4.5K

[@technicalradar3408]

Cool Bro!

[@zoeythebee1779]

Sheesh that transparent terminal over firefox makes my eyes hurt

[@jarreed0]

Yeah, that was a mistake on my part for sure

[@grizthegriffdog9939]

time series data entry for OHLCV data. that will update pull with your previous AV tutorial.

[@cbseclasstutions815]

full xampp course in 1 vedeo- kzbin.info/www/bejne/pqSmdmuVma1lndE

[@techtiger2558]

That nasty GTK theme tho :barf:... Otherwise, great vid, thx.

[@ostekake]

Python

[@MrSmygarnnn]

PYTHON!

[@jarreed0]

I have a python tutorial for SQLite on my channel

[@MrSmygarnnn]

@@jarreed0 Thanks! Will check it out : ))

[@hashkeeper]

BRO

[@jarreed0]

BRAH

[@animeboy93]

Do it with c#

[@iamhillwalker_]

Just talk with some active, viewers get sleepy by hearing your voice

[@excursioncouple]

Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open test1.db sqlite> sqlite> CREATE TABLE people (id INTEGER PRIMARY KEY, first_name TEXT, last_name TEXT, age INTEGER, gender TEXT); Parse error: near "sqlite": syntax error sqlite> CREATE TABLE people (id INTEGER PRIMARY KEY, first_name TEXT, last_nam ^--- error here sqlite> sqlite> INSERT INTO people (first_name, last_name, age, gender) VALUES ("avery", "reed", 21, "m"); Parse error: near "sqlite": syntax error sqlite> INSERT INTO people (first_name, last_name, age, gender) VALUES ("avery ^--- error here sqlite> I get this error message after inputting the first INSERT INTO, any reason?

[@frederikchristiansen8121]

garbage doesn't work

[@yuyuyuyuyuy484]

why do you sound like terry davis