Re: [sqlite] Best GUI?
Jim Dodgen wrote: > Binary! ... I only use 0's > > On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio > wrote: > >> Mike Eggleston wrote: >> >>> On Thu, 26 Feb 2009, Nuno Magalh?es might have said: >>> >>> >>> This is a bit of a religious question, but which are the mest/most popular *nix GUIs out there? I'm using a firefox plugin but not entirely happy with it. What do you use and why? >>> I prefer vi and sh. >>> >>> Mike >>> ___ >>> sqlite-users mailing list >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >>> >> Real men code in binary. Like CodeBlocks & good old 'sql' myself. >> >> Michael >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > > > I used to, but, for some reason, I kept fraggin' the XT's hard drive. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Nuno Magalhães wrote: >> Do you want this for data entry, or developing and managing the database >> via SQL. I have yet to see a really good front end for data entry >> although Dabo shows promise as a tool to make good data entry tools. > > Thanks, i'll look into it. I want it as a means to create the inicial > schema and change it if necessary. Setting up constraints, data types, > that sort of thing... For random queries i'd probably use the cli and > for data entry i'll use php. > > Nuno Magalhães > LU#484677 > ___ Oh that's a different ballpark. I actually use Dia to draw my database and then use dia2code to generate sql that can be run. I've seen other variations of the same idea, UML diagram to SQL to code is the basic idea. Of course most of them have no idea about the data types for sqlite so you still end up typing out most of it. Not really sure what you need a GUI for at that stage unless you want it to baby step you with check boxes about your options. If that's what you're looking for the firefox plugin is the closest thing I've seen to that. FYI- did you consider asking the plugin developer to add tools you think are useful? Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
> Do you want this for data entry, or developing and managing the database > via SQL. I have yet to see a really good front end for data entry > although Dabo shows promise as a tool to make good data entry tools. Thanks, i'll look into it. I want it as a means to create the inicial schema and change it if necessary. Setting up constraints, data types, that sort of thing... For random queries i'd probably use the cli and for data entry i'll use php. Nuno Magalhães LU#484677 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Nuno Magalhães wrote: >> Here lots of SQLite management tools >> >> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > > Keyword being "lots". I've been to that site, which was what prompted > me to write in the first place. I'm looking for either web-based or > *nix. I know there are lots, i just want to know which one(s) you > recomend and why. I've been using a firefox plugin called SQLite > Manager but am not happy with it, i'd like more options, something > similar to Oracle's SQLDeveloper (pref without the Java™) or even > Access. > > Btw, vi and sh do not qualify as GUI, i have my own tools for that, thanks. > > Nuno Magalhães > LU#484677 Do you want this for data entry, or developing and managing the database via SQL. I have yet to see a really good front end for data entry although Dabo shows promise as a tool to make good data entry tools. Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Binary! ... I only use 0's On Fri, Feb 27, 2009 at 5:19 AM, Michael Comperchio wrote: > Mike Eggleston wrote: >> On Thu, 26 Feb 2009, Nuno Magalh?es might have said: >> >> >>> This is a bit of a religious question, but which are the mest/most >>> popular *nix GUIs out there? I'm using a firefox plugin but not >>> entirely happy with it. What do you use and why? >>> >> >> I prefer vi and sh. >> >> Mike >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > Real men code in binary. Like CodeBlocks & good old 'sql' myself. > > Michael > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Jim Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Hi, Similar to SQL developer => wxSQLite+ Free: GPL v3 for Linux (compiled provided for mandriva 2009) but sources are provided. Nuno Magalhães a écrit : >> Here lots of SQLite management tools >> >> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools >> > > Keyword being "lots". I've been to that site, which was what prompted > me to write in the first place. I'm looking for either web-based or > *nix. I know there are lots, i just want to know which one(s) you > recomend and why. I've been using a firefox plugin called SQLite > Manager but am not happy with it, i'd like more options, something > similar to Oracle's SQLDeveloper (pref without the Java™) or even > Access. > > Btw, vi and sh do not qualify as GUI, i have my own tools for that, thanks. > > Nuno Magalhães > LU#484677 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
> Here lots of SQLite management tools > > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Keyword being "lots". I've been to that site, which was what prompted me to write in the first place. I'm looking for either web-based or *nix. I know there are lots, i just want to know which one(s) you recomend and why. I've been using a firefox plugin called SQLite Manager but am not happy with it, i'd like more options, something similar to Oracle's SQLDeveloper (pref without the Java™) or even Access. Btw, vi and sh do not qualify as GUI, i have my own tools for that, thanks. Nuno Magalhães LU#484677 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Hi, Here lots of SQLite management tools http://www.sqlite.org/cvstrac/wiki?p=ManagementTools Best regards Fred Nuno Magalhães a écrit : > Greetings, > > This is a bit of a religious question, but which are the mest/most > popular *nix GUIs out there? I'm using a firefox plugin but not > entirely happy with it. What do you use and why? > > TIA, > Nuno Magalhães > LU#484677 > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
On Thu, Feb 26, 2009 at 03:04:05PM -0600, Mike Eggleston scratched on the wall: > On Thu, 26 Feb 2009, Nuno Magalh?es might have said: > > > This is a bit of a religious question, but which are the mest/most > > popular *nix GUIs out there? I'm using a firefox plugin but not > > entirely happy with it. What do you use and why? > > I prefer vi and sh. +1, although I'm a ksh person myself. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Mike Eggleston wrote: > On Thu, 26 Feb 2009, Nuno Magalh?es might have said: > > >> This is a bit of a religious question, but which are the mest/most >> popular *nix GUIs out there? I'm using a firefox plugin but not >> entirely happy with it. What do you use and why? >> > > I prefer vi and sh. > > Mike > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Real men code in binary. Like CodeBlocks & good old 'sql' myself. Michael ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
On Thu, 26 Feb 2009, Nuno Magalh?es might have said: > This is a bit of a religious question, but which are the mest/most > popular *nix GUIs out there? I'm using a firefox plugin but not > entirely happy with it. What do you use and why? I prefer vi and sh. Mike ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
Hello! On Friday 27 February 2009 00:44:05 Alan Cohen wrote: > This is a bit of a religious question, but which are the mest/most > popular *nix GUIs out there? I'm using a firefox plugin but not > entirely happy with it. What do you use and why? I'm prefer tksqlite: http://reddog.s35.xrea.com/wiki/TkSQLite.html And GUI from Spatialite project is useful for GIS developers: http://www.gaia-gis.it/spatialite/ Best regards. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
On Thu, 2009-02-26 at 16:41 -0600, P Kishor wrote: > candid feedback > > http://entropy.homelinux.org/axis/northwind.png nice > http://entropy.homelinux.org/axis/client_services.png ouch! It's actually not so bad once you use it a bit. It's an all-in-one CRM app thingy that does basically everything the consultants have to do at my previous work. The front page that you're looking at, I was told, had to have some basic company details, and a contacts & locations list. So that's what it's got. The other pages aren't so cluttered. We found it was best to have everything integrated like this instead of lots of little single-purpose forms because then all features are available within a single click, and it doesn't take time to load the form up. Also people start to get confused with lots of forms open. And seriously, they need all those pages. It's quite common for a consultant to navigate to a client, then flip through at least half of the pages. Anyway, I don't work there any more, so my replacement is free to do what he likes with it :) Dan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
ahhh... my apologies... your screenshots show examples of applications that can be built with your tool; they are not screenshots of the tool itself. Never mind my critique. I do look forward to your packages even though I am mostly a shell/Perl DBI user and don't really need GUIs. On Thu, Feb 26, 2009 at 4:41 PM, P Kishor wrote: > On Thu, Feb 26, 2009 at 4:30 PM, Daniel Kasak > wrote: >> On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: >> >>> None of these really provide the kind of data entry screens I'd like to >>> have; I have not had time to try OOo Base yet. >> >> Well then. You'll be interested in my projects :) >> >> http://entropy.homelinux.org/axis/ >> ( my home server is unfortunately just a *little* unstable at the >> moment ... hardware looks to be dying ... so apologies if it goes >> down ... it's up at the moment anyway ). There are some screenshots of >> production systems that use the 3 libraries. >> >> I'm currently working on a GUI builder ( unreleased, but I can be >> convinced to dump a very early beta ). I have table browsing and data >> viewing working. Also creating forms ( via glade ) is working. I plan on >> implementing schema editing for SQLite and possibly MySQL. Datasheet >> creating ( via the GUI ) is completely unimplemented. Anyway, email me >> ( this address is probably better at the moment ) if you're interested >> in the GUI builder, otherwise check out the libraries. >> > > > candid feedback > > http://entropy.homelinux.org/axis/northwind.png nice > http://entropy.homelinux.org/axis/client_services.png ouch! > > see, you might want to try and emulate something like > http://www.araelium.com/querious/screenshots/content_75p.png (MySQL tool) or > http://fileability.net/Raw%20Screenshots/Form%20Design.png (built for > and with SQLite) > > not something like > http://www.bulkrenameutility.co.uk/Screenshots.php or > http://www.billproduction.com/BillRed_scrsht.jpg > > In any case, your work looks very promising, and I look forward to > seeing more of it as it would be a nice addition to the mix. > > -- > Puneet Kishor http://www.punkish.org/ > Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ > Carbon Model http://carbonmodel.org/ > Open Source Geospatial Foundation http://www.osgeo.org/ > Sent from: Madison WI United States. > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
On Thu, Feb 26, 2009 at 4:30 PM, Daniel Kasak wrote: > On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: > >> None of these really provide the kind of data entry screens I'd like to >> have; I have not had time to try OOo Base yet. > > Well then. You'll be interested in my projects :) > > http://entropy.homelinux.org/axis/ > ( my home server is unfortunately just a *little* unstable at the > moment ... hardware looks to be dying ... so apologies if it goes > down ... it's up at the moment anyway ). There are some screenshots of > production systems that use the 3 libraries. > > I'm currently working on a GUI builder ( unreleased, but I can be > convinced to dump a very early beta ). I have table browsing and data > viewing working. Also creating forms ( via glade ) is working. I plan on > implementing schema editing for SQLite and possibly MySQL. Datasheet > creating ( via the GUI ) is completely unimplemented. Anyway, email me > ( this address is probably better at the moment ) if you're interested > in the GUI builder, otherwise check out the libraries. > candid feedback http://entropy.homelinux.org/axis/northwind.png nice http://entropy.homelinux.org/axis/client_services.png ouch! see, you might want to try and emulate something like http://www.araelium.com/querious/screenshots/content_75p.png (MySQL tool) or http://fileability.net/Raw%20Screenshots/Form%20Design.png (built for and with SQLite) not something like http://www.bulkrenameutility.co.uk/Screenshots.php or http://www.billproduction.com/BillRed_scrsht.jpg In any case, your work looks very promising, and I look forward to seeing more of it as it would be a nice addition to the mix. -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Carbon Model http://carbonmodel.org/ Open Source Geospatial Foundation http://www.osgeo.org/ Sent from: Madison WI United States. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
On Thu, 2009-02-26 at 15:44 -0600, Alan Cohen wrote: > None of these really provide the kind of data entry screens I'd like to > have; I have not had time to try OOo Base yet. Well then. You'll be interested in my projects :) http://entropy.homelinux.org/axis/ ( my home server is unfortunately just a *little* unstable at the moment ... hardware looks to be dying ... so apologies if it goes down ... it's up at the moment anyway ). There are some screenshots of production systems that use the 3 libraries. I'm currently working on a GUI builder ( unreleased, but I can be convinced to dump a very early beta ). I have table browsing and data viewing working. Also creating forms ( via glade ) is working. I plan on implementing schema editing for SQLite and possibly MySQL. Datasheet creating ( via the GUI ) is completely unimplemented. Anyway, email me ( this address is probably better at the moment ) if you're interested in the GUI builder, otherwise check out the libraries. Dan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Best GUI?
This is a bit of a religious question, but which are the mest/most popular *nix GUIs out there? I'm using a firefox plugin but not entirely happy with it. What do you use and why? A lot depends on what you are trying to accomplish. For example, I move between several machines, mixed between several Linux distros and two Windows versions with an USB drive. I have used sqliteadmin, sqlitespy, and sqlite database browser (all Windows executables, all work under wine). I have also tried WinSQL (which is an ODBC-driven program I use when my clients give me SQL access to the applications I'm installing for them. None of these really provide the kind of data entry screens I'd like to have; I have not had time to try OOo Base yet. I'd be interested in other responses you get, as well. Alan B. Cohen, CPA ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users