Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. SQLLite manager?

SQLLite manager?

Scheduled Pinned Locked Moved The Lounge
databasesql-serversysadminquestion
10 Posts 9 Posters 0 Views 1 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.
  • R Offline
    R Offline
    realJSOP
    wrote on last edited by
    #1

    Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
    -----
    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
    -----
    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

    B Mike HankeyM OriginalGriffO R M 7 Replies Last reply
    0
    • R realJSOP

      Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
      -----
      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
      -----
      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

      B Offline
      B Offline
      Brisingr Aerowing
      wrote on last edited by
      #2

      sqliteman: sqlite3 admin and devel tool download | SourceForge.net[^]

      What do you get when you cross a joke with a rhetorical question? The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism. Do questions with multiple question marks annoy you???

      1 Reply Last reply
      0
      • R realJSOP

        Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
        -----
        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
        -----
        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

        Mike HankeyM Offline
        Mike HankeyM Offline
        Mike Hankey
        wrote on last edited by
        #3

        I've used SQLiteExpert[^] for the last few years, it's free and an awesome tool.

        Someone's therapist knows all about you!

        1 Reply Last reply
        0
        • R realJSOP

          Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
          -----
          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
          -----
          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

          OriginalGriffO Offline
          OriginalGriffO Offline
          OriginalGriff
          wrote on last edited by
          #4

          I believe you can use SSMS itself: Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?[^]

          Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

          "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
          "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt

          D 1 Reply Last reply
          0
          • R realJSOP

            Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

            ".45 ACP - because shooting twice is just silly" - JSOP, 2010
            -----
            You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
            -----
            When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

            R Offline
            R Offline
            RossMW
            wrote on last edited by
            #5

            I use SQLitePro [^] which does the job for me. Bur, Im always looking for something better so would be interested to hear which you find best.

            1 Reply Last reply
            0
            • R realJSOP

              Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

              ".45 ACP - because shooting twice is just silly" - JSOP, 2010
              -----
              You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
              -----
              When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

              M Offline
              M Offline
              macika123
              wrote on last edited by
              #6

              I usually use SQLite Manager FireFox addon. So far I have encountered problem, when I wanted to import multiple 100 MB big CSV files, then I had to use command line :) .

              R 1 Reply Last reply
              0
              • OriginalGriffO OriginalGriff

                I believe you can use SSMS itself: Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?[^]

                Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!

                D Offline
                D Offline
                Daniel Pfeffer
                wrote on last edited by
                #7

                Thanks. This is very useful.

                If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack. --Winston Churchill

                1 Reply Last reply
                0
                • R realJSOP

                  Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

                  ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                  -----
                  You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                  -----
                  When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #8

                  Did you try SQLite Toolbox? I didn't (yet) have use for it, but heard many good things about it. Might not be exactly what you are looking for though. (assuming you own/use VS)

                  1 Reply Last reply
                  0
                  • R realJSOP

                    Does anyone know of a (free) SQLLite tool along the lines of SQL Server Management Studio?

                    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                    -----
                    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                    -----
                    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                    B Offline
                    B Offline
                    Bassam Abdul Baki
                    wrote on last edited by
                    #9

                    [SQLiteSpy](https://www.yunqa.de/delphi/products/sqlitespy/index).

                    Web - BM - RSS - Math - LinkedIn

                    1 Reply Last reply
                    0
                    • M macika123

                      I usually use SQLite Manager FireFox addon. So far I have encountered problem, when I wanted to import multiple 100 MB big CSV files, then I had to use command line :) .

                      R Offline
                      R Offline
                      realJSOP
                      wrote on last edited by
                      #10

                      I installed this and it at least lets me browse the tables. The database in question (MediaPortal 2) doesn't use standard sqlite file name extensions, so that threw me a little.

                      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                      -----
                      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                      -----
                      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                      1 Reply Last reply
                      0
                      Reply
                      • Reply as topic
                      Log in to reply
                      • Oldest to Newest
                      • Newest to Oldest
                      • Most Votes


                      • Login

                      • Don't have an account? Register

                      • Login or register to search.
                      • First post
                        Last post
                      0
                      • Categories
                      • Recent
                      • Tags
                      • Popular
                      • World
                      • Users
                      • Groups