Author Topic: Need a good program to explore the sqlite db that comes with Gmod  (Read 4500 times)

0 Members and 1 Guest are viewing this topic.

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
I'm planning to rewrite my Warning module for ULX and I want to do what people had suggested by making it cross-session. I'd like to use sqlite that GMod comes with and I know HOW to use it.. but Id also like to be able to explore the database to make sure things are structuring corectly without writing some kind of script that just prints it in my console. Any ideas?

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Need a good program to explore the sqlite db that comes with Gmod
« Reply #1 on: January 20, 2010, 03:28:58 PM »
I've personally never searched for such a tool myself.
There are several freeware, GPL, trialware and commercial ones listed at the sqlite.org wiki - http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
I've also seen a Firefox plugin that lets you browse them.

I know your bandwidth and sometimes time limited...what features are you looking for.. perhaps I can explore/test/learn some myself.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline MrPresident

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 2728
  • Karma: 430
    • |G4P| Gman4President
Re: Need a good program to explore the sqlite db that comes with Gmod
« Reply #2 on: January 21, 2010, 10:34:46 AM »
Thanks Jam,
Im looking for something preferably under 10MB that will allow me to browse the tables and maybe edit them.. mainly just browse them. Kind of how phpmyadmin lets you browse MySQL databases.. it doesnt have to be browser based or it could be...

Offline ACProdigy

  • Newbie
  • *
  • Posts: 21
  • Karma: 10
  • Beriddled with nonsense
Re: Need a good program to explore the sqlite db that comes with Gmod
« Reply #3 on: January 21, 2010, 11:35:56 AM »
There is a project over at SourceForge that lets you do just that- SQLite Database Browser. (7.3MB)

It will allow you to view/edit/etc. SQLite database files.

http://sourceforge.net/projects/sqlitebrowser/

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6214
  • Karma: 394
  • Project Lead
Re: Need a good program to explore the sqlite db that comes with Gmod
« Reply #4 on: January 21, 2010, 03:37:48 PM »
I have yet to find a browser that I'm happy with... :P
Experiencing God's grace one day at a time.

Offline Ploo

  • Newbie
  • *
  • Posts: 16
  • Karma: 0
Re: Need a good program to explore the sqlite db that comes with Gmod
« Reply #5 on: February 24, 2010, 03:15:12 PM »
https://addons.mozilla.org/en-US/firefox/addon/5817

It's what I use. It even has support for remote databases (Does it?)