Re: [sqlite] Problems adding a new column

* from Address PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Apostrophes in strings

ter (MySQL (and some others) are incorrect to use \' - those need escaping of the \ character as well, which isn't necessary with the proper SQL method) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

[sqlite] Is it possible to 'fix' a malformed database

of errors?) PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

RE: [sqlite] sqlite with Borland C++ 5.02

Is there a pre-compiled binary for that? Or do you just convert the .DLL to a .LIB with a utility? Paul -Original Message- From: nfr [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Borland C++ 5.02 Pigott

RE: [sqlite] sqlite with Borland C++ 5.02

Excellent. Thanks. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 3:03 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] sqlite with Borland C++ 5.02 Pigott, Paul wrote: > Is there a pre-compiled binary for that? Or do you just conv

RE: [sqlite] sqlite with Borland C++ 5.02

t;_sqlite3_open" instead of "sqlite3_open"). Based on the bit of reading I've done, does the .DEF file need to be changed around some on this as well? Again, thanks for everyone's help. Paul -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wedne

RE: [sqlite] sqlite with Borland C++ 5.02

cated in the dynamic link library sqlite3.dll." whenever I try to execute the code from the IDE. I've defined the project as STATIC, and I've got the LIB file defined in the Project window. I'm still confused, but now I'm confused in a different way. TIA, Paul -Original Message-

[sqlite] Sample code

oes anyone have a small example that I could refer to? I would greatly appreciate it. Thanks, Paul

Re: [sqlite] Sample code

Thanks, this is just what I was looking for. Paul - Original Message - From: "Clay Dowling" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 29, 2004 9:27 AM Subject: Re: [sqlite] Sample code > > Paul Pigott said: > > I'm putting t

[sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

abase is locked" errors without the timeout being honoured. I'm using sqlite 3.0.8 compiled for thread safety, running on Cygwin. Any clues gratefully received while I try this on some other platforms... Paul

Re: [sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

ppreciated! Paul

Re: [sqlite] expression syntax

) - easy to do, just use sqlite3_vmprintf instead to pick up the argument list. Paul

Re: [sqlite] download db - security question

to your database isn't shown in the downloadable website page source anywhere... PaulVPOP3 - Internet Email Server/Gateway [EMAIL PROTECTED] http://www.pscs.co.uk/

Re: [sqlite] SQLite Advocacy

Downey, Shawn wrote: I am trying to overcome the attitude of: "If SQLite is as good as you say, then why is it free?" and "If anyone can see the source code, then won't we be venerable to hackers?" Hi, I hope I may be of assistance in this area. I own my own company and we use exclusively open

Re: [sqlite] SQLite Advocacy

Fred Williams wrote: Politically, if you are in the organization that was "acquired", you best bite the bullet and learn to dance the Big Gates' version of "I Shall Overcome." I don't think there is a WinCE version of SQL Server, (yet) so that might be your only real chance. My experience with

[sqlite] sqlitebrowser - my db contains sql?

the tables, but they are empty, with no fields etc.. but in the "execute sql" tab i can query the database and get the data out correctly.. is this normal? is it just the way that sqlite stores the data?? am I forgetting a step in the creation of the databases? Paul.

[sqlite] Data race (file race) in pager

thread when the race occurs, unless it becomes obvious that the above functions cannot race. What is best way to provide these files? (attachments? upload to a website and provide a link?) Thanks, Paul ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Data race (file race) in pager

t released, but they will be once I have an interesting study. Thanks, Paul On 5 May 2012 06:14, Dan Kennedy <danielk1...@gmail.com> wrote: > On 05/04/2012 11:21 PM, Paul Thomson wrote: >> >> I am working on a tool that (among other things) can detect data >> races, including file acce

[sqlite] SQL Query - finding rows in a table that are not present in another

I have a couple of table seach of which has one column but millions of rows, the column is a text column. I need to return all of the rows in table B that are not present in table A What is the most efficient way of doing this? ___ sqlite-users mailing

[sqlite] Specifying a nullable column

column as "Foo null", and it works as expected allowing the column to contain null values. Is the syntax diagram simply out of date, or am I doing something that appears to work, but will bite me in the end? :) Thanks, -Paul ___ sq

Re: [sqlite] Specifying a nullable column

, -Paul On 11-Jun-2012 15:35, Kevin Benson wrote: On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski<pmedyn...@rim.com> wrote: Hi folks, I notice that the syntax diagram for 'create table' shows the 'column-constraint' definition as requiring 'null' to always be preceded by 'not'. I don

Re: [sqlite] Specifying a nullable column

On 12-Jun-2012 08:08, Richard Hipp wrote: On Tue, Jun 12, 2012 at 7:04 AM, Paul Medynski<pmedyn...@rim.com> wrote: Hi Kevin, I understand the 'NOT NULL' column constraint and the syntax diagram and text describe it quite well. What isn't described is whether or not specifying simply

[sqlite] SQLite Encryption Extension Performance?

Hi there, We are considering using the SQLite Encryption Extension in one of our products, and are wondering what the performance characteristics of it are?   Does the encryption algorithm affect performance?   Any stats on this you might have would be useful. Thanks! -Paul

[sqlite] Getting query results as new records are added

which may match our query.   We'd like update the query results view with new records as they're added, without having to repeat the whole query and weed out the results we're already showing? Any suggestions are appreciated. -Paul ___ sqlite-users ma

Re: [sqlite] IN operator hits

On 17 September 2012 17:23, E. Timothy Uy wrote: > Is there a way to figure out which of the terms in an IN operator > actually hit? Perhaps making a temp table is the only way. Any help Do you mean... SELECT DISTINCT col FROM tbl WHERE col IN ('a', 'b', 'c', 'd'); Regards,

Re: [sqlite] SQLite on flash (was: [PATCH 00/16] f2fs: introduce flash-friendly file system)

he memory because we know in what order our processes start & stop. But presumably you already have that issue in the mmap() version. Paul. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Document ommision bind-parameter description

There is a minor ommision on the BNF page of the database http://www.sqlite.org/docsrc/doc/trunk/art/syntax/all-bnf.html#bind-parameter In the expr section bind-parameter is a dangling hyper link Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

[sqlite] small website typo

https://www.sqlite.org/rtree.html has two sections numbered 3.3 Regards, Paul Paul Joyce Chief Technology Officer pjo...@we-do-it.com<https://mail2.we-do-it.com.au/owa/redir.aspx?C=e20caae2ed7b4b799a6203b19486e8d2=mailto%3apjoyce%40we-do-it.com> m: +61 450 066 131 www.we-do-IT.co

Re: [sqlite] Document ommision bind-parameter description

Ok Thank you Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 13 July 2016

Re: [sqlite] update or replace ...

On Thu, Jun 30, 2016 at 7:48 AM, Olivier Mascia wrote: > > Le 30 juin 2016 à 13:34, R Smith a écrit : > > > > MERGE dbo.xxx AS T > > USING dbo.yyy AS S > > ON T.SomeID = S.SomeID > > WHEN MATCHED AND T.ValueThatNeedsChanging = Oldvalue // or whatever > checking is relevant > > THEN UPDATE

Re: [sqlite] update or replace ...

On Thu, Jun 30, 2016 at 8:17 AM, Paul Egli wrote: > No chance for race conditions if data changes between the operations. > I should say "if data changes *or a read happens* between the operations. :-) ___ sqlite-users mailing list s

Re: [sqlite] Bad db feature request

of SQLite add checksums - and also add a corruption engine if he wants. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address

Re: [sqlite] Bad db feature request

As mentioned above there is (or can be) reserved space at the end of each page (documented in the DB header) that can be used for checksums - you just need to write your own extension :) https://www.sqlite.org/fileformat2.html Paul www.sandersonforensics.com skype: r3scue193 twitter

Re: [sqlite] trouble with sqlite .import

. Much appreciated. Aaron Paul kalisti...@yahoo.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] New tool for PUTTY logging [Windows]

You could make the CmdEntered field unique, or create a hash on the uppercase content of the command and make that a unique key. Then use INSERT OR IGNORE... Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

[sqlite] Documentation error

erpret the* byte* at offset X into the page as *an 8-bit* unsigned integer. Add the value of that integer to the checksum. 4. Subtrac*t* 200 from X. 5. If X is greater than or equal to zero, go back to step 3. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel

Re: [sqlite] Using Bitwise Logic In Query

How does this work for you to get all the even rows SELECT ROWID FROM table WHERE ROWID & 0x01 = 0x00 Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Too

[sqlite] converting unix10 and unix13 dates in the same column

087123 1234567890, 1432101234, ,1456754323012 any suggestions to achieve this approach? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for

Re: [sqlite] converting unix10 and unix13 dates in the same column

All sorted now thank you ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] converting unix10 and unix13 dates in the same column

ah OK - being dull thank you Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence

Re: [sqlite] Searching for a percent symbol

Brilliant thansks Dominique - I had completely misunderstood it :) Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address

Re: [sqlite] Searching for a percent symbol

Thanks Petite - I have already looked at that - but how? How do I search for a % symbol within a string when % is a wild card and I am escaping that very wildcard? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

[sqlite] Searching for a percent symbol

this (to search for 20% followed by a space followed by anything): SELECT * FROM Strings WHERE Strings.str LIKE '%20%% %' i got 20% of it I got 20 quid How casn I find just the rows containing the percent symbol? is it possible? Paul www.sandersonforensics.com skype: r3scue193 twitter

Re: [sqlite] Searching for a percent symbol

Thank you also Petite Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 5

Re: [sqlite] Order of fields for insert

of a table definition to avoid the same sort of overflow. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully

Re: [sqlite] Order of fields for insert

> Long columns, especially TEXT or BLOBs which may have lots of data in, should > go at the end. Because you don't want SQLite to have to fetch all that data > from storage just to get at the column after it. To be pedantic SQLite does not need to "fetch" all of the data from strorage before

Re: [sqlite] [WAL] Querying/Finding out the WAL size (in pages) without trying to checkpoint

would need to make sure your checkpoint was done in truncate mode: PRAGMA wal_checkpoint(truncate) WAL auto checkpoints are always passive so you would need to disable autocheckpointing and do all checkpoints yourself manually as above to ensure WAL is truncated. PRAGAM wal_autocheckpoint = 0 Paul

Re: [sqlite] [WAL] Querying/Finding out the WAL size (in pages) without trying to checkpoint

Please let me know if this works for you - I've never tried it so at the moment it's just an idea :) Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit

[sqlite] trouble with sqlite .import

Greetings, I’m importing a csv file into a newly created table with .import. One of the columns contain a numerical tag which sometimes resembles a date (example 08-17). These are not dates, but the .import is converting 08-17 into 17-Aug The odd thing is it is doing this even when the

Re: [sqlite] smartest way to exchange a sqlite3 database with another empty

database and how many records are added daily? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional

Re: [sqlite] Unable to create two indexes with the same name but on different tables

Sorry what is "very hard" about SELECT * FROM sqlite_master WHERE type = 'index' AND name = 'new_index_name' to see if the index already exists Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/conte

Re: [sqlite] Pragma to flag unknown pragma?

is returned when journal_mode is set). Likewise you can use pragma secure_delete to either set or query the secure_delete mode Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit

Re: [sqlite] Read-only access which does not block writers

Could you use PRAGMA data_version before and after each read to see whether there have been any changes to the DB - not surehow this works in WAL mode? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

Re: [sqlite] Read-only access which does not block writers

Steps 2 and 3 can be swapped Also you can convert an existing database from one mode to another (although not, I suspect (I have not tried), in the middle of a transaction and if in the DB is wal mode and you are changing to journal then this would force a checkpoint). Paul

Re: [sqlite] Issue with Malformed table

If you are unsucessful dro me an email - I might be able to help (not a commercial proposition - just may help me doing some testing with my code) Cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

Re: [sqlite] Changing ID's to UUID

On Wed, Nov 16, 2016 at 7:59 AM, Keith Medcalf wrote: > Using the systemid sequence and the recordid sequence directly however, > has a 0% probability of collision, so any rational person would use that > directly and forgo entirely the introduction of uncertainty and bugs

Re: [sqlite] Data loss during the disk full condition

I haven't seen anything to say what journalling is being used (Rollback, WAL or none). If the latter then SQLite will have nothing to revert to on error. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

Re: [sqlite] Foreign key child index question

On Tue, Dec 13, 2016 at 9:41 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 13 Dec 2016, at 3:20pm, Paul Egli <e...@sourcegear.com> wrote: > > > Why must SQLite find rows where the value is NULL? > > Because the related fields in the offspring row migh

Re: [sqlite] Date (from REAL) with Negative Year

for the ugly +2 Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 13 December 2016

Re: [sqlite] Foreign key child index question

On Wed, Dec 7, 2016 at 3:11 PM, Simon Slavin wrote: > > On 7 Dec 2016, at 8:40pm, David Raymond wrote: > > > Question on making indexes for the child fields of foreign keys. I have > a child table with a number of foreign keys on fields which the

Re: [sqlite] Foreign key child index question

On Tue, Dec 13, 2016 at 9:56 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 13 Dec 2016, at 3:53pm, Paul Egli <e...@sourcegear.com> wrote: > > > Well if i am missing something, i still cannot see it. > > > > Based on these quotes in the docs, i

[sqlite] Out of date online documents

While exploring the sqlite.org website for specific sqlite details I found the document at the URL below which is labelled as "draft" and appears to be from version 3.6.11. The latest release is 3.15 and I currently have version 3.13 installed. https://www.sqlite.org/sessions/sqlite.html .shell

Re: [sqlite] Out of date online documents

to the aggregate functions for "special commands" or "special functions" too. On Sat, Dec 31, 2016 at 2:52 PM, Richard Hipp <d...@sqlite.org> wrote: > On 12/31/16, Paul Lambert <eb30...@gmail.com> wrote: > > While exploring the sqlite.org website for specific

[sqlite] (dot) commands will execute from sqlite command line but not from query

On Linux with sqlite 3.13.0 installedI have successfully invoked the (dot) commands .system and .shell. Below are the results. In both instances the application at the target location launched as expected. (Ignore the Gtk message as it relates to the modal dialog box employed in the the

[sqlite] (dot) output call locks up when used on a named pipe

I have used the (dot) .output call in conjunction with a both a file and name pipe on Linux with Sqlite 3.13 installed. With a file this functions successfully and completes. When using a named pipe this functions locks up sqlite and it must be aborted for termination. I have observed that the

Re: [sqlite] (dot) output call locks up when used on a named pipe

ng and report back. On Sat, Dec 31, 2016 at 3:32 PM, Richard Hipp <d...@sqlite.org> wrote: > On 12/31/16, Paul Lambert <eb30...@gmail.com> wrote: > > I have observed that the file write mode of this function when using the > > same file name a second time will delete th

Re: [sqlite] BLOB sizes beyond 2GB?

a specific column. If the length is stored in the record itself then reading past a blob means that the first part of the blob itself needs to be read. Whether this would have any significant impact on speed for parsing serial types in general I don't know. Paul www.sandersonforensics.com skype

Re: [sqlite] BLOB sizes beyond 2GB?

the varints as unsigned integers, rather than signed as they currently are. This could be done (as far as I can see) for all varints other than the rowid without affecting existing DBs. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 18 March 2017 at 05:48, Rob

Re: [sqlite] Yet Another Why Doesn't Sqlite Use My Index question ...

Oops - somehow misread the last message - 54 seconds down from 32 minutes - that's a result! Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite

Re: [sqlite] column alignment of views and tables;

Just shooting out so no time to test. But could you try something like select substring('', 1, length(printf("%2.f", price))) || printf("%2.f", price) from prices Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44

Re: [sqlite] column alignment of views and tables;

oops you need to select the string length from the column width select substring('', 1, 16 - length(printf("%2.f", price))) || printf("%2.f", price) from prices Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

another oops I see Ryan pretty much posted the same as me 5 minutes earlier - I'll go back to bed :) Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

JulianDay(SubStr(Replace(dateplay.vi, '/', '-'), 1, 10)) < 365 THEN 'Under 1 year' END AS category FROM dateplay there may well be a neater way of doing it :) Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

dateplay Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 12 April 2017 at 13:13

Re: [sqlite] SQLite - Interrogate Date/Time field Statement question

Oops hit send too quickly the replace function replaces / with - in your date string to make the ISO 8601 and substr just makes sure we use the date portion only. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum

Re: [sqlite] Why isn't my time formatting working?

filetimes, chrome dates and NSDates/MacAbsolute very regularly. Interestingly I rarely see dates stored in ISO8601 format/text Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit

Re: [sqlite] Why isn't my time formatting working?

Oops - typo in my post above. Unix is of course secs since 1970. and Tim yes I too always use numerical dates - each to their own though - my post wasn't trying to say what is best, just what I see. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Non-unique columns in unique index

storage would be 8 bytes plus admin the chance of a random colliison based on a 64 bit hash would be (I think) 1:9,223,372,036,854,775,808 MD5 is broken but would work OK for this use a trigger to abort the insert into blah if the insert into hashes fails. Paul www.sandersonforensics.com skype

Re: [sqlite] Non-unique columns in unique index

Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 1 March 2017 at 22:13, Paul

[sqlite] Malformed databases and multithreading

Main question/comment: - On the "how to corrupt" page ( http://sqlite.org/howtocorrupt.html ) i do not see any mention of using SQLite in an incorrect way with respect to thread safety. Is there really no way that, for example, using the same connection on multiple threads at the same time

Re: [sqlite] Packing integer primary key with field bits

be given if we know the full table schema including typical sizes for data in any fields/ Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email

Re: [sqlite] Summarising (missing) values

That simple - I was over thinking it cheers Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional

[sqlite] Summarising (missing) values

What I would like is a single query that summarises the values that are present in (or missing from) a table. e.g. 334, 344 1077, 1297 1701, 1701 2385, 2386 2390, 2390 2393, 3336 Different approaches to this would be of interest Paul www.sandersonforensics.com skype: r3scue193 twitter: @san

Re: [sqlite] FOREING KEY constraint

pragma foreign_key_list(table_name) may help Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional

Re: [sqlite] syntax error near AS

The SQLite syntax diagrams are my first point of call when looking at an error in my code like this. https://sqlite.org/lang_update.html "AS" and an alias are clearly not part of the statement. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1

Re: [sqlite] Sqlite problem with opening database

Could your 32 bit app be picking up a 64 bit dll. Could you rename the dll's and hard code the location into your library? May not work for your release code but may help you narrow down the issue. Paul On Wed, 5 Jul 2017 at 18:19, Simon Slavin <slav...@bigfraud.org> wrote: > >

[sqlite] Document typo?

\ " pgsize INTEGER, /* Size of the page */" \ " schema TEXT HIDDEN /* Database schema being analyzed */" \ ");" Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Providing incrementing column to query

Actually I just need a unique number - but sorted in code now. Thank You Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work

[sqlite] Providing incrementing column to query

I Have a number of queries to which I want to supply an incrementing column, some of these queries involve without rowid tables. I have no control over the design of the tables. So for a table defined as: CREATE TABLE (name text, age integer) with values Steve, 34 Eric, 27

Re: [sqlite] Providing incrementing column to query

Hmm thanks Clemens Have written an extension to do it - some of my tables are very big and feel that the extension might be a better route. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite

[sqlite] NOT NULL integer primary key

constraint be obeyed? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence

Re: [sqlite] NOT NULL integer primary key

Ahh being dull and in a hurry thanks Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo

[sqlite] auntondex with unique and integer primary key

(3); The table is created and populated as expected, but an sqlite_autoindex_test_1 is also created with content that mirrors exactly the rowid/id. Is the autoindex redundant and is this an opportunity for optimisation? Using 3.18.0 Paul www.sandersonforensics.com skype: r3scue193 twitter

Re: [sqlite] auntondex with unique and integer primary key

index is built. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 19 May

Re: [sqlite] auntondex with unique and integer primary key

the autoindex to start with. Just a thought Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional

Re: [sqlite] auntondex with unique and integer primary key

Ahh - I always let SQLite decide what index to use as I assume that it knows best. I have never used "indexed by" to force the use of a specific index - I see the issue with backward compatibility now. Thanks Richard Paul www.sandersonforensics.com skype: r3scue193 twitter: @sanderson

Re: [sqlite] imposter tables

Thanks Richard I understand how it works, quite simple really, and knowing they are used by the RBU extension explains why. I am working on a book and I just wanted to understand how/where it could be used where a view, created on the same columns in an index, couldn't be. Paul

Re: [sqlite] imposter tables

Can you create an imposter table on a view. A view has no associated b-tree so I would think not! Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit

[sqlite] imposter tables

you exactly what is in the index, where the view is my interpretation of the SQL needed to show what is in the index. Is this the main benefit? or am I missing something? Are there instances where a view created as I have done above cannot simulate an imposter table? Cheers Paul

<    1   2   3   4   5   6   7   8   >