topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday March 19, 2024, 4:45 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: SQLite and AutoIt  (Read 14704 times)

kfitting

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 593
    • View Profile
    • Donate to Member
SQLite and AutoIt
« on: November 13, 2005, 02:08 PM »
In my neverending battle to find a program to store data, I decided to learn about databases.  Last week I found a person on the AutoIt forums who showed how to use AutoIt as a frontend for SQLite.  So this past week I sat down and got a cobbled together script that accesses SQLite.  I don't know if anyone else will find this useful, but here it is.  Some Instructions (it would help if you already know a little about databases or at least want to learn):

- download the file and extract all files to a directory
- Register the sqlite3.dll (this is actually the LiteX com wrapper for SQLite http://republika.pl/roed/litex/) by double clicking on the reg_litex.bat)
- Double click on Database.exe... the program should open.

- Click the open/create database button and open sqlite.db in the extracted folder... the database should load and show items in the tree.  Click on the items (tables) and you should see their contents pop up into the listview.  Click the plus sign to expand the tree items and you can see all columns within a table.
- Feel free to play around.  I have the GUI mostly laid out, but not all functions are working yet.  Functions that do not work have their buttons grayed out. 

Basically, this program does three things as evidenced by the three tabs.  The tab that pops up first (Raw View) is meant to help visualize the database structure and allow you to easily create and manipulate a database.  I coded this so I could easily generate test databases while learning and to learn SQL.  The third tab (also operational) allows you to enter in raw SQL and see the results.  If you do a command that changes the database you will have to go back to the raw view, refresh the database and look to see if the table was modified.  The first tab will pull everything together.  I hope to be able to make a database GUI something like what mouser has in CHS only able to be customized.  Plugins will allow you to make different kinds of databases with different queries etc.  I still don't know enough to get this part working... so I finish the other sections!  But it's coming. 

After CHS gets it's updates, it may do a lot of what this can do.  But I got a lot of experience and now know SQL very slightly!  Enjoy.  Feel free to post comments or bugs.  The exe worked for me but it may crash for others.  Also, there are sure to be bugs within the code.

Here is the AutoIt discussion... its a tad long, but I'm blink314.  http://www.autoitscr...mp;gopid=123937&

Kevin

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SQLite and AutoIt
« Reply #1 on: November 13, 2005, 05:19 PM »
nice!!

kfitting

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 593
    • View Profile
    • Donate to Member
Re: SQLite and AutoIt
« Reply #2 on: November 13, 2005, 06:34 PM »
Would it be easy to allow CHS to access SQLite files mouser?  I have no idea what would be involved but it would be pretty cool!  (and make my current work not go entirely to waste ;)  )

Kevin

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,896
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: SQLite and AutoIt
« Reply #3 on: November 13, 2005, 06:52 PM »
i've considered using sqllite in chs.. maybe this will help push me in that direction..

kfitting

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 593
    • View Profile
    • Donate to Member
Re: SQLite and AutoIt
« Reply #4 on: November 13, 2005, 07:12 PM »
SQLite does have some limitations, I do not intend to steer the design for the sake of my script.  If what you are using is better suited by all means use it!  But, if SQLite could be used... that would be awesome.  Or if you could make CHS read both database types that would work too.

Kevin