[sqlite] whish list for 2016

Hi, All! It would be desirable to improve algorithm of INTEGRITY_CHECK pragma. Presently it is generally useless for indexed databases which don't fit entirely in RAM (and which usually need checking much strongly than smaller ones). Valentin Davydov.

[sqlite] whish list for 2016

> On Dec 25, 2015, at 12:51 PM, Stephen Chrzanowski > wrote: > > *Part 2;* > > More along with your application style, but a complete database schema > overhaul, think of a contact form that allows for multiple methods of > communication. Multiple email addresses, multiple phone or fax

[sqlite] whish list for 2016

On 25 Dec 2015, at 12:39pm, Valentin Davydov wrote: > It would be desirable to improve algorithm of INTEGRITY_CHECK pragma. > Presently it is generally useless for indexed databases which don't fit > entirely in RAM (and which usually need checking much strongly than > smaller ones). Valentin,

[sqlite] Malloc getting segmentation fault in sqlite

Thanks for that. I do have a simple stdcall dll that sits in between my VB6 ActiveX dll and sqlite3.dll This does nil else than simply things like this: SQLITE3_STDCALL_API int __stdcall sqlite3_stdcall_column_count(sqlite3_stmt* pStmt) { return sqlite3_column_count(pStmt); } So, that takes

[sqlite] Malloc getting segmentation fault in sqlite

Thanks for clearing that up. I know all this has very little to do with SQLite, but people using SQLite with VB6 or VBA might be interested in this. What puzzles me that all is perfectly fine when the SQL statement has only one UDF in it, but there is a serious problem when there are two in that

[sqlite] whish list for 2016

On 25 Dec 2015, at 2:24am, John McKown wrote: > DELETE is normally done as: ALTER TABLE table-name DROP ?COLUMN > column_file_name; and would be a very nice addition. I hadn't noticed that > it is missing. I wonder why. SQlite stores all the data for a row together in column order. col1,

[sqlite] whish list for 2016

On 25 Dec 2015, at 2:35am, Bernardo Sulzbach wrote: >> ALTER TABLE table-name RENAME COLUMN column_field_name TO >> new_column_field_name; > > Are you sure? The documentation does not have anything about this and > I get a syntax error using 3.9.2 (a bit outdated, I know). John's confused.

[sqlite] whish list for 2016

On Fri, Dec 25, 2015 at 12:24 AM, John McKown wrote: > On Thu, Dec 24, 2015 at 4:09 PM, Christian Schmitz < > realbasiclists at monkeybreadsoftware.de> wrote: > >> Hi, >> >> better ALTER command would be very welcome. >> >> e.g. RENAME/DELETE column or field. >> > > RENAME exists. > > ALTER TABLE