Ulysses

General => Developers Corner => Topic started by: MrPresident on January 20, 2010, 02:55:39 AM

Title: Need a good program to explore the sqlite db that comes with Gmod
Post by: MrPresident on January 20, 2010, 02:55:39 AM

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?

Title: Re: Need a good program to explore the sqlite db that comes with Gmod
Post by: JamminR 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.

Title: Re: Need a good program to explore the sqlite db that comes with Gmod
Post by: MrPresident 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...

Title: Re: Need a good program to explore the sqlite db that comes with Gmod
Post by: ACProdigy 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/

Title: Re: Need a good program to explore the sqlite db that comes with Gmod
Post by: Megiddo on January 21, 2010, 03:37:48 PM

I have yet to find a browser that I'm happy with... :P

Title: Re: Need a good program to explore the sqlite db that comes with Gmod
Post by: Ploo 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?)