SQLite Database With Python - #24

แชร์
ฝัง
  • เผยแพร่เมื่อ 20 ธ.ค. 2024

ความคิดเห็น • 44

  • @DP-xz7cc
    @DP-xz7cc 4 ปีที่แล้ว +1

    A fun fact is that actually in a project i worked in, for Mercedes Benz, this corporataion also used SQLite for its corporate sales systems to keep the data locally available for its salesmen. Thus, i think SQLite has a huge impact, even outside of the android world, where it is also used extensively. Btw. i find this "wrap up" video at the end of the tkinter/sqlite lesson really valuable!

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      interesting

    • @DP-xz7cc
      @DP-xz7cc 4 ปีที่แล้ว

      @@Codemycom yes if a salesman requires his data and does not have access to a guest wifi at the customers site or does not have any internet connection at all (since the system was planned i guess a decade ago and the internet was less ubiquitous back then), sqlite was an impresive technology to address such challenges.

  • @manafalbayati821
    @manafalbayati821 4 ปีที่แล้ว +2

    you are the best :) thanks a lot ! I'm following all your classes in python

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      Thanks! And, glad to hear it!

  • @michaelbrunetti8858
    @michaelbrunetti8858 4 ปีที่แล้ว +1

    Thanks! I needed to perform some simple interactions with a table in our db. This helped me get started on that!

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      Happy to help!

  • @SophisticatedCashew
    @SophisticatedCashew 2 ปีที่แล้ว

    I really appreciate your videos. Thanks.

  • @mosesjohn6969
    @mosesjohn6969 3 ปีที่แล้ว

    you are doing a great job here

  • @STONEDSOLDIER88
    @STONEDSOLDIER88 5 ปีที่แล้ว +1

    Love your tutorials, keep it up :)

    • @Codemycom
      @Codemycom  5 ปีที่แล้ว

      Thanks! Will do!

  • @benwilliams-ksp2
    @benwilliams-ksp2 ปีที่แล้ว

    when I try to put in c.execute("""CREATE TABLE customer() """), it just thinks it is a string, apart from that, the script is identical up to that point. Why would that be?

    • @Codemycom
      @Codemycom  ปีที่แล้ว

      Are you not doing multiline?

  • @noname4011
    @noname4011 3 ปีที่แล้ว +1

    I like so much your videooss 💖. But I have a question of how can I insert a full text in database (sqlite) ?

    • @Codemycom
      @Codemycom  3 ปีที่แล้ว +1

      What do you mean full text? We're inserting text...

  • @immortalsun
    @immortalsun 4 ปีที่แล้ว +1

    I like how you’re using unregistered Sublime Text.

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว +1

      Just living the dream..

  • @aesharao4311
    @aesharao4311 ปีที่แล้ว

    I am trying to create boxplot for SQLite database. Can you help me with that please?

    • @Codemycom
      @Codemycom  ปีที่แล้ว

      I have a pandas playlist with videos on boxplots

  • @LandNfan
    @LandNfan 2 ปีที่แล้ว

    Can the elementary data items be referenced by name, e.g. customer.first_name? That would make it self-documenting and eliminate the need for many comments. Sorry if that’s a dumb question. Chalk it up to my first programming language being COBOL 47 years ago.

  • @jonibek3320
    @jonibek3320 5 ปีที่แล้ว +2

    Hello, when do we have next course

    • @Codemycom
      @Codemycom  5 ปีที่แล้ว

      Do you mean the next video in this series?

  • @SandeshKarumuri
    @SandeshKarumuri 4 ปีที่แล้ว

    I have data in database as codemy
    What to do to print on to the browser as a heading formatted Codemy??

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      Sorry, not sure what you mean

    • @SandeshKarumuri
      @SandeshKarumuri 4 ปีที่แล้ว

      @@Codemycom I have some html data in database, I want to print it out on the web browser as rendered html, how to do it?

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      @@SandeshKarumuri you need a web framework like django or flask to do that

  • @larrycash5250
    @larrycash5250 2 ปีที่แล้ว

    I'm trying to find a way to import CSV to SQLite 3 without using a library's

    • @Codemycom
      @Codemycom  2 ปีที่แล้ว +1

      Google: import CSV to SQLite 3
      You'll get many tutorials

  • @lisalpeiris2589
    @lisalpeiris2589 5 ปีที่แล้ว

    hello, can you insert form data from HTML?

    • @Codemycom
      @Codemycom  5 ปีที่แล้ว

      It depends on how you expect to get that form data to your database...are you using a web framework like node, rubyonrails, django, etc?

    • @lisalpeiris2589
      @lisalpeiris2589 5 ปีที่แล้ว

      @@Codemycom yes I'm using FLASK thanks for the reply

    • @Codemycom
      @Codemycom  5 ปีที่แล้ว

      @@lisalpeiris2589 then you need to learn how Flask handles databases...sorry it's way beyond the scope of this video series...

  • @s-rich
    @s-rich 4 ปีที่แล้ว

    is there a way to import images into an SQLite database and then randomly select them in python?

  • @Bleu-en2bf
    @Bleu-en2bf 4 ปีที่แล้ว

    Thank you😊

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      You're welcome 😊

  • @parsabahrambeik4381
    @parsabahrambeik4381 4 ปีที่แล้ว

    Hi, Thanks for your videos. Please show me just one video in your video list that has a clear connection to MySQL or SQL Server database. This is almost my only problem with Python. .

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว +1

      What do you mean? I show that

    • @parsabahrambeik4381
      @parsabahrambeik4381 4 ปีที่แล้ว

      @@Codemycom Thank you wise man for showing, I saw it too. It was very different from what I expected. It was very clear, yes I saw it and thank you.
      root.mainloop()

  • @yousifahmed257
    @yousifahmed257 4 ปีที่แล้ว

    Thank you

    • @Codemycom
      @Codemycom  4 ปีที่แล้ว

      You're welcome!

  • @theNewMaker
    @theNewMaker 5 ปีที่แล้ว

    Hi
    Am just a follower from Sudan you can search in Google about it so you can know how hard to reach your courses I wish I have dollars to pay you really worth it it's so fanny even if I have I can't buy it because we can use any kind of master card or visa card est...
    Between focus in understanding English and understanding python now I have to find another way to get sgl3
    I wish you luck and keep it up