Re: [sqlite] new sqlite-based webserver
Well I've never created one before but I think it
should be a straight forward setup.
Best regards,
__
Raymond Irving
--- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> thanks !
>
> "some kind" of SourceFourge is already available:
> you can download the
> source :-)
> do you know how to create a project on sourcefourge
> ? until now i've
> downloaded only ...
> but i think it will take 1 or 2 weeks (i've not much
> time now...)
>
> cu, gg
>
>
>
> Raymond Irving schrieb:
> > Very nice indeed. Any chance we will see some kind
> of
> > SourceFourge opening soon? Maybe after adding docs
> and
> > multithreading capabilities?
> >
> > __
> > Raymond Irving
> >
> > --- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> >
> >
> >> hi raymond,
> >>
> >> your idea of including other files is already
> done.
> >> there is a function "script" (see "gas,js") which
> >> includes other files.
> >> that how i want to support different
> "applications".
> >> on example is
> >> "notes". in "apps/notes.js" i implemented the
> ajax
> >> backend, in
> >> "www/Notes/*" i implemented the frontend.
> >>
> >> the part you've written about loading xml files
> >> (contacts.xml) is solved
> >> like this (again, see gas.js):
> >> var config = new XML(new
> >> File("server.xml").read());
> >> print(config.port+"\n");
> >>
> >> a simple scheduler is also already implemented
> >> (again, see gas,js :-):
> >> // print "from timer" to console in 10 secs
> >> addTimer(10, "print('from timer\\n');");
> >>
> >> i also implemented a database sample for directly
> >> editing databases via
> >> the browser (see SQLiteBrowser in the source
> zip).
> >> but its still not
> >> finished (only running in MSIE correctly !)
> >> there you can play with databases: select a
> database
> >> / select a table /
> >> edit values just with a dblclick, change the
> value,
> >> hit return...
> >>
> >> cu, gg
> >>
> >>
> >> Raymond Irving schrieb:
> >>
> >>> This is very very sweet :)
> >>>
> >>> Many thanks for sharing Greschenz. I would love
> to
> >>>
> >> see
> >>
> >>> this project mature. Maybe something like a
> >>>
> >> ThinClient
> >>
> >>> webserver with Javascript as the backend so we
> >>>
> >> could
> >>
> >>> write lovely web apps with AJAX support that
> >>>
> >> offers
> >>
> >>> database like features? Could it also run on
> >>> Thinstation with some attached storage? Wow!
> >>>
> >>> Here's some other ideas:
> >>>
> >>> * Make it possible to include external classes
> or
> >>> files, for example include('myclass.jsp')
> >>> * add some build it object to make it easier to
> do
> >>> stuff inside the server. Example Mail, File,
> >>>
> >> Scheduler
> >>
> >>> var mail = new Mail()
> >>> mail.to = '[EMAIL PROTECTED]';
> >>> mail.from = '[EMAIL PROTECTED]'
> >>> mail.subject = 'Hello';
> >>> mail.send()
> >>>
> >>> var f = new File('contacts.xml');
> >>> var xml = f.readAll();
> >>>
> >>> var sch = new Scheduler();
> >>> if(!sch.exists('MyImporter')) {
> >>>sch.setName('MyImporter');
> >>>sch.setInterval(30); // every 30 minutes
> >>>sch.execute('imports.jsp');
> >>>sch.save();
> >>> }
> >>>
> >>>
> >>> Just my 2 cents.
> >>> __
> >>> Raymond Irving
> >>>
> >>>
> >>> __
> >>> Raymond Irving
> >>>
> >>> --- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> >>>
> >>>
> >>>
> >>>> Hi,
> >>>>
> >>>> the reasons why i did this:
> >>>> 1) i wanted to have a simple webserver to get
> my
> >>>>
> >> son
> >>
> >>>> involved in
> >
Re: [sqlite] new sqlite-based webserver
Very nice indeed. Any chance we will see some kind of
SourceFourge opening soon? Maybe after adding docs and
multithreading capabilities?
__
Raymond Irving
--- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> hi raymond,
>
> your idea of including other files is already done.
> there is a function "script" (see "gas,js") which
> includes other files.
> that how i want to support different "applications".
> on example is
> "notes". in "apps/notes.js" i implemented the ajax
> backend, in
> "www/Notes/*" i implemented the frontend.
>
> the part you've written about loading xml files
> (contacts.xml) is solved
> like this (again, see gas.js):
> var config = new XML(new
> File("server.xml").read());
> print(config.port+"\n");
>
> a simple scheduler is also already implemented
> (again, see gas,js :-):
> // print "from timer" to console in 10 secs
> addTimer(10, "print('from timer\\n');");
>
> i also implemented a database sample for directly
> editing databases via
> the browser (see SQLiteBrowser in the source zip).
> but its still not
> finished (only running in MSIE correctly !)
> there you can play with databases: select a database
> / select a table /
> edit values just with a dblclick, change the value,
> hit return...
>
> cu, gg
>
>
> Raymond Irving schrieb:
> > This is very very sweet :)
> >
> > Many thanks for sharing Greschenz. I would love to
> see
> > this project mature. Maybe something like a
> ThinClient
> > webserver with Javascript as the backend so we
> could
> > write lovely web apps with AJAX support that
> offers
> > database like features? Could it also run on
> > Thinstation with some attached storage? Wow!
> >
> > Here's some other ideas:
> >
> > * Make it possible to include external classes or
> > files, for example include('myclass.jsp')
> > * add some build it object to make it easier to do
> > stuff inside the server. Example Mail, File,
> Scheduler
> >
> > var mail = new Mail()
> > mail.to = '[EMAIL PROTECTED]';
> > mail.from = '[EMAIL PROTECTED]'
> > mail.subject = 'Hello';
> > mail.send()
> >
> > var f = new File('contacts.xml');
> > var xml = f.readAll();
> >
> > var sch = new Scheduler();
> > if(!sch.exists('MyImporter')) {
> >sch.setName('MyImporter');
> >sch.setInterval(30); // every 30 minutes
> >sch.execute('imports.jsp');
> >sch.save();
> > }
> >
> >
> > Just my 2 cents.
> > __
> > Raymond Irving
> >
> >
> > __
> > Raymond Irving
> >
> > --- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> >
> >
> >> Hi,
> >>
> >> the reasons why i did this:
> >> 1) i wanted to have a simple webserver to get my
> son
> >> involved in
> >> programming an online game, and he knows already
> a
> >> little bit javascript
> >> 2) my hobby is programming in c++ and javascript,
> >> but at work i have to
> >> code in c#, so i just wanted to have some fun :-)
> >>
> >> i think its no a new idea, ive seen some
> webservers
> >> using javascript as
> >> backend language, but everything i found was to
> >> complicated to
> >> install/use or to complicated to port to a new
> >> hw-platform (i want to
> >> run it on my linksys-nslu2 with ftpd to my
> topfield
> >> hd-vcr to program
> >> the recordings via web).
> >> and i like sqlite very much and no webserver i
> found
> >> had this combination.
> >> if you look at my code, you see that i just use
> >> *) sqlite
> >> *) the javascript-engine from mozilla (very
> >> advanced: js v1.7 including
> >> xml support...),
> >> *) some glue code to access sqlite and a simple
> http
> >> server from js
> >> (only one file: gas.cpp)
> >>
> >> the trick between js and sqlite is like yours:
> every
> >> sql statement
> >> executed returns a 2-dim array...
> >> one thing is maybe iteresting: the class
> "DBItem".
> >> its a kind of (very
> >> simple) or-mapper.
> >> it maps the properties of a javascript-object to
> the
> >> columns of a table.
> >> here is a code example:
> >>
> >> var db = new Database("user.sdb");
> >> db.exec("create table if not exists user (id
&
Re: [sqlite] new sqlite-based webserver
This is very very sweet :)
Many thanks for sharing Greschenz. I would love to see
this project mature. Maybe something like a ThinClient
webserver with Javascript as the backend so we could
write lovely web apps with AJAX support that offers
database like features? Could it also run on
Thinstation with some attached storage? Wow!
Here's some other ideas:
* Make it possible to include external classes or
files, for example include('myclass.jsp')
* add some build it object to make it easier to do
stuff inside the server. Example Mail, File, Scheduler
var mail = new Mail()
mail.to = '[EMAIL PROTECTED]';
mail.from = '[EMAIL PROTECTED]'
mail.subject = 'Hello';
mail.send()
var f = new File('contacts.xml');
var xml = f.readAll();
var sch = new Scheduler();
if(!sch.exists('MyImporter')) {
sch.setName('MyImporter');
sch.setInterval(30); // every 30 minutes
sch.execute('imports.jsp');
sch.save();
}
Just my 2 cents.
__
Raymond Irving
__
Raymond Irving
--- Günter Greschenz <[EMAIL PROTECTED]> wrote:
> Hi,
>
> the reasons why i did this:
> 1) i wanted to have a simple webserver to get my son
> involved in
> programming an online game, and he knows already a
> little bit javascript
> 2) my hobby is programming in c++ and javascript,
> but at work i have to
> code in c#, so i just wanted to have some fun :-)
>
> i think its no a new idea, ive seen some webservers
> using javascript as
> backend language, but everything i found was to
> complicated to
> install/use or to complicated to port to a new
> hw-platform (i want to
> run it on my linksys-nslu2 with ftpd to my topfield
> hd-vcr to program
> the recordings via web).
> and i like sqlite very much and no webserver i found
> had this combination.
> if you look at my code, you see that i just use
> *) sqlite
> *) the javascript-engine from mozilla (very
> advanced: js v1.7 including
> xml support...),
> *) some glue code to access sqlite and a simple http
> server from js
> (only one file: gas.cpp)
>
> the trick between js and sqlite is like yours: every
> sql statement
> executed returns a 2-dim array...
> one thing is maybe iteresting: the class "DBItem".
> its a kind of (very
> simple) or-mapper.
> it maps the properties of a javascript-object to the
> columns of a table.
> here is a code example:
>
> var db = new Database("user.sdb");
> db.exec("create table if not exists user (id
> integer primary key
> autoincrement, name varchar unique, pwd varchar,
> test varchar)");
> var user = new DBItem(db, "user");
> user._name = "Guenter";
> user._pwd = "FooBar1234567890";
> user._test = "blubb";
> user.flush();
> var id = user._id;
> var user = new DBItem(db, "user", id);
> print("name="+user._name+"\n");
> //db.exec("delete from user where id="+id);
>
> if you are still curious (or anyone else ?), i can
> send you the actual
> source by mail. :-)
>
> btw: i had a look into your http-source: looks nice,
> but its maybe to
> complicated to implement my features like
> http-multipart-posts.
>
> cu, gg
>
>
>
>
>
> John Stanton schrieb:
> > The multi-threaded application/www server I
> described requires no
> > threading involvement from the application
> programmer. That
> > programmer uses SQL, HTML, Javascript and the
> application language we
> > call MUV. Think about it, when you use Apache you
> don't have to be
> > aware of its internal threading.
> >
> > The only significant synchronisation element is to
> do with multiple
> > users of Sqlite, and that is handled transparently
> to the application
> > programmer.
> >
> > What I was curious about was your statement that
> you used Javascript
> > as a backend. Do you have a novel idea there?
> For example my
> > application language will, inter alia, populate
> Javascript arrays from
> > an SQL statement. Do you have any such features
> or something more
> > ingenious? (I still cannot get access to your
> server).
> >
> > My application server runs on Win98, Win2000/XP,
> Linux, AIX 4.2 and
> > 5.3. The executive, fileserving, compression and
> CGI components are
> > realised in less than 20K of code. HTML V2 is
> implemented.
> >
> > There are some old fragments of this program at
> > http://www.viacognis.com/muvm. If you are
> interested I can dig out
> > the current code and let you have it.
> >
> >
> > Günter Greschenz wrote:
> >> Hi,
> >>
> >&g
Re: [sqlite] Version 3.1.0
Hi, It would be nice if Autovacum can be set for a database with data and also be set to occur at timely intervals. Maybe something like every 1000 updates or deletes. __ Raymond Irving --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Version 3.1.0 (alpha) of SQLite is now available on > the website. > Release notes are available from a link on the > homepage. > > This released is labeled "alpha" but it is still > very well > tested. By being "alpha" it means that there is > still a > small window of opportunity during when users can > suggest > API changes. Once we go to beta (in about a week) > no more > changes will be accepted. So if you want to suggest > changes, > please do so quickly. > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > >
[sqlite] PRAGMA short_column_names not working in 3.0.8
Hello Everyone, I've download sqlite 3.0.8 and opened a database to try the PRAGMA short_column_names feature but it did not work. It only returned blank column names. Any ideas or fixed? Here's the result from the sqlite3 console with .headers on: sqlite> pragma short_column_names = on ...> go sqlite> select t1.*,t2.* from customers t1, orders t2 limit 1 ...> go ALFKI|Alfreds Futterkiste|Maria Anders|Sales Representative|Obere Str. 57|Berlin ||12209|Germany|030-0074321|030-0076545|10330|LILAS|3|16-Nov-1994|14-Dec-1994|28 -Nov-1994|1|12.75|LILA-Supermercado|Carrera 52 con Ave. Bol¦§¢®var #65-98 Llano La rgo|Barquisimeto|Lara|3508|Venezuela __ Raymond Irving
Re: [sqlite] Preventing TableNames.columns inside SELECT
Thanks, I'll give it a try with version 3.0.8
__
Raymond Irving
--- John LeSueur <[EMAIL PROTECTED]> wrote:
> Raymond Irving wrote:
>
> >Hi All,
> >
> >Please consider the following example:
> >
> >I would like to only return the field names and not
> >table.fieldnames...
> >
> >SELECT t1.column1,t2.clumn2
> >FROM tableA t1,table2 t2
> >
> >..In MSSQL and others the recordset should only
> show
> >column1, column2 but in SQLite it shows t1.column1
> and
> >t2.column2. How can I
> >
> >How do I configure SQLite to only return the field
> >(or column) names?
> >
> >
> >__
> >Raymond Irving
> >
> >
> >
> Are you using sqlite 2.x? If so, there is a little
> change below that can
> fix it, and I think for 3.x it's already been
> changed.
> At least I was told so. I really hope so, because I
> get tired of using
> AS all the time. With the following patch, just set
> pragma short_column_names to be 1 and sqlite will
> return column names
> formatted just like every other database.
>
> John Lesueur
>
>
> diff -NU3 -r ./select.c
> ../../sqlite-orig/src/select.c
> --- ./select.c2004-06-19 11:31:48.778990400
> -0600
> +++ ../../sqlite-orig/src/select.c2004-06-17
> 13:03:38.0 -0600
> @@ -739,7 +739,7 @@
> sqlite3SetString(, zTab, ".", zCol,
> 0);
> sqlite3VdbeSetColName(v, i, zName,
> P3_DYNAMIC);
>}else{
> -sqlite3VdbeSetColName(v, i, zCol,
> P3_STATIC);
> +sqlite3VdbeSetColName(v, i, zCol, 0);
>}
> }else if( p->span.z && p->span.z[0] ){
>sqlite3VdbeSetColName(v, i, p->span.z,
> p->span.n);
>
>
[sqlite] Preventing TableNames.columns inside SELECT
Hi All, Please consider the following example: I would like to only return the field names and not table.fieldnames... SELECT t1.column1,t2.clumn2 FROM tableA t1,table2 t2 ..In MSSQL and others the recordset should only show column1, column2 but in SQLite it shows t1.column1 and t2.column2. How can I How do I configure SQLite to only return the field (or column) names? __ Raymond Irving
[sqlite] SQLite now supports ALTER Table?
Hey check this out: This SQLiteDB php class allows you to use ALTER TABLE with your sqlite database. http://code.jenseng.com/db/
Re: [sqlite] LIKE, BETWEEN
This is very strange. Common sense will tell us that a BETWEEN call on the "a" column should use the index "t_idx_0". I can't see why SQLite is doing a table scan. Is this another one of those code-optimized features of SQLite to forget intelligent parsing and processing in order to reduce DLL size? __ Raymond Irving --- Mike Ponomarenko <[EMAIL PROTECTED]> wrote: > In sqlite3 queries using LIKE and BETWEEN do not use > existing indices. So for > a schema like > CREATE TABLE t (a integer, b char(40)); > CREATE INDEX t_idx_0 ON t(a); > CREATE INDEX t_idx_1 ON t(b); > queries like > "SELECT * FROM t WHERE a BETWEEN 1 AND 20"or > "SELECT * FROM t WHERE b LIKE 'abc%'" > end up doing a table scan. > > Just curious if there are any changes in the works > to make queries such as above > use available indices? > For BETWEEN: Integer 2, MoveGE, Next until > 20, > etc. > For LIKE: if one parameter is a string with a > constant prefix, String8 'abc', > MoveGE, Next until Function(LIKE) fails, etc. > > I realize that queries can be rewritten to make them > more efficient (SELECT * > FROM t WHERE a >= 1 AND a <= 20), etc., but it's not > always feasible. I'd > appreciate any thoughts on the matter. Thanks! >
Re: [sqlite] Encrypting data stored in database
Man this sounds great! I would really like to know
where exactly I can make the changes to encrypt the
database. I would even add a passkey feature (or xor
string) that would be used to offer minor database
obfuscation.
Why don't the development group add something like
this to the source? Is it because Dr Hipp already have
an encryption module? I think we should at least have
a very simple obfuscation feature added to the open
source version of SQLite.
__
Raymond Irving
--- Joey Blankenship <[EMAIL PROTECTED]> wrote:
> We made the mods in os_win.c, in the read and write
> routines, after the
> read and before the write. A more robust solution
> would have been to
> modify the code in os_mac.c and os_unix.c as well,
> but we didn't need
> that. It was very easy and the only caveat is that
> once you modify it, it
> will no longer read existing databases. That was
> not a problem for us, but
> it might be if you want to convert a database.
>
> Joey.
>
> At 06:11 PM 9/9/2004, you wrote:
> >Joey,
> >
> >Where in the code did you do that? Was it easy to
> put in one or two places?
> >
> >-brett
> >
> >try IeToolbox Passwords & Notes Keeper, Form Filler
> and much more
> >www.ietoolbox.com
> >
> >
> >
> >Joey Blankenship wrote:
> >
> >>Not to respond out of turn here, but we had a need
> to obfuscate the plain
> >>text (due to some users that are a little too
> curious for their own good)
> >>that was stored but did not want the performance
> burden that
> >>encryption/decryption would place on the PocketPC.
> Prior to writing and
> >>subsequent to reading, we just perform a simple
> mangle of the
> >>read/written data. A byte NOT or XOR works pretty
> well and does not
> >>cause an extreme performance hit. Again, no real
> encryption, but it
> >>hides the data from casual viewing.
> >>
> >>Joey.
> >>
> >>At 05:34 AM 9/9/2004, you wrote:
> >>
> >>>Hello sqlite users,
> >>>Hello Dr. Hipp,
> >>>
> >>>I would like to know if there is a way to encrpyt
> the data stored in the
> >>>database but to still be able to use SQL queries
> with plain text,
> >>>something like
> >>>
> >>>CREATE TABLE TEST (fld)
> >>>INSERT INTO Test VALUES ('some string')
> >>>SELECT * FROM Test WHERE fld = 'some string'
> >>>
> >>>but, when the sqlite database is opened in a file
> viewer, 'some string'
> >>>would not be visible but only it's encrypted
> form.
> >>>
> >>>Regards,
> >>>George Ionescu
> >>
> >>
>
>
Re: [sqlite] New SQL Function.
Is there some form of documentation that should all the functions allowed inside an SQL statement? For example: DATE(), CASE, etc __ Raymond Irving --- Doug Currie <[EMAIL PROTECTED]> wrote: > > Wednesday, August 18, 2004, 1:45:43 PM, Federico > wrote: > > > [...] > > > gcc -g -O2 -DTHREADSAFE=1 -DOS_UNIX=1 -DOS_WIN=0 > -DHAVE_USLEEP=1 -I. > > -I../sqlite/src -DHAVE_READLINE=0 > > -o .libs/sqlite ../sqlite/src/shell.c > ./.libs/libsqlite.so > > ./.libs/libsqlite.so: undefined reference to > `sqrt' > > collect2: ld returned 1 exit status > > make: *** [sqlite] Error 1 > > You must link with a math library that includes > sqrt. > > Perhaps adding -lm (assuming you have libm.a and it > has sqrt) to the > end of the TCC or LTLINK lines in the Makefile will > help. > > e > > >
Re: [sqlite] ignore index
It would be even better if SQLite could do a better job at optimizing the index searches. __ Raymond Irving --- rene <[EMAIL PROTECTED]> wrote: > Hi, > > i ran into a simulair case as this message > http://www.mail-archive.com/[EMAIL PROTECTED]/msg01646.html > > where an index actually slows things down, because > there are many rows matching the > condition (where the other (indexed) condition only > matches a few rows). > > In above mentioned letter you suggest to just drop > the index, or concat the condition with an > (empty) string (like: instead of "checked=0" use > "checked||''='0' "). > > in my case, i need the index for another query.. > well, i could consider to drop it but the fix is > good enough for me.. i just like to mention that it > would be a really cool feature to tell sqlite with > index(es) not to use with something like 'IGNORE > INDEX fieldname' or something.. > > also, maybe it is good idea to put this in the > documentation (including above trick), but since it > is a wiki i can guess the answer on that ;) > > regards, > > rene > > - > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] SQLite performance with mid-size databases
See below: --- Jacob Engstrand <[EMAIL PROTECTED]> wrote: > To disable the > I1A index, > rewrite the WHERE clause like this: > > SELECT * FROM t1 WHERE a+0=5 AND b='xyzzy'; > > To disable the I1B index you could write > > SELECT * FROM t1 WHERE a=5 AND b LIKE 'xyzzy'; > Why not add a feature to SQLite to allow the user to choose the index to use? Maybe something like this: SELECT * FROM t1 WHERE a=5 abd b='xyzzy' USE INDEX(a) Wouldn't this be much more straiht forward and easier to read? __ Raymond Irving - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] SQLite performance with mid-size databases
Well this does not sound good at all. I would think that SQLite would at least do a better job at queries. The issues with performance and scalability is of great concern. I was planning on create some new apps that use SQLite, but now I'm wondering is this little database is capable of handle over 2 Gigabytes (GB) of data even though the docs says it can handle up to 2 Terabytes (TB). Does it really make sense to cut back on performance in order to keep the library size small? Will SQLite 3.0 fix these problems? __ Raymond Irving --- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > Richard Kuo wrote: > > > > I suspect some unnecessary disk access has to be > the problem...despite > > the small amount of new guide information being > queried out, disk bytes > > read is several times higher than with MS access > and scrolling back over > > previously accessed areas of data is visibly > faster...indicating that > > the disk cache is very favorably impacting the > speed of the queries. > > > > If each of your rows contains 2K of data, that means > each database entry > is using about 2 overflow pages. You can change > this by increasing the > page size. Try recompiling SQLite after changing > the SQLITE_PAGE_SIZE > macro to 16384. > > You might also trying switching to SQLite version > 3.0.0 which will be > released tomorrow. > > Also tomorrow, I will be making available a database > analysis tool > for version 2.8 databases that will help us to > better understand > how information is stored on disk for your database, > and possibly > provide some clues about why you are having > problems. > > -- > D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 > > > - > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Re:SQLite ODBC Driver
Hello, Here's what my ISP is saying: "it doesn't look like we would be installing SQLite on our shared servers. It looks to be in an "experimental state" so we couldn't install it due to the security and stability risks." Now if there was only a stable ODBC driver with SQLite then I could have them install it. So I'm back to square one. Back to MS Access. PS Why do most open-source community alway think inside-a-Box? Why don't they ever think out-the-box? Why think Guru? __ Raymond Irving - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: [sqlite] SQLite and ODBC
Hi, I've download the version at http://www.ch-werner.de/sqliteodbc/ and it works just fine. I was only making a suggestion that such a cool database should come bundled with an ODBC driver (meaning it's part of the development). SQLite is very cool but it does not make any sense if it can't be (easily) integrated with existing components. Rather than having the ODBC driver separate I would suggest that it be a part of the teams plan for future versions. Darren said that this would add more load the the developers but I don't think it should really. Making SQLite more connectable is something that the team should also consider. Not everyone uses C or C++ and not all components have an interface to bind an array. We just have to look at what tools we have available and see how best we can make them integrate-able. __ Raymond Irving "Griggs, Donald" <[EMAIL PROTECTED]> wrote: Regarding: "I was more think of ways to get an SQLite Database connected to every day database objects and controls." A good point! This may be a naive comment of mine, but if you just forgot about the vanilla sqlite download page, and instead considered page: http://www.ch-werner.de/sqliteodbc/ to be THE release point for sqlite-cum-ODBC, would that not give you what you need? [writing for myself, and not on behalf of my company]
[sqlite] SQLite and ODBC
Hi, I think SQLite should come standard with an odbc driver since ODBC is an "open standard" __ Raymond Irving
RE: [sqlite] sqlite with Visual Basic
Hi,
I've recently downloaded and used the ODBC driver and have not seen any problems with
it thus far. It works great with ADO. In fact I was able to use it as a drop-in
replacement for an MS SQL Server connection using ADO
It's very easy to install. You just simple copy the files with your installation
program:
inst.exe
sqliteodbc.dll
sqliteodbcu.dll
uninst.exe
The next thing to do is to run the inst.exe file to install and uninst.exe to
uninstall the ODBC drivers.
PS. I think the dlls should go inside the "windows\system32" or "windows\system"
folder.
__
Raymond Irving
Steve O'Hara <[EMAIL PROTECTED]> wrote:
Hi Murray,
Installshield has a method for creating ODBC configurations as part of the
setup.
If I remember, I think that there is an MS API for interacting with the ODBC
setup - if all else fails, do it yourself by writing to the appropriate
places in the registry.
Steve
-Original Message-
From: Murray Moffatt [mailto:[EMAIL PROTECTED]
Sent: 17 May 2004 05:14
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic
I'm interested in using SQLite from within a Visual Basic 6 app that I'm
writing. I need reporting features and so was looking at using Crystal
Reports.
I'm guessing that it would be easiest to use SQLite ODBC for accessing the
SQLite database, as the VB tools and Crystal Reports support ODBC.
When I downloaded SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ and
looked at the readme file I was a bit concerned when I read that this was
still "experimental". Obviously if I want to distribute my app to others I
want something that isn't going to bomb out every so often! If anyone else
is using SQLite ODBC in an app I'd like to hear how stable it is?
Also the readme file says that it has to be installed and databases set up
by using the ODBC Control Panel applet. Obviously I don't want to have to
tell people that they have to set all this up themselves by hand after they
install my app, so is there any way I can programmatically set up the ODBC
connection? Either via my installation program or within the main app
itself?
At 20:32 16/05/2004 +0200, you wrote:
Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code
for
you):
Dim db as ADOSQLite
Set db = new ADOSQLite
db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if
Of course this runs "in-memory" so if this is a concern for you, then try
to
narrow down your selects.
Cheers!
Chris
> -Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> I use SQLite ODBC with ADO to access databases from VB. It
> works like a charm.
>
> http://www.ch-werner.de/sqliteodbc/
>
> __
> Raymond Irving
>
>
> Jérôme_VERITE wrote:
> I use this wrapper and to simplify again the code, I created
> littles classes which are very simple and look like the DAO
> classes. It permits to transform Simply a VB application
> using DAO to SQLITE
>
> Jérôme
>
> -Message d'origine-
> De : Steve O'Hara [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
>
>
> Here's the SQLite wrapper for VB from the Yahoo groups
>
> Steve
>
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
>
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
>
> If you cannot download from the link above then you
> will have to join the group to get it.
>
> HTH,
>
> Jalil Vaidya
>
> Disclaimer: I have never used this wrapper myself.
>
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
>
>
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
>
>
>
>
> __
>
[sqlite] God-Given (A real life story)
God-Given Diosdada Fernandez I hated my name, which means God-given, until God gave me my life back. I live in Cuba, and although my mother claimed to be a Christian, I grew up not believing in God. Then in 1996 I learned that I had rectal cancer. The doctors operated, then they began radiation treatments. But the treatments did more harm than good, and I was in incredible pain. Doctors gave me morphine for the pain, but I became afraid to even eat. I lost weight and paralysis was slowly setting in. The doctors gave me little hope that I would survive. While I was still in hospital, a fire in the hospital set off a severe asthma attack. I coughed so hard that I tore out my stitches and fell to the floor. When nurses rescued me, I could not breath. X-rays showed that the fire had damaged my lungs, but worse, I also had lung cancer from heavy smoking over the years. Doctors operated to repair my torn stitches, but they stopped midway through surgery, thinking I was dead. I awoke to see a beautiful city and a bright, shinning being. I felt peaceful and well, and I began to talk to the beautiful being. Doctors heard me and stared in disbelief, thinking I had died. They quickly completed the surgery and took me to recovery. Just hours after surgery I felt better than I had felt in months years, even. I got out of bed and walked, where just a day before I was paralyzed and could not walk. It was as if superhuman strength poured through my body. A hospital worker asked my son, a doctor, if I was a believer, and he told the man that my only loves in life were women, tobacco, and alcohol. Then the worker told my son I had been quoting Scripture to them, though I had never read the Bible. And when breakfast came I ate hungrily for the first time in months. Clearly god was working wonders, miracles in my life, though I did not yet know him. My recovery from cancer was so rapid that doctors were amazed. Just hours after my final surgery, I was out of bed visiting other patients. Soon doctors could find no reason to me longer. When Christians had come to visit me in the hospital, I had made fun of them. But when my Christian niece came to see me, I was thrilled. She brought me a Bible, and I begged her to stay and help me understand it. I wanted so much to find out what God had to say about what had happened to me. My niece stayed for there days to help me begin my journey to God. We spent hours talking about God and His word. I asked her how to become a Christian, and she prayed with me while I accepted Jesus as my Saviour. Then I asked forgiveness of all the Christians whom I had ridiculed while in the hospitial. I made a promise to God that I would tell others what he had done for me wherever I had a chance. So I began walking to churches throughout central Cuba giving my testimony to all who would listen. But I still did not have a church home of my own. Always there seemed to be something about the churches I visited that did not seem quite right. Then an Adventist man invited me to come to his church to give my testimony. In that little Adventist church I found something different, something special. The members humility and love touched me deeply. As I listened to the sermon I sensed that I had found the true church, the one that followed all of Gods teachings. After the service I asked the pastor how I could make this church my home. Before too long I was baptized. God has given me a ministry among the sick, and I rejoice to know that God is using me as his vehicle to pray for people who were then healed. I cannot thank God enough for all He has done for me. He healed me, saved me, and sent me out to share my blessings with others. And my name, Diosdada? Now I understand why my mother chose that name. For God has given me everything! Diosdada Fernandez lives in Camaguey, Cuba, where he shares his faith will all who will listen.
Re: [sqlite] sqlite with Visual Basic
I use SQLite ODBC with ADO to access databases from VB. It works like a charm. http://www.ch-werner.de/sqliteodbc/ __ Raymond Irving Jérôme_VERITE <[EMAIL PROTECTED]> wrote: I use this wrapper and to simplify again the code, I created littles classes which are very simple and look like the DAO classes. It permits to transform Simply a VB application using DAO to SQLITE Jérôme -Message d'origine- De : Steve O'Hara [mailto:[EMAIL PROTECTED] Envoyé : vendredi 14 mai 2004 10:35 À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED] Objet : RE: [sqlite] sqlite with Visual Basic Here's the SQLite wrapper for VB from the Yahoo groups Steve -Original Message- From: Jalil Vaidya [mailto:[EMAIL PROTECTED] Sent: 14 May 2004 02:13 To: Carlos Garces; [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Visual Basic There is a VBWrapper.zip in the old SQLite yahoo group's file section. The archive contains wrapper over the SQLite API so that it can be used from VB. The API declarations for VB are also in the archieve. Get it from here: http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-4gKNXEFX9QQmKI vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper If you cannot download from the link above then you will have to join the group to get it. HTH, Jalil Vaidya Disclaimer: I have never used this wrapper myself. --- Carlos Garces wrote: > Hi! > I can use SQLLite with Visual Basic without using > other external DLL > Any sample of using sqlite.dll API? > > Thanks > Carlos Garcis = 01001010 0111 01101100 01101001 01101100 __ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Field/String Concatination
Hello, How do I concatinate two or more strings or fields in SQLite? For Example: Select CustomerID,CompanyName,ContactName + '/' + ContactTitle As 'Contact', Address From Customers The Contact column returns 0. __ Raymond Irving
[sqlite] ADO 2.6 Provider for SQLite
Hello, Does anyone know where I can get the ADO provider for SQLite (if it's available)? I'm using ADO 2.6 (not ADO.Net) and would like to access the SQLite database via the ADO objects. Many Thanks __ Raymond Irving - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Fwd: RE: [sqlite] RE: SQLite in OpenOffice?
Note: forwarded message attached. --- Begin Message --- --- Tim Anderson <[EMAIL PROTECTED]> wrote: > It's worth noting that Sqlite is not the equivalent > of Microsoft Access. > If anything, Sqlite is the equivalent of JET, the > Access database > engine. In order to offer a meaningful alternative > to Access, the > OpenOffice team (or someone) would need to create an > excellent GUI > front-end in some languager or other, including an > easy way to script > Sqlite applications. I think this would be a wonderful thing! Maybe someone can suggest this to the OpenOffice group? I think they should use SQLite for db, Javascript for scripting and HTML for reporting and user interfacing. All this can be stored in one db file. -- Raymond Irving > As it happens, I'm working on an MDB->Sqlite > converter that I hope to > share at some point. > > Tim > > - > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > --- End Message --- - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
