Re: [sqlite] Installing SQLite

2009-07-22 Thread Nuno Magalhães
On Wed, Jul 22, 2009 at 21:30, scabral wrote: [...] > the instructions on the SQLite website are pretty crappy to say the least. > When i download the zip file, all i get is 3 txt files??? [...] Oh... a troll. ___ sqlite-users mailing list sqlite-user

Re: [sqlite] Ability to convert Access to SQLite

2009-07-22 Thread Nuno Magalhães
> Do you know of any third party applications that i could use to build the > front end?  This will need to run on local machines, not on servers.  So, > some sort of desktop application i would imagine That would be OS-dependent now, wouldn't it? Unless you're going to use Java or PHP or simi

Re: [sqlite] sqlite jdbc and rcp Eclipse

2009-06-09 Thread Nuno Magalhães
Name("org.sqlite.JDBC"); >   Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db"); > > Any advice? Depends on the exception, but most likely it's not finding the jar. HTH Nuno Magalhães -- () ascii ribbon campa

Re: [sqlite] [OT-ish] ResultSet size

2009-06-07 Thread Nuno Magalhães
Thank you all, i'm kinda rusty on SQL and ahd forgotten about count(*). -- () ascii ribbon campaign - against html e-mail /\ ascii-rubanda kampajno - kontraŭ html-a retpoŝto ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/

[sqlite] [OT-ish] ResultSet size

2009-06-07 Thread Nuno Magalhães
I tried iterating the set and using rs.isLast() but i get "SQLException: function not yet implemented for SQLite". I know this si more related to JDBC than SQLite, but maybe someone can give me a hint? TIA, Nuno Magalhães -- () ascii ribbon campaign - against html e-mail /\ asc

Re: [sqlite] [OT] Basic Netbeans project won't run on SQLite [SOLVED]

2009-06-03 Thread Nuno Magalhães
Eh... even though i chose an SQLite database, Netbeans doesn't include the sqlite.jar ... -- ()  ascii ribbon campaign - against html e-mail /\  ascii-rubanda kampajno - kontraŭ html-a retpoŝto ___ sqlite-users mailing list sqlite-users@sqlite.org http:/

[sqlite] [OT] Basic Netbeans project won't run on SQLite

2009-06-03 Thread Nuno Magalhães
)... Any suggestions would be appreciated, i haven't been able to find decent info on the net (most likely i'm not searching right). TIA, Nuno Magalhães [1] http://pastebin.com/m247e6077 -- () ascii ribbon campaign - against html e-mail /\ ascii-ru

Re: [sqlite] Newbie trying to list resultSet with C

2009-05-10 Thread Nuno Magalhães
Thanks for the replies guys! :) -- () ascii ribbon campaign - against html e-mail /\ ascii-rubanda kampajno - kontraŭ html-a retpoŝto ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Newbie trying to list resultSet with C

2009-05-08 Thread Nuno Magalhães
d task preferably ;) TIA, Nuno Magalhães -- () ascii ribbon campaign - against html e-mail /\ ascii-rubanda kampajno - kontraŭ html-a retpoŝto ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] [newbie] Binary and text-file storage in SQL(ite).

2009-03-19 Thread Nuno Magalhães
). What's recomended: to store strings that are the /path/to/textfile or /to/image.jpg? Or to store the image file in the database? the text file in the database? Which datatypes to use? TIA, Nuno Magalhães LU#484677 ___ sqlite-users mailing li

Re: [sqlite] httpd server ???

2009-03-17 Thread Nuno Magalhães
> Does anyone know of an embedded http server that can serve and/or create > pages from a sqlite database? What do you mean embedded? If you mean fast and lightweight, i use nginx. Nuno Magalhães LU#484677 ___ sqlite-users mailing list sqlite

Re: [sqlite] Best GUI?

2009-02-27 Thread Nuno Magalhães
ial 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@sqli

Re: [sqlite] Best GUI?

2009-02-27 Thread Nuno Magalhães
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,

[sqlite] Best GUI?

2009-02-26 Thread Nuno Magalhães
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

[sqlite] SQLite3 in PEAR

2009-02-15 Thread Nuno Magalhães
sqlite3, which containers/interfaces should i use? It *is* a simple site, but i feel i oughta be using some standard way. OT: does any of those packages support sessions? TIA Nuno Magalhães LU#484677 ___ sqlite-users mailing list sqlite-users@sqlite.org ht

[sqlite] [OT] FLOSS xls-oracle converter?

2008-12-11 Thread Nuno Magalhães
Greetings, Does anyone know a reliable converter to export a bunch of tables in an M$ excel file to regular ISO SQL92/2003 or, preferably (school work), Oracle? No GUI required, just an easy way to convert them... TIA, sorry for the OT Nuno Magalhães