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
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
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
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.
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
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
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
_
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
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
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
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
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
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
-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://
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
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
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
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
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
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."
-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
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
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
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
24 matches
Mail list logo
