Python 2.7 Tutorial Pt 12 SQLite

[ad_1]
Best Python Book :

Best SQLite Book :

In this Python Video Tutorial, I will show you how to create databases using the Python SQLite module. SQLite is great because it:

* Provides most of the basic database structure you want
* Doesn’t require you to have an actual database server running
* Provides SQL querying capabilities
* Is included with Python by default

Code is Here


Posted

in

by

Tags:

Comments

48 responses to “Python 2.7 Tutorial Pt 12 SQLite”

  1. Emile Ogier Avatar

    Derek your videos are exceptionally good! The content and pace is so refreshing, I absolutely love your work. Your educational videos stand tall amongst the rest. Keep up the invaluable work and thank you so much for sharing your knowledge with the community.

  2. Avery Zamzow Avatar

    Using python 3.0, how would you display on the screen all the items who's balance is less than 100?
    also how would you display the values of only street, city, and balance and display on screen?

  3. sid HD Avatar

    6 years later and its still a massive help thanks!!!

  4. Peter Buechler Avatar

    Rather than create in memory, why not add a
    DROP TABLE IF EXISTS tablename as the first line of your execute?

  5. Chris Kavanagh Avatar

    How about a SQLAlchemy tutorial, Derek?

  6. Horia Sar Avatar

    You're great teacher. I think I would learn Python with your tutorials. Many thanks. Horia

  7. Jeffrich308 Avatar

    Great Video!Β  You are a Great Teacher!Β  My programming skills (although novice) have improved dramatically since I found your videos.Β  Thanks!

  8. mykeuser Avatar

    Thanks for this great tutorial!

    The only thing I don't know why (?) is used as placeholder? Why don't %d, %s,etc or {0}, {1}…?Β 

  9. vitere Avatar

    Is there any way to pass the DB content to a graphic table ?

  10. Lord ASS Avatar

    thanks bro i totally appreciate it derek i will like it and subed

  11. John von Horn Avatar

    Loved it, tnx Derek. We're rocking along under your excellent tutelage.

  12. Derek Banas Avatar

    Thank you very much πŸ™‚

  13. Leyi Zhang Avatar

    VERY VERY GOOD TUTORIAL

  14. Derek Banas Avatar

    Thank you πŸ™‚

  15. Derek Banas Avatar

    Greetings Brazil πŸ™‚ You're very welcome

  16. Antonio Souza Avatar

    Very good and thank's you (I'm from Brazil).

  17. Derek Banas Avatar

    Thank you for the tip πŸ™‚ Sorry i made that mistake

  18. Charles Pilgrim Avatar

    hi Derek great video, I spotted a mistake which confused me slightly and thought you'd like to know. On the DELETE bit of code you have commented above saying it deletes the customer's email address, does it not delete the entire customer?

  19. Derek Banas Avatar

    Thank you very much πŸ™‚ I constantly try to get better

  20. Ranjid FilletHacker Avatar

    Very nice video and nice eplaining. Learn how to program is fun like that

  21. Abhishek Mitra Avatar

    How do i extract data from 'customers' table from a different python instance, once i've already put some data into the DB.

  22. Derek Banas Avatar

    Thank you very much πŸ™‚

  23. Thomas Stovall Avatar

    Excellent video! Very clear, informative and professional.

  24. vishwas reddy Avatar

    IDLE's subprocess didn't make connection. Either IDLE can't start a subprocess or personal firewall software is blocking the connection. ……………………….i am getting this error when i use python to print the sqlite select query…i want sqlite3 output should be seen in python idle…pls help……:(

  25. Derek Banas Avatar

    You're very welcome πŸ™‚

  26. Derek Banas Avatar

    You're very welcome πŸ™‚

  27. Acharoen Avatar

    Im a beginner. Thank you very much for the video! Thats very clear and helps me a lot on start working on sqlite3 python.

  28. Derek Banas Avatar

    You're very welcome πŸ™‚

  29. Jake Harris Avatar

    The official pronunciation is S-Q-L, not "sequel."

    PS thanks for the videos!

  30. Derek Banas Avatar

    Thank you πŸ™‚ I pronounce things differently because I'm book taught and never heard how things were supposed to be pronounced. After I have said things thousands of times in my head it is hard to change.

  31. Derek Banas Avatar

    I'm sorry, but I made this 3 years ago. I wasn't very good at making tutorials back then

  32. John Sargunar Avatar

    Derek, this is great, wonderful in fact, an order of magnitude than other tutorials. If you could teach/show an application for example, show how to mark attendance for a small company and explain Python/Eclipse as you design the application using files (rather than complicate with SQLite3) many many more can benefit.

  33. Derek Banas Avatar

    What are you trying to do?

  34. Steve Daniels Avatar

    Actually, I think I got it. The IF NOT EXISTS statement?

  35. Steve Daniels Avatar

    My only question is this: If you're making an application to be reusable, how would you run this program multiple times without creating a new table every time? In other words, how do you check to see if your table has already been created and if so, to access it?

  36. Derek Banas Avatar

    You are very welcome πŸ™‚ I'm happy that you found it useful

  37. Tim Trial Avatar

    This is brilliant. I'm going to use SQLite to take data off a client/server database and allow me to add new records when I'm not connected to the internet. Thanks Mr Banas

  38. Derek Banas Avatar

    Thank you πŸ™‚ I'm glad you liked it

  39. Shurrupak Avatar

    Thanks! Saved me a lot of time!

  40. Aarmaxian Avatar

    thank you very much for a great tutorial. Keep it up.

  41. ikillerloop Avatar

    Hey man, great tutorial! Thanks for taking the time to create it and help others.

  42. Chris Kavanagh Avatar

    Very nice as always Derek. . .I think I need to look at your SQL Tutorial. . .BTW, have you done a Django Tut?? I didn't see one on your channel??

  43. Jah Fizz Avatar

    Can you please make more tutorials for sqlite or sql and python programming.

  44. Derek Banas Avatar

    @rahul25iit I use Eclipse. It's free and works on every operating system. Thank you

  45. Rahul Biswas Avatar

    Nice tutorial. Can you please tell me what Python editor you are using? I usually use terminal. But the one you are using looks fabulous. Thanks

  46. Derek Banas Avatar

    @Nightengale305 no it doesn't have to be a multiline string. I'm sorry if I didn't explain that.

Leave a Reply

Your email address will not be published. Required fields are marked *