You may want to note that in order to update the *.db file that is generated that a connection.commit() statement would be required or the data will not persist once the script exit.
@RocketFriday
3 жыл бұрын
Thank you! Exactly what I was looking for!
@MauricioSalazare
8 ай бұрын
That is the most helpful comment! Thanks!
@arthurmiller5276
3 жыл бұрын
The tutorials are great! But please leave more than a tenth of a millisecond after typing a line of code to switch away from the screen or jump to a different section of code so it's easy to follow along.
@Halahamante
4 жыл бұрын
the ad ends at 4:00
@Speed-tk4yk
3 жыл бұрын
haha you're so funny man
@magicmedia7950
2 жыл бұрын
Great tutorial but too fast
@erictrautmiller1154
4 жыл бұрын
I've been using Python for over a year and I never realized it had a built in database. Thanks for posting this!
@it_is_ni
3 жыл бұрын
To be precise: it’s not built in. Python has code in its standard library to interact with SQLite databases and since they’re just files that works.
@VASSER574
3 жыл бұрын
two years later after learning this and I still don't get how this works exactly
@immeyouareu2633
9 ай бұрын
I’m going to use this. I went through hell programming a database in Java on a cloud server. Java is for punks. C# is a way better alternative if you share my opinion.
@KiteHQ
4 жыл бұрын
Let us know what other topics we should cover! Thanks for watching [:
@davidbarrow
4 жыл бұрын
django + vue.js full stack apps would be good to see ;-)
@RahulMishra-np7fw
4 жыл бұрын
Django, kivy, machine learning
@martiangnome573
4 жыл бұрын
Can you teach Java in 1 sec?
@basavarajpatil9821
4 жыл бұрын
flask tutorials
@DJxSGGxNeo
4 жыл бұрын
Library dictionary tips? For C#? Things that could help boost workflow would be awesome.
@ryano699
9 ай бұрын
this just isnt working for me and I don't know why, when I click on the database on vs it just says the file is wrong and I get loads of red text saying null
@GaugingGadgets
2 жыл бұрын
This was amazingly helpful! Thank you so much. Is Kite still available?
@bxrbloxx2952
Жыл бұрын
why do i get this error sqlite3.OperationalError: near "EXIST": syntax error
@KiteHQ
4 жыл бұрын
Like this tutorial? Join the Kite Developer Community on Facebook for access to more resources + support from fellow Python developers. Time to level up! facebook.com/groups/505658083720291
@pranavgunjal8543
Ай бұрын
Sita Ram 🙇♂️✨
@rbfreitas
3 жыл бұрын
Great video. Btw, where is the database file located?
@evolade4044
3 жыл бұрын
same with the python file
@sakinetipallivenkatesh5309
4 жыл бұрын
Hello Kite, when i execute through cmd getting error like :: sqlite3.operational error: Database is locked how can i resolve that. ??? ERROR:: C:\Users\home1\Documents>py data1.py Traceback (most recent call last): File "data1.py", line 18, in cursor.execute("INSERT INTO stores values (11, 'sanath nagar, SN')") sqlite3.OperationalError: database is locked
@rayharper3268
Жыл бұрын
i'm having error which is database is locked how to remove this error
@kesukesu8453
3 жыл бұрын
Thia is problem of my python script please help meAttributeError: partially initialized module 'sqlite3' has no attribute 'connect' (most likely due to a circular import)
@satyamanisrivastava7818
4 жыл бұрын
Can you make a video on kivy ( python library)
@KiteHQ
4 жыл бұрын
we'll take a look [:
@satyamanisrivastava7818
4 жыл бұрын
Ok
@ihebbibani7122
3 жыл бұрын
smart idea to do advertisment in the middle of the video to get our attention however this is not very welcomed for a viewer....The tradeoff is up to you now ; Is it more interesting to earn money from viewers or from your product ?
@Altair19979752S
3 жыл бұрын
Well done video, but code would be nice
@Neilcourtwalker
3 жыл бұрын
Thanks a lot for the video. When will you make more videos on sqlite?
@Jason-de3oo
4 жыл бұрын
whenever i comment one of the insert statement it leaves my database how do i make the info i put into my database not remove?
@maxxxiejazz
2 жыл бұрын
Thank you. At the end you've said you will do more db tutorials for Python. Is there something I'm missing? Cause I've been searching for that next video and I could'nt find it. This one dates 18 months ago.
@RahilPoladiya_B
3 жыл бұрын
Why do some people tripple qoute create command , some double qoute it and some single qoute it? Whats the difference between that
@SH-th4wy
6 ай бұрын
How do you know what your working directory is? Also, how do you save this?
@leonardkabasa1902
3 жыл бұрын
Halo are you available to help someone struggling with tkinter n sqlite
@VarghesePhilipKavungal
3 жыл бұрын
Tried to download kite. "Kite is currently unavailable."
@prajwalshetty646
Жыл бұрын
thankyou for this tutorial, was about to start a project and this solved my doubts
@joehilinski7008
4 жыл бұрын
Do you have the source code available?
@Leo-qf3ui
3 жыл бұрын
How to remove column header of output in SQLITE 3.28 ?
@twessels1234
3 жыл бұрын
how do you select the data in a table from the last 24 hours?
@danrosemon9084
2 жыл бұрын
You would need to have created a column that specifies the time and date. Then, you would need to insert the current time upon creation of the row. Then your select statement will be asking when time:date between x and y.
@sottiesteve4559
2 жыл бұрын
Great job there! How to I connect already stored data(in the server) into a database (with all the field intact)? Thanks
@lavienguyen8768
2 жыл бұрын
Thank you very much for this overview of SQLite3 and demonstration of Kite.
@nicholasyoa86
3 жыл бұрын
Thanks a bunch, this helps SOOO much! Really happy that I’ve found such an easy way to write to databases, so easy and nice. Thanks for the recommendation of the tool Kite also, as ...let’s just say I’m one of those programmers who die that while programming, sometimes while typing don’t auto fill themselves/have an option to. Kite makes it easier which is great. I’ll try it out when I can! From the looks of things it looks amazing.
@dwaynefong
Жыл бұрын
thank you simple concise and easy to follow
@vitalijsawizki6816
3 жыл бұрын
thx is very helpfull for a beginner
@SidiMohamed-x4y
Ай бұрын
Great
@ihssancanmturk3842
4 жыл бұрын
Wonderful this super wonderful that video tutorial me think, thanks for presenting and sharing! ;)
@erin3670
2 жыл бұрын
Great video, thanks.
@navneetyadav8869
3 жыл бұрын
really like your voice n information , keep the good work sire :)
@DARKULTRAMADNESS
6 ай бұрын
I love this guy
@ahmedw5
Жыл бұрын
Fantastic tutorial, thank you.
@madhuriausula4125
2 жыл бұрын
HELLO SIR,
@Agung-yk7hr
2 жыл бұрын
thanks man
@augurelite
2 жыл бұрын
THANKS
@vietdinh-van8018
4 жыл бұрын
I know this. This is the first experiment
@mehdizahmatkesh1470
3 жыл бұрын
goooood
@diusia
3 жыл бұрын
Thanks a lot! Straight to the point and clear, perfect.
Пікірлер: 62