[sqlite] Reliable Multicast Programming (PGM) with ICS

Hi, Any plan to support Reliable Multicast Programming (PGM) for Window platform. Regards KL Chin

Re: [sqlite] Relative efficiency of joins, subselects, and union/intersect

> > > In my model, a 'song' record consists of a unique artist/album/title > > A 'tag' is a name/value pair associated with a 'song': > >Song: song_id artist album title > >Tag: song_id name value > > Searching for the tags associated with a given song would be pretty > > easy, but compl

Re: [sqlite] Relative efficiency of joins, subselects, and union/intersect

> In my model, a 'song' record consists of a unique artist/album/title > A 'tag' is a name/value pair associated with a 'song': >Song: song_id artist album title >Tag: song_id name value > Searching for the tags associated with a given song would be pretty > easy, but complicating matter

Re: [sqlite] Relative efficiency of joins, subselects, and union/intersect

Nathan Kurz wrote: Hello -- I've got a SQL problem that I'm guess is about half general and half SQLite specific. I'm pretty new to SQLite, familiar with basic SQL (mostly from MySQL), and I'm accessing SQLite through C and Perl. The problem I'm working on relates to tagging music for some music m

[sqlite] Relative efficiency of joins, subselects, and union/intersect

Hello -- I've got a SQL problem that I'm guess is about half general and half SQLite specific. I'm pretty new to SQLite, familiar with basic SQL (mostly from MySQL), and I'm accessing SQLite through C and Perl. The problem I'm working on relates to tagging music for some music management softwar

RE: [sqlite] feature request

> Reading the 'unsupported features page' there's a feature > request about allowing the + and - join syntax like oracle > has. It would allow more easy readable and writable queries > although I know it's not quite standard. SQLite used to have > this (I read) but has been removed. I think I'

Re: [sqlite] feature request

At 3:33 PM -0500 2/22/05, albert drent wrote: Reading the 'unsupported features page' there's a feature request about allowing the + and - join syntax like oracle has. It would allow more easy readable and writable queries although I know it's not quite standard. SQLite used to have this (I read)

Re: [sqlite] tricky date time problem

Thanks Jay/DRH, this looks more promising (The "%" operator gives you remainder after division). Still not sure how I could apply it to start and end unix times. The columns I have are :- hour start = start time of query for event (unix time) hour end = end time of quer

[sqlite] feature request

Reading the 'unsupported features page' there's a feature request about allowing the + and - join syntax like oracle has. It would allow more easy readable and writable queries although I know it's not quite standard. SQLite used to have this (I read) but has been removed. Albert Drent

Re: [sqlite] New to SQLite...............2....3

There is good PHP/SQLite introduction here: http://www.zend.com/php5/abs/php101-9.php Best regards, Witold - Original Message - From: "Jan Ekström" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 8:36 PM Subject: Re: [sqlite] New to SQLite...23 Is the code bel

Re: [sqlite] New to SQLite...............2....3

Is the code below the best way of making programs with SQLite? I don't want to use a command window. As you see I am new to SQLite. Not too knew I hope. jan "; /* sqlite_query($db,"CREATE TABLE exempel(fornamn char(20), efternamn char(20), alder int)"); */ sqlite_query($db,"INSERT INTO exempel

Re: [sqlite] sqlite_exec_printf and length modifiers

Tomas Franzén wrote: Hi, Does SQLite's sqlite_exec_printf function accept length modifiers, like printf from stdio does? It doesn't seem like it does, which is bad for me who want to insert 64 bit integers (using the ll modifier). If it doesn't, any other idea of how I can convert 64 bit integers

[sqlite] Are triggers atomic?

Are all operations in the trigger succeed or fail as a unit? Two updates for example. Or should I start the transaction before trigger firing? Best regards, Witold

Re: [sqlite] Feature request

--- Christopher Petrilli <[EMAIL PROTECTED]> wrote: > On Tue, 22 Feb 2005 08:58:45 -0800 (PST), Jay > <[EMAIL PROTECTED]> wrote: > > > > This is probably going to be hard but you did ask... > > > > SQLite version 3.0.8 > > Enter ".help" for instructions > > sqlite> create table x( a text ); > >

[sqlite] ADO.NET 2.0 Provider

I've created an experimental ADO.NET 2.0 provider for SQLite and updated the WIKI page with the link. Now if I can just get real_column_names incorporated into the core codebase!! :) http://www.blackcastlesoft.com/files/sqlitereadme.htm Robert Simpson Programmer at Large

Re: [sqlite] Feature request

On Tue, 22 Feb 2005 08:58:45 -0800 (PST), Jay <[EMAIL PROTECTED]> wrote: > > This is probably going to be hard but you did ask... > > SQLite version 3.0.8 > Enter ".help" for instructions > sqlite> create table x( a text ); > sqlite> insert into x(a) values('one'); > sqlite> create view y as sele

[sqlite] Feature request

This is probably going to be hard but you did ask... SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table x( a text ); sqlite> insert into x(a) values('one'); sqlite> create view y as select a from x; sqlite> select * from y; one sqlite> insert into y(a) values('two'); SQL err

Re: [sqlite] ANN: ASQLite3 components for SQLite3.1.x released

I think you should post this in the components support forum, but yes it's supported. To achieve this you can add the order by ... to the filter property. This also goes for having and group by, the sql is added to the generated sql. albert Quoting Serge Liber <[EMAIL PROTECTED]>: > Hi, > > Is s

Re: [sqlite] New to SQLite...............2

Hi Jan, Jan Ekström wrote: I am using Windows Home Edition. I think the SQLite cammand shell is the same as windows command shell. The SQLite command shell is the sqlite.exe or sqlite3.exe file that you can download from the "Precompiled Binaries for Windows" section of the SQLite download page:

Re: [sqlite] ANN: ASQLite3 components for SQLite3.1.x released

Hi, Is sorting of the resultset of TASQLiteTable still under development? Serge Liber > Today we released a new version of the Delphi / BCC components for SQLite 3.1.x. > It has some enhancements, but more important it fixes the incompatibility with > the latest sqlite.dll. > > Components can

Re: [sqlite] New to SQLite...............2

I am using Windows Home Edition. I think the SQLite cammand shell is the same as windows command shell. jan - Original Message - From: "Cory Nelson" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 3:47 PM Subject: Re: [sqlite] New to SQLite. Try the SQLite command shell. On Tue,

Re: [sqlite] tricky date time problem

--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > > It's too bad Sqlite doesn't have the modulo operator, > > The "%" operator gives you remainder after division, > which is very close to being a modulo operator. Thanks! I went looking for the page in the documentation about expressions to

Re: [sqlite] New to SQLite.

Try the SQLite command shell. On Tue, 22 Feb 2005 14:22:28 +0100, Jan Ekström <[EMAIL PROTECTED]> wrote: > Is there a best way to administrate SQLite? > Do I use PHP, TCL C or .? > Sincerely > Jan Ekström > > -- Cory Nelson http://www.int64.org

[sqlite] ANN: ASQLite3 components for SQLite3.1.x released

Today we released a new version of the Delphi / BCC components for SQLite 3.1.x. It has some enhancements, but more important it fixes the incompatibility with the latest sqlite.dll. Components can be found on sqlite.aducom.com albert drent

Re: [sqlite] tricky date time problem

Is there a best way to administrate SQLite? Do I use PHP, TCL C or .? Sincerely Jan Ekström - Original Message - From: "D. Richard Hipp" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 2:18 PM Subject: Re: [sqlite] tricky date time problem On Mon, 2005-02-21 at 18:00 -0

[sqlite] New to SQLite.

Is there a best way to administrate SQLite? Do I use PHP, TCL C or .? Sincerely Jan Ekström

Re: [sqlite] tricky date time problem

On Mon, 2005-02-21 at 18:00 -0800, Jay wrote: > It's too bad Sqlite doesn't have the modulo operator, The "%" operator gives you remainder after division, which is very close to being a modulo operator. -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] tricky date time problem

//-- // Calculate Day name from datetime value //-- void ModFunc( sqlite3_context *context, int argc, sqlite3_value **argv ) { // retrieve first parameter long l = sqli

Re: [sqlite] SQLite vs MySQL

Richard Nagle wrote: Have a few question regarding sqlite ; 1. what standard is the current sqlite using: "92" or SQL:2003 ? http://www.sqlite.org/omitted.html 2. how does sqlite compare to mysql in the pro's and con's, another words, what major benefits would we get using sqlite over mysql? http:/

Re: [sqlite] 2 question about SQLite types

> 1. > SELECT TYPEOF(ROUND(1)); > ... returns 'text'. Is it OK? Sorry, I asked this question 2 days ago but I > still don't know - is it a bug or not? I don't think this is a bug, round() returns objects of type text. As well as rounding to integers, round() can also round to a fixed number of d

Re: [sqlite] tricky date time problem

Jay, --- |You could select and group by the modulo of the seconds of each| |date and get your nice groupings very simply. If you can write a| |user defined function in whatever language you're using | |you might try