[sqlite] Re: SQLite and Columnar Databases

At 6:59 AM +0530 12/18/07, Yuvaraj Athur Raghuvir wrote: Thanks for the interesting discussion. What I got so far is summarized below: 1) Row based versus Column based storage is an implementation detail. 2) SQL used for access is independent of storage mechanism adopted. 3) Row based storage

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

Went south in a rush. Agreed. BTW, I can drive a forklift, and a back hoe... Fred > -Original Message- > From: James Steward [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:43 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite. Anyone

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

It's the ones who never figure out how little they know that do all the damage... Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:22 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite.

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDeviceSQL?

There you go! Thinking like an engineer (logical) and not management :-) I have met a few $100K+ programmers out there, but none were VB'ers. Just a bunch of "namby pamby" C and C++ wizards :-) Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday,

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Joanne, there are no bad questions, only bad answers. Use sqlite3_bind_double and your timestamp will be of type double (a 64 bit FP number), Joanne Pham wrote: Hi John, Thanks for the detail info. I am still very new to SQLite3 and sorry for the question. My application is used C++ to

[sqlite] Re: SQLite and Columnar Databases

Hello, Thanks for the interesting discussion. What I got so far is summarized below: 1) Row based versus Column based storage is an implementation detail. 2) SQL used for access is independent of storage mechanism adopted. 3) Row based storage with indices on all columns reaches read performance

Re: [sqlite] Improving performance of SQLite. Anyone heardofDevice SQL?

I didn't write the original about forklift operators. It was Fred Williams, AFAIK. It was. SNIP IMHO, this has gone completely off topic, and I shall hence forth cease to contribute to this, and related threads. I think you may be correct. John

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

On Mon, 2007-12-17 at 19:22 -0500, John Elrick wrote: > John Elrick wrote: > > SNIP > > When you can hire a forklift operator to program (well, that is), > > > To avoid a misunderstanding...I mean - right off the forklift. I'm sure > anyone with the proper motivation can learn to program, but

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

John Elrick wrote: SNIP When you can hire a forklift operator to program (well, that is), To avoid a misunderstanding...I mean - right off the forklift. I'm sure anyone with the proper motivation can learn to program, but it took me 25 years to realize how little I really knew. John

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevic eSQL?

James Steward wrote: On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

I doubt it, you are obviously aggressive enough to learn more than the Mickysoft studio. Honestly, how many Visual X programmers do you know that have come from the "rank and file?" As a consultant, I have seen a very large proportion who have. I admire anyone who has the desire and

[sqlite] RE: Visual Studio (was Improving performance of SQLite)

I was a die-hard Amiga programmer years ago and swore never to put a PC on my desk at home. Unfortunately they used them at work, so I was forced to learn it. After a few years of being a broke enthusiast on the Amiga, I wrote a business app on the PC in Visual C and VB3. It was my first

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Joanne Pham wrote: My application is used C++ to insert/select the data from this table. So if I defined it as create table mytable ( createDate REAL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (remoteWXId) ); Then I can use sqlite3_bind_real to bind the column but what is the

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: > A hundred or so Visual Basic programmers are cheaper to replace and > "maintain" than one good Delphi/C++ programmer. ;-) That is the reason > management likes "Visual ." Been there, learned that. Hire the > staff from the largest

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Hi John, Thanks for the detail info. I am still very new to SQLite3 and sorry for the question. My application is used C++ to insert/select the data from this table. So if I defined it as create table mytable ( createDate REAL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (remoteWXId) );

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

Wow, I know this isn't really the point of your comment, but I always have to jump in when I see VB programmers "attacked". So as a Delphi / C++ / VB programmer, where do I fit into your analogy? Do I end up replacing myself :) -- Eric Pankoke Founder / Lead Developer Point Of Light Software

Re: [sqlite] table.* excludes ID field when using natural join ?

Samuel R. Neff wrote: I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff from the largest pool, not the most effective. Besides it's damn hard to be a

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Sqlite stores a date and time as a REAL so instead of trusting to manifest typing to make it a REAL your code will be easier to follow if you declare it a REAL. Here is a simple list of the date and time functions embedded in Sqlite 1. date( timestring, modifier, modifier, ...) returns

[sqlite] table.* excludes ID field when using natural join ?

I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> create

[sqlite] Sqlite in Python on Bluehost Web hosting

I searched the archives, but couldn't find a way to fix this on my own. I use Bluehost.com for Web hosting. I like Python. I like Sqlite. I'm trying to use the three together. Bluehost supports Python, and sqlite is installed. I have ssh access. However, there is no pysqlite2 or apsw support

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Joanne Pham wrote: I have two question regarding DATETIME column data type: 1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier if this column type is INTEGER vs DATETIME then do the conversion in the GUI code to convert from INTEGER TO DATETIME. 2) And

RE: Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

> As my father was fond of saying; "Money talks and BS walks." Unfortunately, that rule is decidedly invalid in the commercial software world. Bear in mind that DRH doesn't sell software, which is part of the reason why he and Encirq go about doing things differently. -T

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Thanks John, " If you make it a REAL instead of DATETIME your code will be clearer." So you meant that I should make my datatype as REAL instead of DATETIME. Thanks, Joanne - Original Message From: John Stanton <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, December

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

If you declared your date and time (timestamp) column DATETIME it will be floating point and will store date and time in 8 bytes. Use the FP bind function. If you make it a REAL instead of DATETIME your code will be clearer. Joanne Pham wrote: Hi All, I have two question regarding DATETIME

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

> Keeping the discussion academic, "hype a product..." is a > business model that apparently has been used to at least some > degree by a company called Microsoft. It tends to work > because the model permits them such an early lead that even > better products have difficulty catching up. >

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

Hi All, I have two question regarding DATETIME column data type: 1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier if this column type is INTEGER vs DATETIME then do the conversion in the GUI code to convert from INTEGER TO DATETIME. 2) And if I store as

Re: Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

Ion, I second your comments. Personally, I think Encirq is wasting everyones time cluttering the sqlite mailing list with propaganda. Not an ideal way to gain trust or customers. I preffer the open and honest style of DRH. I also think its rude that they do this on a sqlite mailing list.

[sqlite] Multiple connections and triggers

Hi, I am in a situation where-in there are multiple connections to a single sqlite database. When one connection updates the database other connections would like to get the information about the change (asynchronously, for example when user wants he will use some refresh like command of the

Re: [sqlite] Heap Memory usage in Sqlite

On Mon, 17 Dec 2007 17:34:26 +0530, "Sreedhar.a" <[EMAIL PROTECTED]> wrote: >Hi, > >I am working with the database of 40k records. >My database table contains the metadata information of audio files. > >When I searched for the first 50 records, the heap usage is small. >when I searched for the

Re: [sqlite] Running multiple SQLite processes

Hi Everyone, The problem was a mix of processes running SQLite 3.5.3 and 3.3.12. When all processes ran 3.5.3 the problem disappeared and we got a consistent high performance (<4ms per select). Regards Ken kenmor wrote: > > > Hi Everyone, > > We are seeing the following strange behaviour

Re: [sqlite] Skype client using SQLite?

On Tue, 28 Aug 2007 15:13:47 +, [EMAIL PROTECTED] wrote: >In reference to > > http://www.sqlite.org/cvstrac/tktview?tn=2592 > >This is the first public indication we have had that >Skype is using SQLite in their windows clients. However, >the person who wrote the ticket seems to be a bit

[sqlite] Heap Memory usage in Sqlite

Hi, I am working with the database of 40k records. My database table contains the metadata information of audio files. When I searched for the first 50 records, the heap usage is small. when I searched for the last 50 records, the heap usage is almost equal to searching the entire database