Re: [sqlite] AUTO INCREMENT

Hi Kevin, You could also query the table or view but don't return any rows. If you set the option to get the column types in the resultset this should do what you want . AN example of what I am trying to say would help :) PRAGMA show_datatypes = ON; select COl3 from tablename where 0 = 1 The

[sqlite] Read receipt requested.

Sorry guys I didn't turn off read receipt on my email. Please don't send me one. regards Greg O

[sqlite] Web Database Manager for SQLite

Hi Everyone, Does anyone have a web based database manager for SQLite Databases? I thought I would ask before starting one regards Greg O

RE: [sqlite] Web Database Manager for SQLite

Hi Kevin, Means I will have to wait for my Hosting service to upgrade to PHP 5 (which will happen just after those pig start flying backwards) Anyway thanks for the link. It gives me a good example to work on. Kind regards Greg O -Original Message- From: Kevin Waterson [mailto:[EMAIL

RE: [sqlite] Web Database Manager for SQLite

ssage- From: Darren Duncan [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 October 2003 4:06 AM To: Greg Obleshchuk Cc: SQLite Subject: Re: [sqlite] Web Database Manager for SQLite At 3:54 PM +1000 10/21/03, Greg Obleshchuk wrote: >Hi Everyone, >Does anyone have a web based database manager

[sqlite] Little issue with indexes

Hi All, I just noticed a little issue with the indexes nad there name. When you create an index like this create index [Customers-CompanyName] on Customers (CompanyName) The name of the index in sqlite_master is [Customers-CompanyName] yet when you creqate a table like this create table [Test

[sqlite] SQLite in Web application

Hi Everyone , I would like some opinions from anyone with experience in this area. I am thinking of replacing the MS SQL Server backend to my web site with a few SQLite databases. I use the database backend to record purchases and store client information. I also record things like software p

[sqlite] New version of SQLite Wrapper for .NET

Hi All, I have updated my SQLite Wrapper for .NET . It is now version 1.1.0 In this update I coded in a loop around the execute statement to handle SQlite_busy situation. After reading the wiki page http://www.sqlite.org/cvstrac/wiki?p=MultiThreading I followed the example. This should make it

[sqlite] .NET Wrapper for SQLlite

Hi, I found an issue (bug) with my .NET wrapper for SQLite. The issue was if you issue this statement PRAGMA empty_result_callbacks = ON;select * from test and the test table has no rows then the wrapper crashes. I have fixed this issue The version is now 1.1.1 regards Greg O

Fw: [sqlite] Checking the busy state

Hi Dennis, I have just done some work on this. Take a look at this wiki page http://www.sqlite.org/cvstrac/wiki?p=MultiThreading The lock is only help while updating. If you follow the instructions in the above page Updates in transactions and you add a loop like the one in the solution then

Re: [sqlite] Checking the busy state

d rather just give a message to the user that the db is locked and ask him to come back later than to wait and process that query. And I wish to update user B's db display after A has finished working with the db (I'm thinking of using mailslots for that). Dennis - Original Mes

[sqlite] Where statements are they case sensitive?

Hi All, I just checked something and noticed that the WHERE statement is case sensitive. I have check this in SQL Server and it is not case sensitive. I am using 2.8.5 and 2.8.6. As an example in the northwind DB I have for SQLite . There is a table called Orders select * from sqlite_master wh

Re: [sqlite] Where statements are they case sensitive?

I checked a few systems and there doesn't seem to be a standard. As was said Oracle is case sensitive but all the Microsoft products I check SQL, Access , MS Query where all case insensitive. I think a PRAGMA would be a great idea for this. What do other people think? Using a like (which

Re: [sqlite] commercial usage of sqlite

Hello, I am curious about what problems the lawyers have (apart from being a lawyer that is) with SQLite being used in a commercial product. I read the line "No indemnity comes with it" which is a very funny statement. Funny because I don't know of any third party (third party to your project)

Fw: [sqlite] Performance problem

Sorry Richard I meant to send this to the group Hello, Last week I raised an issue about case sensitivity in where clauses. In doing a little research I happened to talk to an Oracle DBA here where I work and asked him the question of how Oracle handled case sensitivity . He explained it is ha

[sqlite] SQL92

Hello, Does anyone have a web link to a document that details SQL92. regards Greg O

[sqlite] charindex function

Hello, I have finished a charindex function for sqlite (which is attached to this email).  When I say finished I have done the Non SQLITE_UTF8 work.   charindex give the starting position of a specific _expression_ in a string.   charindex (StringtoFind, ReferenceString,startingpos)   Can an

[sqlite] Left field question about non windows platforms

Hi , This may seem like a question un-related to SQLite but there is a link. On Windows platform to dynamically load a DLL into your program you use LoadLibrary and GetProcAddress to get the reference to an exported function in the DLL. My question is how do non Windows platforms do this? reg

[sqlite] New function for SQlite

Hi, I have just finished an SQL function for SQLite which will allow to call exported function form a Win32 DLL. This is an example of the calling syntax update UserPassword set Password = se_fn("mydll_01","Encrypt",'NewPassword'); or select se_fn("mydll_01","Encrypt",[Message]) from UserMess

Re: [sqlite] Performance tuning question

Hi Arthur, It's very quite here , for some reason (has been all week). Can you tell me a bit more about you inserts are they in separate batches? or one big batch. I have noticed performance issues with in-memory DB when doing lots on little batches , but I would have thought it would be consta

[sqlite] Is there a problem with this list?

Hello, Just wondering if there is a problem with this list. regards Greg

[sqlite] Improving concurrency in SQLite

Hello, I read your paper and it was interesting. I am an advocate for improving the speed of SQLite where ever possible and after reading your paper and applying the experiences of using MS SQL server these are my thoughts. 1. All transactions should be Read Only (no locking) with an option to t

[sqlite] SQLite Administration web application

Hello, for anyone who is interested I have placed an application on sourceforge to manage SQLite database from you web site. This is an ASP.NET application . At the moment you can manage databases and table objects. There is a query form and a table wizard form which allows you to data enter i

re: [sqlite] .NET sqlite wrapper

Hi Richard, Have you placed it on the wiki yet. I added a .NET section with three other native .NET wrappers for SQlite? You should place an entry there if you haven't yet. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards Greg O - Original Message - From: Richard Heyes

re: [sqlite] Network Performance

Hi Brian, I few things. The problem is your network speed compared to local disk speed (also distance is an issue as well) Disk transfer is in Mega bytes where as network IO is in mega bits. SO while IDE standard 33.3MB looks slower than 100mb for your network (even switched) it is in fact sl

RE: [sqlite] Field name

Hi, Des that mater? If it does then just un=quote them by removing the first char and lasts Kind regards Greg O -Original Message- From: Bronislav Klucka [mailto:[EMAIL PROTECTED] Sent: Thursday, 27 November 2003 8:42 PM To: SqLite Konference; Greg Obleshchuk Subject: RE: [sqlite

Re: [sqlite] Is case sensitivity a problem for me only?

Hi Steve, I agree with you completely. As I understand it though from a speed point of view case sensitive compares are much quicker, this may be one reason they are used? Maybe there could be a PRAGMA setting PARGMA case_sensitive=ON; PARGMA case_sensitive=OFF; That would be a nice option re

RE: [sqlite] need faster count(*)

Hi, No the process must count all the rows. The ROWID value is generated when a new row is inserted but if you delete rows the last rowid will not be the same as the count of rows. If you have an index on the primary key and count that then it will run as quickly as possible. Regards Greg -

[sqlite] TCL.h File missing from sqlite_source.zip

Hi, I have just downloaded the sqlite_source.zip file for MS-Windows and there seems to be a file missing TCL.H . Anyone have any ideas where it went? regards Greg O

[sqlite] .NET Assembly and VB Wrapper

Hello, I have updated my .NET Assembly and VB Wrapper for SQLite to support version 2.8.9. Both can be downloaded from http://www.ag-software.com/SQLite.aspx .NET Assembly Changes None VB Wrapper changes Introduced a new function called ags_number_of_rows_from_last_call, which as the name sugge

RE: [sqlite] .NET Assembly and VB Wrapper

Hi Markus, Can I see your code where the wrapper crashes . I have done some test with read-only directories and I don't get any crashes. Regards Greg O -Original Message- From: Markus Huhn [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 5:17 PM To: Greg Obleshchuk Cc: S

RE: [sqlite] AGS_SQLite_Wrapper VB

Hi, The returned result is a variant array. You move through a array as you normally do, by increasing a index counter. You can write a class around any array to emulate an ADO recordset if you want. Regards Greg -Original Message- From: ISA Programmi [mailto:[EMAIL PROTECTED] Sent: Su

RE: [sqlite] web-based admin utilities

Hi, I've done one in VB.NET and it's here http://sourceforge.net/projects/dotnetsqliteadm/ Regards Greg -Original Message- From: Wade Preston Shearer [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 January 2004 6:01 AM To: [EMAIL PROTECTED] Subject: [sqlite] web-based admin utilities Is

[sqlite] New wiki page for Performance Tuning

Hi All, I just created a new wiki page off the wiki home called PerformanceTuning. I have started to place clipets from emails in the group which relate to making queries or DB operations run quicker. Please add your bits and pieces http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuning regar

Re: [sqlite] How to link under Windows

Erik, You will need to use one of the .Net Wrappers or the .NET data providers. http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers regards Greg O Erik Jälevik wrote: I'm just about to write some code using SQLite from Visual Studio .NET under Win XP. I am however, not sure how I go about linking

Re: [sqlite] Best method to create a database with a tree structure?

Hi Martin, You are talking about standard Parent/Child relationships here but because you have unlimited number of entries you fold it into one table and have a Parent_ID column. So if you have your required details as being these columns Name SomethingElse Then a standard table might be Nam

Re: [sqlite] Query optimization help

Hi Richard, try this SELECT DISTINCT p.poster_id AS has_posted, t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to FROM topics AS t , p

Re: [sqlite] OK to drop support for legacy file formats?

Hello, Why not remove the feature but create a seperate utility project that converts any version of SQLITE DB to the latest version. In this way SQLite can be just what it is small and fast. There would be a tool from the orginal source which you would know would work and simple to use. The cur

Re: [sqlite] Primary key and index

Bertrand, This is from the doc on the web Specifying a PRIMARY KEY normally just creates a UNIQUE index on the primary key. However, if primary key is on a single column that has datatype INTEGER, then that column is used internally as the actual key of the B-Tree for the table. This means th

[sqlite] Re: [inbox] Re: [sqlite] Primary key and index

an index on the a column if it is an autonumber(identity ) column if I was using this column in joins or where clauses. regards Greg - Original Message - From: Michael Hunley To: Greg Obleshchuk Sent: Tuesday, February 10, 2004 6:49 AM Subject: Re: [inbox] Re: [sqlite

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

m? I just want to do some reading on it. regards Greg - Original Message - From: Williams, Ken To: 'Greg Obleshchuk' ; Michael Hunley ; [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 7:47 AM Subject: RE: [sqlite] Re: [inbox] Re: [sqlite] Pr

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

RS , Product_Description where ORDERS.Product_ID = Product_Description.ROWID regards Greg - Original Message - From: Williams, Ken To: 'Greg Obleshchuk' ; [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 9:06 AM Subject: RE: [sqlite] Re: [i

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

Greg - Original Message - From: D. Richard Hipp To: Greg Obleshchuk Sent: Tuesday, February 10, 2004 9:29 AM Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index Greg Obleshchuk wrote: > > Select * , Product_Description.ProductName

Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index

Thanks for clearing that up Greg - Original Message - From: D. Richard Hipp To: [EMAIL PROTECTED] Sent: Tuesday, February 10, 2004 11:52 AM Subject: Re: [sqlite] Re: [inbox] Re: [sqlite] Primary key and index Greg Obleshchuk wrote: > > So in these cases there

Re: [sqlite] Database Full!

Hello, Could you open a memory database and then attach the disk based database. Create the tables in the memory database and copy the rows from the disk based into memory. Once done detach the database , delete it from disk . Then create a disk based database , close it and attach it to the memor

Re: [sqlite] Changing a Field

Brian, Can you be a bit more specific? You have the case expression which allows you to return values depending on other values http://www.sqlite.org/lang.html#expr something like case Col1 when 1 then 'happy' when 2 then 'sad' so this could be wrapped up like update table1 set col2 = case Col

Re: [sqlite] Select statements returned column names

Hello, This is an important question which needs to be considered well. I personally don't care either way but if a decision is to be made it should be for standardisation Can I ask this question, is it a problem only for the people using a wrapper or is it a problem for people using the API inte

Re: [sqlite] A puzzling SQLite slowdown

Hello, Richard, I thought that after a transaction SQLite opened and closed the DB anyway and that was one of the main reasons for using a transaction where many separate updates are taking place it cuts down the opening and closing so only one occurs? This problem might be an index problem? Kind

[sqlite] Bad Database file

Hi, I just checked a database which was giving me problems using PRAGMA integrity_check; and discovered it was corrupt. sqlite> PRAGMA integrity_check; *** in database main *** List of tree roots: invalid page number 24 List of tree roots: invalid page number 23 What would be the reasons for a da

[sqlite] RMemory database from 2.8.9 to 2.8.13

Hi , I have an appllication for MS SQL Server which creates crosstab reports . To generate some extra speed out of the process I use SQLite (funning I think) as an in memory database. Has there been any improvements in speed or stability of the :memory: database since 2.8.9? I just want to know if

Re: [sqlite] which files to compile...

Hi Peter, Which OS are you using? I have the latest compiled LIB for Windows on my system I could send you. regards Greg - Original Message - From: "Peter Lau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 12, 2004 8:16 AM Subject: [sqlite] which files to compile... >

[sqlite] SQLite quite popular

Hi Guys, I just wanted everyone to know that SQLite is a very popular piece of software. I don't what Dr R stats are on downloads but from my site (I have two SQlite Wrappers), in the past 10 days I have had 290 downloads. The SQlite pages out hit any of my other pages on my web site, 4000 - 5

[sqlite] Information Schema Views

Hello All, I have created a new wiki page off the main wiki page called Information Schema. Here is the link http://www.sqlite.org/cvstrac/wiki?p=InformationSchema The SQL standard INFORMATION_SCHEMA views are a standard way of retrieving schema information from any SQL standardised database.

[sqlite] Search results

Hi Everyone, This is a tiny bit off subject, so sorry. I have a search page on my web site which when used will search the database for results. I want to be able to rank the results in best match first order. In the database I will have three columns where I will be searching for matches , my

Re: [sqlite] Re: SQLite Logos?

I love that logo! - Original Message - From: D. Richard Hipp To: Karl Timmermann ; [EMAIL PROTECTED] Sent: Sunday, March 28, 2004 9:36 AM Subject: [sqlite] Re: SQLite Logos? Karl Timmermann wrote: > > Do you know of any "Powered By SQLite" type logos that might exist,

Re: [sqlite] Re: SQLite Logos?

see what a darker image part does, it highlight the mean (in terms of mySQL the freedom ) In terms of the SQLite the feature is obviously the Lite indicating light footprint ) Anyway I think it's a great. Greg - Original Message - From: Allan Edwards To: 'Greg Obleshchuk

[sqlite] Group by behavour

Hi All, Has anyone noticed this? Try this query select tbl_name from sqlite_master group by tbl_name Now try this query select tbl_name from (select * from sqlite_master) group by tbl_name The same results should be displayed but only one row is displayed. This also affects group by when usin

[sqlite] va_list

Hi , Can anyone tell me if you can manually create a va_list object. I have in my wrapper now the sqlite_vmprintf function but as .NET doesn't support the ... as a parameter I had to use a [ParamArray] . Currently I am testing the number of parameters passed and calling sqlite_vmprintf differe

Re: [sqlite] va_list

sqlite_vmprintf with one parame , if two it calls it with two and so on. If I could build a va_list then I would built it and just call sqlite_vmprintf once. anyway thanks Greg - Original Message - From: Christian Smith To: Greg Obleshchuk Cc: [EMAIL PROTECTED] Sent: Thursday

[sqlite] Group by only returning one row when source table is sub-query or view

Hi , I posted a bug ticket a few days ago (ticket 678) regarding group by only returning one row if the source was a subquery or view. I was wonder if anyone could confirm the bug and how long would a fix take? (I'm not in a position to create a fix) http://www.sqlite.org/cvstrac/tktview?tn=67

Re: [sqlite] Group by only returning one row when source table is sub-query or view

table, which is slow. Greg. - Original Message - From: D. Richard Hipp Cc: [EMAIL PROTECTED] Sent: Friday, April 02, 2004 8:28 AM Subject: Re: [sqlite] Group by only returning one row when source table is sub-query or view Greg Obleshchuk wrote: > > I posted

Re: [sqlite] A proposal for SQLite version 3.0

Hello, I just read the proposed changes and they seem fine. A couple of thing. The data types I think are great but can we have a large and small integer? I noticed some people (embedded systems people) complain about this. I quite happy with the large type but as integers will now be store

Re: [sqlite] A proposal for SQLite version 3.0

Hi Will, Thanks for clearing that up for me, it make more sense now. Greg - Original Message - From: Will Leshner To: Forum SQLite Sent: Monday, April 12, 2004 8:06 AM Subject: Re: [sqlite] A proposal for SQLite version 3.0 On Apr 11, 2004, at 3:01 PM, Greg Obleshchuk

Re: [sqlite] A proposal for SQLite version 3.0

I think the collate feature will solve this. have a pre-defined collate TEXT_CI is the solution. One thing Microsoft allows you to do is create a database with a defined collation. Maybe this is the idea around the parameters in the open API . You could open a DB with COLLATION TEXT_CI and

[sqlite] New Web site

Hi Everyone, (I know this is off subject) I have finished a new web site dedicated to SQL Scripts for database system. I am looking for people to lodge there useful (and not) scripts onto the system . If you are looking for scripts try here first. There some useful stuff like the SQL-99 stan

Re: [sqlite] New Web site

: Greg Obleshchuk To: [EMAIL PROTECTED] Sent: Monday, April 12, 2004 8:53 AM Subject: [sqlite] New Web site Hi Everyone, (I know this is off subject) I have finished a new web site dedicated to SQL Scripts for database system. I am looking for people to lodge there useful (and not

Re: [sqlite] Adding SQL commands

Hi Basil, The first use of IF is same syntax as the case statement so I don't think it is required and as IF isn't SQL92 I doubt it will be included so your command is replaced by case when (select count(*) from foo) = 100 then 'good' else 'bad' end I like the idea of exist but then again you

Re: [sqlite] row size limit

Hi Richard, You know that is the first clear and concise explanation of why not to store large blobs in a database that I have heard anywhere. Greg - Original Message - From: D. Richard Hipp Cc: [EMAIL PROTECTED] Sent: Monday, April 19, 2004 9:50 AM Subject: Re: [sqlite] row

Re: [sqlite] row size limit

don't. Greg - Original Message - From: Puneet Kishor To: SQLite Sent: Monday, April 19, 2004 10:41 AM Subject: Re: [sqlite] row size limit On Apr 18, 2004, at 7:31 PM, Greg Obleshchuk wrote: > Hi Richard, > You know that is the first clear and concise ex

RE: [sqlite] sqlite with Visual Basic

Carlos, No you can't the call-back API and the API that’s returns a C style array aren't supported in VB Regards Greg > -Original Message- > From: Carlos Garces [mailto:[EMAIL PROTECTED] > Sent: Friday, 14 May 2004 6:00 AM > To: [EMAIL PROTECTED] > Subject: [sqlite] sqlite with Visual

RE: [sqlite] sqlite with Visual Basic

Hi Carlos, Sorry mate I didn't point out the wrappers on Sqlite.Org http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers Greg > -Original Message- > From: Jalil Vaidya [mailto:[EMAIL PROTECTED] > Sent: Friday, 14 May 2004 11:13 AM > To: Carlos Garces; [EMAIL PROTECTED] > Subject: Re: [

RE: [sqlite] sqlite with Visual Basic

O, RDO and XML. You can pragmatically send it a array and bind to that. With the ODBC driver, I'm not a big fan of installing drivers (ODBC) during setup or supplying them with the application. That's why the wrapper I wrote doesn't use them. A & G Software Qual

RE: [sqlite] Sqlite Secure backup

Hi David, I have been thinking about developing a backup/restore as part of my wrapper. It would be great to have all of these features compatible. I really wanted to backup the database and then have the ability to restore just one table or the entire DB. What do you think? Maybe we should cr

[sqlite] ISO 8859

Hello, I had this guy email me about a problem about using ISO8859 character . He has this in the DB Handhilfsbetätigungssatz but when queried using my wrapper it returns Handhilfsbet..tigungssatz When using SQLITE.EXE the results are displayed fine. When I debug the code the char * returned