Re: [sqlite] Need pointers for better build integration and support of schema updates

Hi Andreas, Our application uses 3 Sqlite dbs and System.Data.Sqlite.dll (dropped by installer). Functionality allows users to start a new instance of one of the databases at run time. Hence we ship empty databases in a binary format, created by one of our developers. The process of making

Re: [sqlite] Syncing databases on different servers

Hi Ian, > I do not need instant syncing of SQLite databases, however I do have > a table stored on server X which I would like to gradually send > changes of to various other servers connected by TCP. > > In the first instance, I'd be quite happy to send rows with ids which > do not exist in

Re: [sqlite] (UML) Visualisation of a SQLite schema ?

Hi Fredrik, > I'm looking for a tool that would generate a visualisation (UML?) of > the SQLite database schema I'm using, with table constraints and > references between tables if possible. Is there such a tool (for Mac)? > If you are interested in doing something yourself- then this might be

Re: [sqlite] how to read schema file into database with tcl

Hi mweiguo, > hi all: > i am writing a tcl script, it will create a empty database and read a > schema file into database ... > in command line, it works when i use > >>> .read schema.sql >>> > but in tcl script enviroment, how can i do that ? > This script reads the *.sql file as a

Re: [sqlite] SQLite server

>> Thanks for that, and the analysis that preceded it. That was my guess, >> especially point 1, the most significant thing. >> Simon, I read both your suggestion and the Richard's good explanation about >> network problems. I think that the idea still deserves to live in some form >> :). I

Re: [sqlite] Date format definition on bulk csv insert

Hi Albert, > in the csv; the field is defined like: > > 2010.03.31 16:01:24.284 For a datetime field. > > I would like to tell sqlite that this is in > .mm.dd hh:mm:ss.sss > > How can I define this in sqlite's program so it imports the datetime > correctly? > I have used the SQLite C

Re: [sqlite] Oracle connection

Simon Hax wrote: > for clearification: > > the roots of the question: > business needs; our client has a big Oracle infrastructure. > Now they want, in relation to their infrastructure a litte App based on > SQlite. > > as I mentioned earlier: > to copy data from an Oracle DB to another Oracle DB

Re: [sqlite] Oracle connection

t statement A to Oracle > while there's record returned by statement > issue insert statement B to SQLite with data retrieved from Oracle > move to the next row in statement A > end of while > > I'm pretty sure that if SQLite could do what you want, Simon, it would &g

Re: [sqlite] Oracle connection

Simon Hax wrote: > I don't know what JET is. > I testet ADO. That works. > But it'is slow and you have to write some (to much) code. > > Much more better would be a solution like a direct LINK (like an Oracle > Database Link). > > as shown in my first email: > > insert into sqlitetable_columA

Re: [sqlite] cannot import blank columns in a Sqlite table

Hi, am65 wrote: > What is strange is that it used to do the import correctly. But from a > certain point of time it started to ignore the blank columns. > If you check the issues for SQLite Manager you will determine that ver. 0.5.12- 0.5.14 did not insert properly. According to the change log

Re: [sqlite] SQLite template files

Hi Tom, > One feature of this software is its ability to facilitate data entry in views > (ie not just tables). So I am especially interested in SQLite files that make > use of views, triggers, relationships etc. Some simple, some advanced. > > Can you direct me to were I might find some useful

Re: [sqlite] Compile Virtualtext extension

Alexey Pechnikov wrote: > Original SQLite source tree has "ext " directory for extensions and I did > place my extensions into this directory > > $ ls sqlite3-3.6.20/ext > async billing compress empty env fts1 fts2 fts3 functions iconv icu > inet key md5 README.txt rtree tablefunc

Re: [sqlite] Compile Virtualtext extension

Thanks Alexey, Great response. I'll make the changes and get back to you. Take care- Gary Gabriel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Compile Virtualtext extension

Hi Alexey Thanks for your input. I have tried variations of your suggestions, but there are still questions about the errors and warnings that I would like to clarify. I am still new at this so I maybe making some errors as well, any suggestions would be appreciated. Concluding test today: by

Re: [sqlite] Firefox SQLite Manager extension troubles.

Ted Rolle wrote: > I'm using the Firefox SQLite Manager extension. > I've renamed the database file. > I get this message: 'The file does not exist anymore: E:\Documents and > Settings\ted\Books\William R. Denslow\10' > Well, duh. > Where is the SQL database file name stored in the Firefox SQLite

Re: [sqlite] Compile Virtualtext extension

Hi Alexey thanks for the prompt answer. I saw your extension and tried it in the Spatialite GUI. The trial worked well in the GUI and it is useful for messaging environments. However I am still not sure what the recommended way of compiling it is. - Should it be compiled when compiling SQLite

Re: [sqlite] Installing SQLite

Hi All; I'm a newbie trying to get up to speed on SQL and SQLite and first- thanks for the product, and thanks for the group access and the chance to extensively learn. I agree with the following and would volunteer to document my learning experience. I used this thread as an opportunity to