[sqlite] Introduction

Hello. I've just joined this list, so an introduction may be in order. I'll follow up with a "real message" separately. I work in IT Services at UCD, Ireland's largest university. While there, I've worked with OS/360, TOPS-20, VM/370, VMS, SunOS (before it became Solaris), and Linux, to

Re: [sqlite] Bug hunting in SQLite

Thank you for all your support. Thank you, Roger. You pointed out the most likely error: I didn't set the sqlite-task to exclusively use the connection when reading from the database, only when writing. I used a share lock when reading. Thank you, Teg. You made me confident with having large

[sqlite] IPv{4,6} addressing extension

Hello. For a current project, I need an extension to SQLite which supports IP addresses and routing/subnet prefixes. Before I start building one, I'ld be glad to learn of any that are out there, other than those mentioned at either of the following URLs:

Re: [sqlite] FTS simple tokenizer

Thanks Dan. Have just checked how to report bug, and apparently we already have :) Please excuse the brevity -- sent from my phone On 27 Feb 2012, at 07:06, Dan Kennedy wrote: > On 02/27/2012 05:59 AM, Hamish Allan wrote: >> The docs for the simple tokenizer >>

Re: [sqlite] IPv{4,6} addressing extension

You can use integer representation of IPv4 addresses as your "internal format" for sorting and sumilar tasks: SELECT IP2INT('0.0.0.0'); ==>0 SELECT IP2INT('192.168.1.1'); ==>3232235777 SELECT IP2INT('255.255.255.255'); ==>4294967295 The integer

[sqlite] transaction when storing large and many files

I have a .NET C# application that is using System.Data.SQLite. The application goes through a filesystem and extracts file names, builds md5sums on every file and builds up a database. Reason behind is, to reduce the number of duplicates. The files as a tar file sum up to 66 GB. It's about a

Re: [sqlite] IPv{4,6} addressing extension

On 27 Feb 2012, at 10:51, Alexey Pechnikov wrote: > You can use integer representation of IPv4 addresses as your "internal > format" for sorting and sumilar tasks: Thanks, Alexey. I know that, but it's an approach which fragments the problem which I very much want to

[sqlite] Problem compiling the c source produced by lemon

I compiled lemon with no problem and input the grammar file as stated in http://souptonuts.sourceforge.net/readme_lemon_tutorial.html. But when i compile the c source file produced by lemon i am encountering errors; syntax error : ':' from cstdio. What is the solution for this. Thanks.

Re: [sqlite] SQLite, portable, image store

> Hi > I would like some help to use SQLite as a general information resource > on my pc's. > I would like to use open source software but will consider proprietary > software. > Even better would be portable software, I could take all my photos and > the means of searching them on a disk drive.

Re: [sqlite] FTS simple tokenizer

It was reported before (and not solved) http://www.mail-archive.com/sqlite-users@sqlite.org/msg55959.html > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Hamish Allan > Sent: maandag 27 februari 2012 11:27 > To:

[sqlite] Determining end locations of phrase matches in FTS3/4

Hi, I can use the offsets() function to determine the start locations of phrase matches, but is there any straightforward way to determine the end locations? CREATE VIRTUAL TABLE test USING fts4(); INSERT INTO test VALUES ('i am what i am'); SELECT offsets(test) FROM test WHERE content MATCH

Re: [sqlite] Determining end locations of phrase matches in FTS3/4

On 27 February 2012 17:11, Hamish Allan wrote: > > -- what I want to determine is the full range of the phrase match: (0, 14) Sorry, correction: I want the full range*s* of the phrase match: (0, 4) and (12, 4). H On 27 February 2012 17:11, Hamish Allan

Re: [sqlite] SELECT average timestamp to get average time of day?

On Fri, Feb 24, 2012 at 4:53 PM, Marc L. Allen wrote: > You're trying to calculate it for individual people? Can you count on > night-time people to stay night-time, or do you need to worry about someone > shifting by 12 hours? > It's for individuals, and it is

Re: [sqlite] RE SELECT average timestamp to get average time of day?

On Sat, Feb 25, 2012 at 8:44 AM, Black, Michael (IS) wrote: > I subtract 12 hours...so any time from 24:00:00 to 12:00:00 will work. > > Time from noon to noon becomes midnight to midnight. Then you just add > the 12 hours back in. > > > > CREATE TABLE tijd(t int(11));

[sqlite] perl parameter binding by name

I'm trying to figure out how to bind parameters by name (:VVV or @VVV or $VVV ) using the DBI Perl module. I can't find any examples. All the bind_param methods look like they want a param num ($p_num). Maybe some %attr's need to be set? I want to be able to use SQL like this: $sql =

Re: [sqlite] Problem compiling the c source produced by lemon

On 26 February 2012 04:17, Everard Mark Padama wrote: > I compiled lemon with no problem and input the grammar file as stated in > http://souptonuts.sourceforge.net/readme_lemon_tutorial.html. But when i > compile the > c source file produced by lemon i am encountering