Re: [sqlite] sqlite3 commandline interface questions

2009-11-02 Thread waltdnes
On Sun, Nov 01, 2009 at 10:26:28PM -0600, Jay A. Kreibich wrote > Recompile with readline support and you'll get history. Thanks for making me look at my "USE flags". I run Gentoo linux with USE flags (i.e. extra stuff) disabled by default. In addition to readline, I decided to turn on "doc

Re: [sqlite] How do you save time in a sqlite database?

2009-11-02 Thread Dale E. Moore
Dear P; Thanks so much for your knowledge and for sharing with me; I very much appreciate it! I'm doing a little ASP.NET application in MONO, Dale On Mon, Nov 2, 2009 at 4:05 PM, P Kishor wrote: > On Mon, Nov 2, 2009 at 3:30 PM, Dale E. Moore > wrote: > > Hi Puneet; > > > > Thanks for your fe

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

2009-11-02 Thread Dale E. Moore
I've been fiddling through Nabble, and I've been missing things. (Perhaps it's me and not Nabble;( You guys are WONDERFUL! David, Igor, Alex; all have given me vital information and I very much appreciate it! Thanks!! Dale On Mon, Nov 2, 2009 at 4:24 PM, David Bicking wrote: > I probably shou

Re: [sqlite] Roadmap for SQLite

2009-11-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shaun Seckman (Firaxis) wrote: > The SQLite Consortium membership would be great but so far this > newsgroup has answered every single one of my questions within a 2 hour > window of posting..for free! The consortium membership is not about answerin

Re: [sqlite] Roadmap for SQLite

2009-11-02 Thread P Kishor
On Mon, Nov 2, 2009 at 5:26 PM, Scott Hess wrote: > And always remember that it's cheap to ask > - maybe the feature is in there, you just mis-understood something Whereby "it's cheap to ask" implies that it is "inexpensive to ask" and not "to ask is cowardly, impolite or deserving of contempt."

Re: [sqlite] Roadmap for SQLite

2009-11-02 Thread Scott Hess
On Mon, Nov 2, 2009 at 3:56 PM, Shaun Seckman (Firaxis) wrote: > The SQLite Consortium membership would be great but so far this > newsgroup has answered every single one of my questions within a 2 hour > window of posting..for free!  (you guys frickin rock.)  So SQLite > development is purely gui

Re: [sqlite] Roadmap for SQLite

2009-11-02 Thread Shaun Seckman (Firaxis)
The SQLite Consortium membership would be great but so far this newsgroup has answered every single one of my questions within a 2 hour window of posting..for free! (you guys frickin rock.) So SQLite development is purely guided by requests from consortium members? There aren't any planned featu

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

2009-11-02 Thread David Bicking
I probably should have explicitly stated that my suggestion only worked up to 24 hours. Unfortunately I couldn't think of a solution for greater values. Yesterday Igor posted a solution that works with days. You never responded to him so perhaps you didn't see it. I'll copy it here: ** SELECT

Re: [sqlite] How do you save time in a sqlite database?

2009-11-02 Thread P Kishor
On Mon, Nov 2, 2009 at 3:30 PM, Dale E. Moore wrote: > Hi Puneet; > > Thanks for your feedback! > > My complete picture is that I would I'd like to enter running, cycling, > walking times like hh:mm:ss.hundredths and have them saved magically as > DURATION in sqlite. Then I would like to run a SEL

Re: [sqlite] How do you save time in a sqlite database?

2009-11-02 Thread Dale E. Moore
Hi Puneet; Thanks for your feedback! My complete picture is that I would I'd like to enter running, cycling, walking times like hh:mm:ss.hundredths and have them saved magically as DURATION in sqlite. Then I would like to run a SELECT SUM(DURATION) ... GROUP BY something-or-other and have yy:mont

Re: [sqlite] Roadmap for SQLite

2009-11-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Shaun Seckman (Firaxis) wrote: > I'm really interested in finding out what sort of major features or > tweaks are planned to be in upcoming releases (within the next 6 > months). You get what you ask for :-) Have a look at these two pages: http://

[sqlite] Roadmap for SQLite

2009-11-02 Thread Shaun Seckman (Firaxis)
Hello, Is there any sort of development road map for SQLite? I'm really interested in finding out what sort of major features or tweaks are planned to be in upcoming releases (within the next 6 months). The foreign key constraint feature came as a pleasant surprise but ended up in

Re: [sqlite] How do you save time in a sqlite database?

2009-11-02 Thread P Kishor
On Mon, Nov 2, 2009 at 2:12 PM, Dale E. Moore wrote: > Hi All; > > I want to enter my trip times. Enter where? You have been asking this question for a while now, but something tells me that you are not asking the complete question. Where do you want to enter the trip times? How do you want to en

[sqlite] How do you save time in a sqlite database?

2009-11-02 Thread Dale E. Moore
Hi All; I want to enter my trip times. I would like to enter something like 5:6:7.89 for 5 hours, 6 minutes, 7 seconds and 89 hundredths. Some time later I would like to sum all these times and have it represented as years-months-days.hours:minutes:seconds.hundredths. How would you approach this

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

2009-11-02 Thread P Kishor
On Mon, Nov 2, 2009 at 1:08 PM, DaleEMoore wrote: > > Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for > seconds less than 1 day! > > I wonder what I should do where the time becomes days, weeks, months, years? I have no idea why you think it won't work for long time per

Re: [sqlite] Data loss after vacuum

2009-11-02 Thread Simon Slavin
On 2 Nov 2009, at 6:39pm, chen jia wrote: > Thanks for your replies, Simon and Dair. > > Yes, it is probably a bug in sqlite version 3.6.10. After I upgraded > to version 3.6.12, I ran vacuum again and had no problems. That's good news. > I do have more questions. > > I want to clean fragmenta

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

2009-11-02 Thread DaleEMoore
Thanks David SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') works great for seconds less than 1 day! I wonder what I should do where the time becomes days, weeks, months, years? Do you have any suggestions about how to handle: SELECT STRFTIME('%y-%m-%d.%H:%M:%f',962.5,'unixepoch') I look forward

Re: [sqlite] tirgger everywhere and always

2009-11-02 Thread Igor Tandetnik
Victor Mayevski wrote: > Is it possible to implement triggers that fire up for each independent > session? There are plenty of interprocess communications mechanisms provided by most populare operating systems. An SQLite database is not one of them. Igor Tandetnik _

Re: [sqlite] Data loss after vacuum

2009-11-02 Thread chen jia
Thanks for your replies, Simon and Dair. Yes, it is probably a bug in sqlite version 3.6.10. After I upgraded to version 3.6.12, I ran vacuum again and had no problems. I do have more questions. I want to clean fragmentation in the database with vacuum command. When I ran a combination of '.du

Re: [sqlite] tirgger everywhere and always

2009-11-02 Thread P Kishor
On Mon, Nov 2, 2009 at 12:17 PM, Victor Mayevski wrote: > Is it possible to implement triggers that fire up for each independent > session? For example, I am using TCL, define a function in TCL, > register it with SQLite, create a trigger to call that function every > time an update happens to som

[sqlite] tirgger everywhere and always

2009-11-02 Thread Victor Mayevski
Is it possible to implement triggers that fire up for each independent session? For example, I am using TCL, define a function in TCL, register it with SQLite, create a trigger to call that function every time an update happens to some table. Well, it works just fine for that specific open session.

[sqlite] Cancel my subscription in this group

2009-11-02 Thread paulito santana
Please cancel my subscription I already have done hundreds of times in offical webpage, but it is assumed ! Regards, Paulito ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SUM(tripSeconds) and format output as days.hours:minutes:seconds.hundredths?

2009-11-02 Thread DaleEMoore
Hi David; That's LOVELY for small numbers like: SELECT STRFTIME('%H:%M:%f',62.5,'unixepoch') 00:01:02.500 What do you think I should do with larger periods of time? In the following I hoped for 00-00-00.01:02.500. SELECT STRFTIME('%Y-%m-%d.%H:%M:%f',62.5,'unixepoch') 1970-01-01.00:01:02.500 I

[sqlite] Some enhancements for FTS3

2009-11-02 Thread Alexey Pechnikov
Hello! The FTS3 work fine but is really unfriendly to developers. As example it is easy to write tcl interface code for snowball stemmer utility "stemwords" and for stopwords dictionary but there are no ways to use it in FTS3. The user functions can be easy writed on C or any other language b