Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. How to learn SQLite with Qt?
Forum Updated to NodeBB v4.3 + New Features

How to learn SQLite with Qt?

Scheduled Pinned Locked Moved Solved General and Desktop
databasesqlite
7 Posts 4 Posters 2.1k Views 3 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Offline
    C Offline
    cxam
    wrote on 28 Mar 2016, 18:51 last edited by aha_1980 2 Mar 2019, 10:17
    #1

    Hi! I never learnt how to program with Databases but now I'm facing a problem in which I need to use database (Sqlite) but I don't have any idea of how should I use it so does anyone know any way in which I can learn how to use SQLITE databse with Qt ? Thanks in advance.

    Stay Hungry, Stay Foolish

    1 Reply Last reply
    0
    • ? Offline
      ? Offline
      A Former User
      wrote on 28 Mar 2016, 19:22 last edited by
      #2

      Hi! The wiki has one nice short example for that: https://wiki.qt.io/How_to_Store_and_Retrieve_Image_on_SQLite

      C 1 Reply Last reply 28 Mar 2016, 20:20
      3
      • ? A Former User
        28 Mar 2016, 19:22

        Hi! The wiki has one nice short example for that: https://wiki.qt.io/How_to_Store_and_Retrieve_Image_on_SQLite

        C Offline
        C Offline
        cxam
        wrote on 28 Mar 2016, 20:20 last edited by
        #3

        @Wieland Ok, I think it's a good guide to start but I think I need something more extense.. I don't know if I'm explaining myself haha.

        Stay Hungry, Stay Foolish

        ? M 2 Replies Last reply 28 Mar 2016, 20:37
        0
        • C cxam
          28 Mar 2016, 20:20

          @Wieland Ok, I think it's a good guide to start but I think I need something more extense.. I don't know if I'm explaining myself haha.

          ? Offline
          ? Offline
          A Former User
          wrote on 28 Mar 2016, 20:37 last edited by
          #4

          @cxam You can use sqlite just like any other SQL database. The Qt SQL module provides everything you'll need. Do you only need a guide to Qt SQL's API or do you also need an introduction to SQL itself?

          C 1 Reply Last reply 28 Mar 2016, 20:41
          0
          • C cxam
            28 Mar 2016, 20:20

            @Wieland Ok, I think it's a good guide to start but I think I need something more extense.. I don't know if I'm explaining myself haha.

            M Offline
            M Offline
            mrjj
            Lifetime Qt Champion
            wrote on 28 Mar 2016, 20:40 last edited by
            #5

            @cxam
            The key is SQL
            http://www.w3schools.com/sql/default.asp
            since you will be using it to create/modify and fetch the data.

            So IMHO, first thing to understand to some extend is SQL as it will make all things
            more clear when using QSqlQuery.

            also
            I highly recommend using
            http://sqlitebrowser.org/
            You can create/modify and test SQL directly with it.

            1 Reply Last reply
            1
            • ? A Former User
              28 Mar 2016, 20:37

              @cxam You can use sqlite just like any other SQL database. The Qt SQL module provides everything you'll need. Do you only need a guide to Qt SQL's API or do you also need an introduction to SQL itself?

              C Offline
              C Offline
              cxam
              wrote on 28 Mar 2016, 20:41 last edited by
              #6

              @Wieland @mrjj thank you both for helping me :)

              Stay Hungry, Stay Foolish

              1 Reply Last reply
              0
              • A Offline
                A Offline
                adityakin
                wrote on 3 Feb 2019, 07:59 last edited by
                #7

                A key is a single or combination of multiple fields in a table. Its is used to fetch or retrieve records/data-rows from data table according to the condition/requirement. Keys are also used to create relationship among different database tables or views.
                [https://www.welookups.com/sql/default.html

                ](https://www.welookups.com/sql/default.html

                )

                1 Reply Last reply
                0

                • Login

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • Users
                • Groups
                • Search
                • Get Qt Extensions
                • Unsolved