Re: [sqlite] Structured or Object-Oriented?

[EMAIL PROTECTED] schreef: If you're using Visual C# Express 2005 (or any 2005 product) then you may as well go for broke and learn the ADO.NET 2.0 framework. I wrote/maintain a fairly decent SQLite ADO.NET 2.0 Provider at http://sqlite.phxsoftware.com and make myself available on the

Re: [sqlite] WAKEUP !!! SOMEBODY IS DESTROYING THE WIKI PAGES

A lot of invisible spam is added http://www.xxx-free-porn.info/index2832.html - http://www.xxx-free-porn.info/index2833.html - http://www.xxx-free-porn.info/index2845.html - http://www.xxx-free-porn.info/index2933.html - http://www.xxx-free-porn.info/index2975.html -

Re: [sqlite] WAKEUP !!! SOMEBODY IS DESTROYING THE WIKI PAGES

Lodewijk Duymaer van Twist wrote: Looks strange, many changes now, today, in short time. But I cannot judge what is changed, some one should take a look at it. Bert 21:12 * Wiki page SqliteCompetitors edited by anonymous

Re: [sqlite] NHibernate

Robert Simpson wrote: - Original Message - From: "Bert Verhees" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, March 27, 2006 9:27 AM Subject: [sqlite] NHibernate Hi, I am trying about whole day to connect a Delphi.NET app over NHibernate to

[sqlite] NHibernate

Hi, I am trying about whole day to connect a Delphi.NET app over NHibernate to SQLite. I cannot get it done. I have following App.config (in the exe-directory) type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0, Culture=neutral,

Re: [sqlite] Disable index?

wouldn't hurt also. If you're using > some wrapper it would be good to run that query from sqlite shell and > see how fast that goes. > > -- > Nemanja Corlija <[EMAIL PROTECTED]> -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] Decimal separator

Will Leshner wrote: On Jan 31, 2006, at 1:42 PM, Bert Verhees wrote: It is only the English speaking part of the world using Arabic numerals is a '.', And the Japanese speaking world :) Yuo are right, and the South American speaking Spanish also But the South American speaking

Re: [sqlite] Decimal separator

Carl Jacobs wrote: All would be fine but look at this : create table test( price double, amount double default 0 ); insert into test(price) values("12,0"); amount now = 0.0 The world seems to have settled on using Arabic numerals 0, 1, 2 ... 9. I think we should think about settling

Re: [sqlite] index question

Sorry, my emailer messed things up, try it again 0OpenVirtual10keyinfo(1,BINARY) 1Goto031 2Integer00 3OpenRead02 4SetNumColumns02 5Integer00 6OpenRead23keyinfo(1,BINARY) 7Integer1

Re: [sqlite] index question

Wilfried Mestdagh wrote: Hi, I'm a little confused how to create indexes. (beginners question, but I could not find or understeand clearly in FAQ). I have on a table following 3 selects: 'select distinct Name ' + 'from Rx ' + 'where RxDT >= ' + DT + ' ' + 'order by Name' 'select * ' +

Re: [sqlite] Dotnet C# support

I agree, never use PInvoke, if possible to avoid There is a performqncepenalty, and maybe you loose platform-independency (think of Mono) Bert > I think you are looking for this http://adodotnetsqlite.sourceforge.net/ > > I wrote my own driver in C++ (boy, that was a lot of work) then discovered

Re: [sqlite] Quoted identifiers

> delimited identifiers. Alternate output > behaviour can be accomplished by a connection or > statement specific pragma, or a wrapper. IMHO a very good Delphi-wrapper http://www.aducom.com/sqlite/ > > -- Darren Duncan -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] Speed Test Done !

833 / 55 seconds found 4322 records > out of 9,337,681 > > Still have found no sql program yet, that can beat Panorama in speed. > > Regards- > Richard Nagle > CMS -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] ANN: Sqlite3Explorer version 2.0 released

Mike, a very good, stable and handy tool. Especially I have a lot of pleasure with the querybuilder, saves me a lot of time. Thank you very much, Regards Bert Verhees. Op maandag 3 oktober 2005 18:52, schreef Cariotoglou Mike: > this is a major release, with a lot of changes. please

[sqlite] Richard Hipp Awarded Google-O'Reilly Open Source Award at OSCON 2005

SQLite is a very great engine. Thanks for the good work, well earned this award, congratulations. Good luck -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] Multi-threading.

Some class-libraries make multithreading programming really easy, piece of cake, even when there are points to synchronize again to a single thread (f.e. interface), it is easy. You do not need to be a genius to write multithreading/multithreaded code kind regards Bert Verhees

Re: [sqlite] searching for proper date and time stamps

[EMAIL PROTECTED] wrote: Hello, I'm using the TCL binding of sqlite3 One of the columns in my table has a date and time stamp, something like this: datetimes are sorted as strings, maybe that explains Bert 07/20/2004 01:35:40 06/20/2005 01:37:01 06/20/2005 12:10:07 06/20/2005 12:17:08

Re: [sqlite] Sqlite low level and Speed.

3BtreeInsert > sqlite3BtreeCursor > > I Use Windows and Delphi. In the SQlite3.dll no import this functions. > > Please Help me. May be need recompile sql I Have Visual C++ and C++Builder > If need recompile as make it is on Windows Platform? > > May be present other decision this problem? Need more speed for grouping > big arrays of strings > > Thanks you. -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] Trouble with column names

sing sqlite command line, enter the following: > > sqlite3 test.db > create table test(Field1 text(20)); > insert into test values ('a value'); > select field1 from test; did you try select field1 as field1 from test; regards Bert Verhees > > Field1 > a value > &g

Re: [sqlite] OnLine CD - what a method I choose

h, and decide later which one is better for you, Firebird or SQLite Bert > > Thanx: > ft > > Bert Verhees Ãrta: > > >Op vr, 22-04-2005 te 08:56 +0200, schreef [EMAIL PROTECTED]: > > > > > >>Hi ! > >> > >>In the years of 2000 I wrote 3

Re: [sqlite] OnLine CD - what a method I choose

ds32.dll It is said to be slower than SQLite, but in many situations you will not notice. It depends on what your app does, you only do reads, no inserts or updates I do not know about the language issue and firebird. regards bert verhees > > 2. XML ? > XML is very flexible, and

Re: [sqlite] ANN: Sqlite3Explorer

he Windows directory. This way you don't break Windows and it is possible you find a workaround. regards Bert Verhees Serge Liber New version is out. Since the problem with size limits was not lifted from contrib, I created a home site for the program. You will now be able to get latest version from ht

Re: [sqlite] Quoestion on Order By ... ?

have a good point, you can always do that, and it saves processor cycles for not adding the rowid unasked. regards Bert Verhees

Re: [sqlite] Quoestion on Order By ... ?

re is no requirement, but there is a wish to return a stable sorting outcome. Please note that the SQL standard does not prohibid stable sorting outcome. Please also note that by adding the rowid an unstable sort-algorithm can produce a stable sort-outcome. regards Bert Verhees

Re: [sqlite] Quoestion on Order By ... ?

Shum [Ming Yik] wrote: > Hi Scott Baker, > > In other SQL ... mySQL, PostgreSQL, MSSQL, SQLAnywhere ... > Both statement return same as (1) > > Actually (1) is the inserted order > > If SQLite show as other SQL ... It is much convenience ...! If the sort algorithm would always ends up the

Re: [sqlite] Proposal: limit the number of columns in a table to 2000.

I cannot imagine ever needing more then 2000 columns in a table, if I would, I could always create a parallel table As currently implemented, there is no fixed limit to the number of columns you can put in a table in SQLite. If the CREATE TABLE statement will fit in memory, then SQLite will

Re: [sqlite] authenticating user before allosw to use sql_lite?

Yahoo!? > Take Yahoo! Mail with you! Get it on your mobile phone. > http://mobile.yahoo.com/maildemo -- Met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] How to return only certain number of rows from a table in a select statement and not all the rows

Steve Frierdich wrote: Does anyone know what I need to add to a select statement so only certain number of rows will return? What would I add to a select statement query so only 10 rows from a table would return and not all the records in the table. Thanks Steve select * from table LIMIT 10

Re: [sqlite] SQLite Advocacy

ly don't do Microsoft bashing, but I could not resist this time. Bert Verhees

[Fwd: Re: [sqlite] How do I create a field with default current_timestamp]

sqlite> Insert into TemperatureData (tempt) values(86.0); sqlite> select * from temperaturedata; 40.2| 86|CURRENT_TIMESTAMP --- Begin Message --- Brass Tilde wrote: Create table TemperatureData ( Tempt real, TimeStamp default CURRENT_TIMESTAMP); Insert into TempertaureData values( 40.2,

Re: [sqlite] How do I create a field with default current_timestamp

Brass Tilde wrote: Create table TemperatureData ( Tempt real, TimeStamp default CURRENT_TIMESTAMP); Insert into TempertaureData values( 40.2, NULL); Try specifying the Tempt field and it's value only. SQLite may be interpreting the NULL as a supplied value and thus not inserting the

Re: [sqlite] add new column to table

ELECT firstname || surname AS > 'caller_name' FROM users WHERE extn_no = (SELECT extn_no FROM call_data)); > > I have missed something? The FAQ gives a working example, I used it a lot, please try that. Bert Verhees > > > > - Original Message - > From: "Lloyd Tho

Re: [sqlite] Error in Aducom components

s case would be, how to handle NULL-values in Integer-fileds with Typeless=false; It would be very handy if you would do that, because, I did not find that question, and the forum would become more valuable. Bert > > Bert Verhees wrote: > >Op zondag 9 januari 2005 01:29, schreef Ah

Re: [sqlite] Error in Aducom components

integer field, so there always is in integer in it, the other way is surrounding that specified action in a exception clause -- Bert Verhees

Re: [sqlite] Advice needed for a new group member

Op vrijdag 31 december 2004 02:23, schreef mike cariotoglou: > In the home page of www.sqlite.org there is a "contrib" link in the right > upper area. > It points to http://www.sqlite.org/contrib Thanks Bert

Re: [sqlite] Advice needed for a new group member

Op donderdag 30 december 2004 13:37, schreef mike: > When used correctly, sqlite is the fastest SQL engine I have seen (I am > also using D7). So, yes, it would be a good choice. > You need some API wrapper for sqlite, there are a few around including my > own :) (see contrib) Excuse, me, can

Re: [sqlite] Advice needed for a new group member

d it on: http://www.bcp-software.nl/artikelen/sqlite.html But it is easy to use regards Bert Verhees > Thanks in advance. > Ahmet Aksoy

Re: [sqlite] ODBC ADO

George Ionescu wrote: Hello Bert, have you tried using one of the ActiveX wrappers? I know it's not ODBC/ADO, but my wrapper (http://www.terrainformatica.com/sqlitedb) has at least an ADO-compatible interface, so that might help. I didn't want to write a full-blown ADO provider because this is

Re: [sqlite] ODBC ADO

e time. Thanks for your reaction regards Bert Verhees > SQLite components) > > Jonatan > > - Original Message - > From: "Bert Verhees" <[EMAIL PROTECTED]> > To: "SQLite" <[EMAIL PROTECTED]> > Sent: Friday, December 17, 2004 1

Re: [sqlite] ODBC ADO

Op donderdag 16 december 2004 16:17, schreef Clay Dowling: > Bert Verhees said: > > Does someone have experience with the ODBC-driver for SQLite3 in > > combination with the ADO layer in Delphi. > > I cannot get it to run, it stumbled about the isolation-level for > > tr

[sqlite] ODBC ADO

Does someone have experience with the ODBC-driver for SQLite3 in combination with the ADO layer in Delphi. I cannot get it to run, it stumbled about the isolation-level for transactions Thanks in advance for an answer Bert Verhees

Re: [sqlite] SQLite Tutorial - [Request For Comments]

a good internet-connection Very good job Thanks Bert Verhees > > I did notice that the document insists on displaying at about 20% wider > than my screen, causing lots of horizontal scrolling. > > My screen res is set to 1024x768. Workplace PC with IE 6.0 at full > screen. Printi

Re: [sqlite] Improving text search using LIKE '%string to search%'

on LIKE operator, if you want to do text searches, you better create an algoritm to use something like %word-list-index% You can do text searcha t the beginning of a string select. where text>=" aa" and text<="aa", it finds all words starting with aa, and uses indexes regards Bert Verhees

Re: [sqlite] question on speed - or what am I doing wrong

,'c:\zsike\!pika\proba.jpg','c:\mika\!pika\proba.jpg','mika.jpg','', >'','','admin','01.01.2003','12:30'); > > Fact 4: It took over a 20 minutes to execute this query and te2.db now > takes about 21,7MB. I've done it twice, to make sure. > > What do I have to do to make this faster? And reading? Please, give me a > concrete answer with examples if possible... > > Thanks in advance, > b -- met vriendelijke groet Bert Verhees ROSA Software

Re: [sqlite] OLE/DB provider for SQLite?

d I bought the source code from Marco Wobben, because he does not want to do some small changes I need. Regards Bert Verhees Best regards, ~Nuno Lucas

[sqlite] Firebird-SQLite conversion tool

You can find it and download for free: http://www.rosa.nl/Bold2/ It makes experimenting with SQLite in Bold/Eco (Borland) easier. kind regards Bert Verhees

Re: [sqlite] again on sqlite as a standard, was: SQLite and OOo

> These newly added features were long requested as well, and although > ALTER TABLE is indeed an important feature too, there are probably > other issues that require more attention right now. > > In any case, there is an entry on the FAQ section that shows you how to > do something like

Re: [sqlite] not supported keywords

D. Richard Hipp wrote: Bert Verhees wrote: Hello, Are there any plans in the near feature to implement the keywords EXISTS and ALTER TABLE? These to keywords/functions are very important when using SQLite in a MDA (Model Driven Architecture) where SQL-code is generated? There are plans to add

[sqlite] Bold and SQLite

pplication does not connect the Bold-controls to the database, which makes the application useless. I wonder, does someone have a clue, experience with this, or tips. Thanks very much in advance Kind regards Bert Verhees - To unsu

[sqlite] Re: Bold and SQLite

, column names are always reported as "TABLE.COLUMN" even for simple queries. - So I changed the DbXpress driver so that it does strip of the tablename, as Bold always executes joins with tablename but it seems to expect colum

Re: [sqlite] Is the DLL kept in RAM constantly?

are also possible in other development-environments. Bert Verhees - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Is using max(rowid) instead of count(*) safe?

PROTECTED] When you delete a row in between the rowid's will not be decremented, so it is only save when you never delete a row Bert Verhees - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [sqlite] a few questions about indexes

on, the index as suggested is not used, instead a tablescan is done and the lower is called as a function. Maybe your suggestion works in younger versions of SQLite, I don't know. Kind regards Bert Verhees - To unsubscribe, e-mail: [EM

[sqlite] Date Time, and now without make-up codes

ock Greenwich) thus in fact it is a time passed earlier, and the sort is wrong. What do you do with opcode IncrKey? It needs a complex indexing algoritm. IMHO timezones have to be handeld by the application before adding the time to a database, this keeps the database more quick. And m

Re: [sqlite] double email

system manager this way, instead of spending expensive bytes on finding which email I have to address. Thanks in advance for your consideration. Kind regards Bert Verhees Kind regards Bert Verhees > > -- > Richard Heyes > http://www.v-webmail.co.uk > > > ---

Re: [sqlite] double email

> Bert Verhees wrote: >> It would be nice if people would stop sending their emails twice to this >> list, and also would put off their read or deliver notification > > And learn to quote. And not top-post. > > -- Gerhard OK, I will not top-quote Will you stop sending

[sqlite] double email

It would be nice if people would stop sending their emails twice to this list, and also would put off their read or deliver notification thanks Bert Verhees > [EMAIL PROTECTED] wrote: >> Hi all, >> >> I'm trying SQLite with Zope > > You're using PySQLite, right? > &

Re: [sqlite] Performance tuning question

aybe there is a possibility to write SQLite-data to a memory cache to, and after finishing collecting data, write them to the database. Kind regards Bert Verhees > -Arthur > > > > - > To unsubscribe,