Re: [sqlite] selecting top entry from each day

"Tejas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I have a table 'stats' with following schema > date varchar (25), utilization int, os_name varchar(25) ... > > I am recording host utilization for windows and linux operating > systems (os_names) at various times in a day in

Re: [sqlite] Deleting sqlite rows

On 11/9/08, LordEricO <[EMAIL PROTECTED]> wrote: > > I am using jdbc to work with my sqlite database in java. I need to remove a > row of in my database. However, I never really designed a column that could > be a primary key. I think sqlite puts it's own auto-incremented value for > each

[sqlite] Deleting sqlite rows

I am using jdbc to work with my sqlite database in java. I need to remove a row of in my database. However, I never really designed a column that could be a primary key. I think sqlite puts it's own auto-incremented value for each row in automatically. Is there a way I could use that to

Re: [sqlite] Saving a memory-based SQLite database to disk

Hi Jay, Definitely worth investigating. Thanks for the tip! -- Tito On 9 Nov 2008, at 8:44 AM, Jay A. Kreibich wrote: > On Sat, Nov 08, 2008 at 03:34:29PM -0800, Tito Ciuro scratched on > the wall: >> Hello, >> >> If I open a SQLite database in memory (using :memory:), would it be >>

Re: [sqlite] Saving a memory-based SQLite database to disk

Thank you for the pointer Joshua. -- Tito On 8 Nov 2008, at 3:46 PM, Joshua Paine wrote: > Tito Ciuro wrote: >> If I open a SQLite database in memory (using :memory:), would it be >> possible to save it on disk? > > Open a disk db and use the ATTACH sql command to add a memory DB. Do > your ops

Re: [sqlite] hierarchical queries

On Sun, 9 Nov 2008 20:39:23 +0100, "Sébastien Roux" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database : >Hi, > >Is there a way of doing hierarchical queries with SQLite. I'm not a killer >with SQL language but I've seen that there are some hierarchical

[sqlite] hierarchical queries

Hi, Is there a way of doing hierarchical queries with SQLite. I'm not a killer with SQL language but I've seen that there are some hierarchical functions under Oracle. I'm having a hierarchy stored as a parent/child relationship. Thanks for your help. Sébastien Roux

Re: [sqlite] selecting top entry from each day

On Sun, Nov 9, 2008 at 1:40 PM, Tejas <[EMAIL PROTECTED]> wrote: > Hi all, > > I have a table 'stats' with following schema > date varchar (25), utilization int, os_name varchar(25) ... > > I am recording host utilization for windows and linux operating systems > (os_names) at various times in a

[sqlite] selecting top entry from each day

Hi all, I have a table 'stats' with following schema date varchar (25), utilization int, os_name varchar(25) ... I am recording host utilization for windows and linux operating systems (os_names) at various times in a day in this table. The date column has a format of -mm-dd. I want to do

Re: [sqlite] Saving a memory-based SQLite database to disk

On Sat, Nov 08, 2008 at 03:34:29PM -0800, Tito Ciuro scratched on the wall: > Hello, > > If I open a SQLite database in memory (using :memory:), would it be > possible to save it on disk? Here's the reason: > Manipulating data in memory is ~3.4x faster than using the file system > (YMMV). If

Re: [sqlite] NFS--how to test?

On Sat, 2008-11-08 at 22:34 -0800, Peter A. Friend wrote: > Simultaneous access over NFS will *not* work...Access will have to > serialized somehow. Multiple readers should still work, right? Like many web apps, mine tend to be very read-heavy. But I think if we're talking about having to do