Good morning all,
Is there an odbc driver for Sqlite3?
It would be useful to be able to use existing data tools...
=
-
The Castles of Dereth Calendar: a tour of that art and architecture of the
online game world of Asheron's Call
Is there any chance of implementing a weekday name in strftime()?
The microsoft/dos version returns:
%a
Abbreviated weekday name
%A
Full weekday name
It should be pretty easy to implement.
=
-
The Castles of Dereth Calendar: a tour of that art and
I get the same, I think I saw a message that the fix was checked into
revision control but not yet released.
--- Dennis Ryan <[EMAIL PROTECTED]> wrote:
> I have the following table
>
> create table test
> ( test_id integer not null,
> last_mod_date default current_timestamp,
> stuff,
>
--- Paolo Vernazza <[EMAIL PROTECTED]> wrote:
> > Tell your friends that they need to read the FAQ.
> > http://www.sqlite.org/faq.html#q13
>
> Sorry, Richard, but I think that it isn't so simple you must also
>
> store triggers and indexes... and maybe you don't know what's the
> table
>
> > You missed his point. When you use the steps in the FAQ to alter
> > a table, one of the steps involves deleting it. When you do that
> > SQLite also deletes all existing triggers and indices on the
> > table.
> >
> > Consequently one piece of code that is simple (alter table)
> suddenly
> >
> >
> >You're altering tables you don't understand the structure of?
> >
> >
> >
> >
> Think about a php forum... someone could choose to make a mod and add
> a
> column for the birthday in the users table... you can't know if
> someone did it or not...
Arg! Just invites people to crash
Hey Kurt,
Have you tried this yet? I was just doing the design for a project
and wondered if sqlite3 was reentrant. Can I use the open database
connection and execute an sql statement from within the callback
of another statement?
--- Kurt Welgehausen <[EMAIL PROTECTED]> wrote:
> >> for
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> Peter Bartholdsson wrote:
> > Think the topic explains it but there any way to enable recursive
> triggers?
> > Aka, triggers that run as result of a change by a trigger.
> >
>
> Recursive triggers are on the todo list. They are a
One poster mentioned some OS's will not let you know when you're
out of RAM (malloc() never fails). That might be difficult!
--- Darren Duncan <[EMAIL PROTECTED]> wrote:
> If possible, SQLite should also manage memory so that it has the
> resources necessary to roll back the infinite recursion
Everything I try to post is marked as spam and rejected.
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Yesterday I posted three messages to the mailing list. Today when I
> look at
> the list only the last of those three messages has been distributed
> back to
> my email account.
>
>
> > 10. SQLite runs on almost ever operating systems. SQL Server runs
> > on MS Windows exclusively.
> >
> yep, but again who cares, 99% of the world is on windows
About half of the web servers on the internet
are not windows based:
http://news.netcraft.com/archives/web_server_survey.html
>
--- [EMAIL PROTECTED] wrote:
> Let me clarify then. 100% of our customer want web based. With .NET
> and SQL server we can throw in our data adapter and be off to the
> races. We don't have to worry about future scalability. With
> Sqlite, you dont' receive a trusty data provider. Good ones
> > If you install MS SQL server you run a network based service that
> > is vulnerable to attack. If you run Sqlite you don't run any
> > service and thus are invulnerable (to network service based
> > infections).
>
> Not relevant. No reference to "network service based infections" was
> made
Other database engines provide methods of doing this, but I
don't think sqlite does. I would use an insert statement that uses
select to copy the content of one table into the other.
insert into X(field1,field2) select field1,field2 from Y
--- Richard Boyd <[EMAIL PROTECTED]> wrote:
> Hi,
>
The other important thing to remember is that this only shows
desktop systems. Servers are much more likely to be linux or
Sun than desktops and Servers don't surf :)
--- Greg Miller <[EMAIL PROTECTED]> wrote:
> D. Richard Hipp wrote:
> > On Mon, 2005-01-31 at 11:31 -0600, [EMAIL PROTECTED]
Does this fix it?
insert into each_transaction(datetime) values(datetime('now'));
--- teoh <[EMAIL PROTECTED]> wrote:
>
> create table each_transaction(datetime int);
>
> insert into each_transaction values( datetime('%s',
> 'now'));
>
> this is how I create table and insert the
>
Did you try this?
create table each_transaction(datetime text);
insert into each_transaction(datetime) values(datetime('now'));
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table each_transaction(datetime text);
sqlite> insert into
Don't forget to check the version numbers of the DLL's and
such that your program calls. I've had a LOT of grief in the past
because users installed a new program, after installing my program,
which placed newer (or older) incompatible DLL's on their system.
My program just started mysteriously
I wouldn't think DLL calling overhead would be significant
when dealing with things as slow (relatively) as a database.
Is it really necessary for it to be a DLL?
You might be able to statically link it and remove that overhead.
Are you using COM or ActiveX to call it? If I remember right
they
I did a small test to see if performance was linear with time.
I wanted to make sure it was suitable for my application.
It seems with both indexed and unindexed tables it doesn't take
significantly longer to do the 1,000,000th insert than it did the
first.
=
The data is stored in a file. Anyone that can access the file can
get the data in it. You'll have to encrypt your data if you want it
safe, and even that's only as safe as your choice of algorithm and
password.
--- teoh <[EMAIL PROTECTED]> wrote:
> hi , Is it possible to prompt user for
--- Witold Czarnecki <[EMAIL PROTECTED]> wrote:
> 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?
yes but there's a fix checked in
> 2.
> sqlite> CREATE TABLE test(id INTEGER NOT NULL PRIMARY KEY
--- Krzysztof Kotowicz <[EMAIL PROTECTED]> wrote:
> >>WHERE 1
> >>
> >>
> >What is this supposed to do? It's not a boolean expression.
> >
> >
> AFAIK it would render the same result as 1=1 (it seems that it casts
> to
> boolean true), at least that behaviour was observed in MySQL.
>
How about the ability to use the aliased column name in the
where, having, and order by clauses?
I.E.
SELECT People, ROUND(Sales,2) AS blah
FROM list_table
GROUP BY People
ORDER BY blah
=
-
"Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Anyway get get Unix Epoch Time in Windows MFC, or win32?
Yes, the same way you do in unix.
long ago;
time( & ago );
=
-
"Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of
The MFC date is stored as a floating point number, the unix
date as a long integer. The MFC style date, used through out
windows has a maximum date of somewhere around 2038AD. The unix
variant goes several thousand years farther.
You could certainly store the float date as a float type field
but
--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:
> I have a query which calculates the number of events during an hour
> by the
> minute. It needs to work out which minute has the most events and
> the
> average events during that hour. So it should return an array of 60
> results
> for an hour
Ah, sorry, didn't know about the ole version.
I'll have to check to see if they implemented that in Excel etc.
I had a lot of trouble with it under Access and Excel
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> HI Jay,
>
> CTime::GetTime() return time_t which i
eopleCallback, 0,
);
if ( rc != SQLITE_OK )
{
sqlite3_close( db );
throw ConException( string("SQL failed: '") + sql +
string("'") + zErrMsg );
}
sqlite3_close( db );
}
--- Lloyd Thomas <> wrote:
> Jay,
> ---
--- "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
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
--- 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
--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:
> 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 colum
> Actually I can read 10 MByte from an Oracle DB (on another machine)
> via ODBC in less than 2 seconds... I don't know if that's good or bad
> though, you tell me ;)
Pretty good! That works out to 5 megabyte per second. That's gotta
be gigabit ethernet. I don't think the 10 meg stuff will
> > On Mon, 2005-02-28 at 08:48 -0700, Robert Simpson wrote:
> > > 5. What we do with the schema information or how well we
> > compute it
> > > is irrelevant.
> > >
> >
> > No. It is exceedingly relevant if you want any cooperation
> > from me in addressing the issue.
> >
> > There seem
I type very fast and my fingers added the semicolon on the end
because they're used to doing it:
sqlite> .dump people_event;
BEGIN TRANSACTION;
COMMIT;
sqlite> .dump people_event
BEGIN TRANSACTION;
CREATE TABLE People_Event
(
PeopleINTEGER NOT NULL,
Event
I've gotten my first application up and running nicely with sqlite.
I wanted to say thanks to everyone for their hard work that made it
possible more quickly than I had imagined.
My project:
* An event management web site for a convention.
* Gentoo 2004
* Linux 2.4 kernel
* AMD Duron 600mhz w/
> > * An event management web site for a convention.
> > * Gentoo 2004
> > * Linux 2.4 kernel
> > * AMD Duron 600mhz w/ 256 meg RAM
> > * lighttpd web server
> > * C++ cgi
> > * sqlite backend database
>
> I'm heartily glad to hear that I'm not the only poor deluded fool
> writing
> CGI apps in C
>
> can a similar argument be made for assembler?
Yes, but modern C compilers generate code that's 99% as good as
a human would write. I've tried to write better code in assembler
than the compiler does. I've managed it, but's it's pretty hard.
If you profile your code you generally find that
--- [EMAIL PROTECTED] wrote:
> Agree, C is great and thanks God we got it in our asenal of tools.
> But it
> is not pefect because of its own strengths.
> After 15 years of assembler programming, I am still to find a
> compiler that
> makes debugging and optimizing as easy as assembler.
> I
> like try to write your own CGI parser. Libraries like cgic at
> http://www.boutell.com/cgic/ and cgicc at http://www.cgicc.org make a
> lot
> more sense than reinventing that particular wheel yourself. They
> also
> address the buffer overflow problem directly by using strings, or
> forcing
>
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> I find it utterly amazing that a machine with bad memory could
> run a full-blown Linux desktop and a copy of Win2K running in
> VMWare for days on end without showing a problem, then suddenly
> begin having trouble with the SQLite regression
> I have not tried this with SQLite, but if I was using SQLite for such
> an app, I assume I would need to serialize all such writes through a
> single thread or process. E.g., in my web server, the connection
> thread servicing the user request would send a message to my one
> single db writer
> Regarding: ... As an example the ethernet card you're probably using
> right
> now.
> ... they detect the collision, wait a short period, and retry.
>
> For those using Unix/Linux, would this provide the queuing needed for
> those
> apps with numerous parallel writes?
>
d get_inserted_rowid()? I did it that way thinking it's
a necessary precaution.
--- Clay Dowling <[EMAIL PROTECTED]> wrote:
>
> Peter Jay Salzman said:
> > Do these two functions do the same thing? Are there any surprises
> or
> > differences between the two?
>
A stupid question:
Why introduce more code, one more thing to test,
and possibly bugs? Is there a problem that needs fixing?
It certainly will not cause me any problems.
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> As currently implemented, there is no fixed limit to the number
> of
> > A stupid question:
> >
> > Why introduce more code, one more thing to test,
> > and possibly bugs? Is there a problem that needs fixing?
> >
>
> There is code in SQLite that has to deal with the general
> case of tables with millions or billions of columns. That
> code can be
> > > There is code in SQLite that has to deal with the general
> > > case of tables with millions or billions of columns. That
> > > code can be simplified (and made faster) if we know that
> > > the maximum number of columns is some reasonable limit,
> > > such as 2000.
> >
> > Oh. Go for it!
I just finished a c++ program to replicate a database while it's in
use. I have tested it on a version 3 database under windows.
It creates a duplicate database with the same schema as the source
database, then in a loop it locks the database, copies a table,
and unlocks the database.
The
--- Stefan Finzel <[EMAIL PROTECTED]> wrote:
> Yeah! I've missed the default option. But is this SQL standard?
>
> And it does not seem to work for me at all. I still can't differ
> empty and NULL;
> create table deftest (k integer primary key,
> i integer default
The exec() function, the one that uses callbacks, is deprecated.
You should use the prepare, bind, step routines:
sqlite3_prepare(), sqlite3_bind_text(), sqlite3_step()
The nice side effect is you don't have to use globals, callbacks,
or the goofy work around for the 'this' pointer in your
> Unfortunately I'm not able to grasp the new functions, I've read
> through
> http://www.sqlite.org/capi3.html but I can't picture how I would set
> up
> these functions. Is there an updated sample or tutorial? Or could
> someone
> explain the basic routine for extracting the
SQLite version 3.1.2
Enter ".help" for instructions
sqlite> select datetime('now');
2005-03-26 00:44:37
sqlite> .quit
zenobia # date
Fri Mar 25 18:44:48 CST 2005
zenobia #
Is this because I don't have the timezone set?
__
Do You Yahoo!?
Tired of
> > SQLite version 3.1.2
> > Enter ".help" for instructions
> > sqlite> select datetime('now');
> > 2005-03-26 00:44:37
> > sqlite> .quit
> > zenobia # date
> > Fri Mar 25 18:44:48 CST 2005
> > zenobia #
> >
> > Is this because I don't have the timezone set?
>
> select datetime('now',
> Hello sqlite-users,
>
> any news on that?
It's not part of the sql standard, so I would bet the answer
is going to be 'you have to add that yourself'. I did for
my project.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
> Saturday, March 26, 2005, 2:41:10 AM, you wrote:
>
>
> >> Hello sqlite-users,
> >>
> >> any news on that?
>
> > It's not part of the sql standard, so I would bet the answer
> > is going to be 'you have to add that yourself'. I did for
> > my project.
>
> How did you do that?
> Do you
> I am just looking into building some "set top" like
> devices for a particular business application. I
> would like to use Sqlite to manage the data repository
> and I have been a perl developer for the last few
> years.
>
> Does anybody have a recommendation about which
> embeddable linux
> >> Not necessarily. All you're telling it to do is sort on the first
> >> column, anything beyond that is just random luck. You could easily
> >> sort it on both columns.
I think the sql standard says "If you don't specify an order then
there is no guaranteed order". It's usually table order,
>
> OK, there is no requirement, but there is a wish to return a stable
> sorting outcome.
Just add an 'order by' clause.
> Please note that the SQL standard does not prohibid stable sorting
> outcome.
It does prohibit it. It states the output is not sorted unless
you ask for it to be.
>
> The begin and end functions could be configured
> to begin/end the transaction *if* there isn't/is
> one.
> Dumb idea?
> Do I get get to wear the dunce hat? :)
You should really look at an object oriented language.
You can do exactly this very simply.
> But why should he have to? This is not a dumb idea, Jay. We are told
> that sqlite3_exec is for "legacy code support", which means that the
> only recommended option must be to use sqlite3_prepare/step/final for
> transactions. That's a fair bit of code (plus error checkin
> >>Please note that the SQL standard does not prohibid stable sorting
> >>outcome.
> >
> >It does prohibit it. It states the output is not sorted unless
> >you ask for it to be.
> >
> May I ask, are you a lawyer?
No. As a programmer you must be just as vigilant about following
the rules as a
The documentation is your friend.
long long int sqlite3_last_insert_rowid(sqlite3*);
http://sqlite.org/capi3ref.html#sqlite3_last_insert_rowid
or
begin immediate; insert; select max(id) from blah; commit;
--- jack wu <[EMAIL PROTECTED]> wrote:
> i have a table which has an ID column defined
Did you try attach and an insert?
--- de f <[EMAIL PROTECTED]> wrote:
> I'd like some guidance on the most efficient way to copy a large
> table from one slqite db to another. I'm using from within vb
> with a vc++ sqlite wrapper.
>
> I know that the copy command is no longer available in
-- de f <[EMAIL PROTECTED]> wrote:
> Thanks Jay.
>
> Great! This could work...
>
> I'm wondering, though if you know whether the limitation below
> (from sqlite documentation) could be safely circumvented if
> attaching the source db with an alias name. It
> >>begin immediate; insert; select max(id) from blah; commit;
> >>
> >>
> >
> >Or "select last_insert_rowid() from blah limit 1"
> >
> >Regards
> >
> >
> >
> Better yet
>
> select last_insert_rowid();
>
> The from clause is not needed and may imply that SQLite keeps the
> last
>
> After thinking about this a bit more, I realized that writing a
> trigger that didn't trigger for the locker is pretty simple. So I'm
> thinking that triggers would work in this situation, but I'm
> wondering if anybody has ever done anything like this before.
>
That really seems like a
> Thanks much - one more question though...
>
> I'm attempting to copy data from an in memory database to
> another db (file or otherwise). Is it possible to attach an
> existing in-memory database to another existing db connection?
> (attach database :MEMORY: would just seem to create another
are_vtab?
>
> Thank you for your help
> Alessandro
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Jay A. Kreibich < J A Y @ K R
ize. It consists of two huge
>>>> tables and an index. //...
>>> Probably running out of space wherever temp files are created.
>>
>
> I ran into this a while ago- used pragma temp_store_directory
Which is, for good or bad, depreciated. Not sure why.
-j
--
J
re able to use it. I still think it would be a useful, low-cost feature.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg50941.html
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it t
On Jan 5, 2015, at 5:03 PM, Eduardo Morras <emorr...@yahoo.es> wrote:
> On Mon, 5 Jan 2015 14:42:28 -0600
> Jay Kreibich <j...@kreibi.ch> wrote:
>
>>
>>
>> On Jan 5, 2015, at 12:25 PM, Jim Wilcoxson <pri...@gmail.com> wrote:
>>
>>>
t
understand, it will sometimes give this error. If you’re using a newer version
of SQLite to dump/load the files, there will be no error.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wr
d neither MATCH nor REGEXP
> can be redefined.
They can all be (re)defined, some just happen to have default functions:
https://www.sqlite.org/lang_expr.html#like
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have
efault and are given meaning by redefining. They would
> be useless if they were not redefinable.
>
I think the OP interpreted the lack of a match() or regexp() function on the
lang_corefunc.html page as meaning they could not be defined/redefined.
-j
--
Jay A. Kreibich < J A Y @ K R
cussion— but it is a very
similar discussion to programmers that reference function variables using the
same name as an existing global variable.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wrong
> On Tue, Feb 10, 2015 at 5:27 PM, Janke, Julian <julian.ja...@capgemini.com>
> wrote:
>
>> So my question is, if there is any additional information, how to write a
>> VFS?
>> Or does anyone have a clue how to start best?
>>
>
> This book:
>
&g
and cursing
at the debugger. That’s where the magic happens anyways.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wrong people has the tendency to make them feel uncomfortab
mand."
What am I doing wrong?
Jay
am attempting to run " LIB /DEF:sqlite3.def "
I get error This error "LIB is not recognized as an internal or external
command."
What am I doing wrong?
On Mon, Apr 20, 2015 at 10:21 AM, Jay Smith wrote:
> I am new to SQLite. I have a book I am learning from and I
at 9:51 AM, Igor Tandetnik
> wrote:
> > On 4/21/2015 11:01 AM, Jay Smith wrote:
> >>
> >> Before I sent the last message I had signed up to become a user.
> >> My previous message was bounced. WHY
> >
&
Thanks Igor
the only response I got to the first message was "it has been bounced"
On Wed, Apr 22, 2015 at 9:51 AM, Igor Tandetnik wrote:
> On 4/21/2015 11:01 AM, Jay Smith wrote:
>
>> Before I sent the last message I had signed up to become a user.
>> My previo
Thanks Adam
I will take a look
Jay
On Thu, Apr 23, 2015 at 4:19 PM, Adam Devita wrote:
> Good day,
> I don't work in VB, so I can't help you in specifics on that. A quick
> search on a search engine pops up some videos on how to use sqlite in
> a Visual Basic project.
Thanks Bill
I got in a hurry and was trying to follow the book.
I have never used C++ so the subject line is wrong.
I am now looking into NuGet and will get back if I need more help (and I am
sure I will.)
Jay
On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Dr
Hi Bill
I have been trying for 2 days and I am totally lost.
I have NuGet Package Manager. I don't know how to use it.
>From the PM> System.Data.SQLiteI get an error.
Can you be a little more specific.
Jay
On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA
s" and an ERROR
"Selecting Objects of type 'Table' is not supported.
Then we get to the next part of the problem. I am in my late 70's and have
not done any SQL for over 15 years ( I was pretty good at one time.) Where
do I go from here.
Jay
On Sat, Apr 25, 2015 at 5:12 PM, Drago, Will
Bill & Steve
Thanks guys
I am trying to learn and make some progress with the information you both
provided.
On Mon, Apr 27, 2015 at 9:57 AM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:
> Jay,
>
> I don't do VB.Net development but it should be ver
he tongue easier. And as sequel, it would be "a
> SQLite".
>
> Happy Holidays, all.
> dvn
>
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wrong people has the tendency to make them feel uncomfortable." --
Angela Johnson
Lite". I
>>> personally would write "a SQL" because it is "sequel" to me. When did
>>> SQL--sequel become SQL--ess queue ell? I always remember it as being
>>> sequel, and it rolls off the tongue easier. And as sequel, it would be
>> "a
>>
consider VDBE instructions to be an IR.
I?ve often wondering how difficult it would be to put a new front-end on SQLite
to parse Tutorial D (or some other ?true relational? language) and generate
VDBE instructions.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intellig
sing a shared cache
(or when not using the same connection for reads and writes).
Basically the connection context that created the transaction will see the
actions it has performed, while all other connections will not see the changes
until the transaction is committed (which, of course, is th
NORMAL, synchronous is FULL and threading mode is
> SERIALIZED.
>
> Thank you in advance.
> --
> Constantine.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/list
ite:
http://www.sqlite.org/support.html#mailinglists
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it, but showing
it to the wrong people has the tendency to make them feel uncomfortable." --
Angela Johnson
to use C
conventions.
I know they?re very easy to confuse (I still do it myself), but I can kind of
see why we ended up there, even if it isn?t a very strong reason.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have
>
> On Mon, Mar 2, 2015 at 1:23 AM, Jay Kreibich wrote:
>>
>> On Mar 1, 2015, at 5:33 PM, Richard Hipp wrote:
>>
>>> On 3/1/15, Paolo Bolzoni wrote:
>>>> Dear everyone,
>>>>
>>>> I find strange and confusing that bi
sions implement searches.
Consider providing a virtual table specific MATCH function, over-ride use on
your table with xFindFunction(), and rewrite statements using MATCH rather than
LIKE.
See the FTS modules as examples. You might want to start here:
https://www.sqlite.org/fts3.html
-j
--
e problem you describe has much
> more to do with the command-line editing library than it does with
> SQLite, does it not? Assuming there is a bug in the third-pary
> command-line editing library, what could SQLite do about it?
>
Also, don?t use double quotes for strings. SQL specifie
Nicolas
there are other people who also receive this mail.
if you have code that will help someone else.
Please post the information Mr Hipp requested.
Jay
On Tue, Apr 28, 2015 at 5:08 PM, Nicolas Boullis wrote:
> Hi,
>
> On Mon, Apr 20, 2015 at 06:25:21AM -0400, Richard H
operation, which in turn results in an UPDATE trigger being run once for each
row that was updated by the DELETE trigger.
How can I control this such that one trigger's statement won't cause another
trigger to run?
-Regards,
-Jay
--
PRAGMA recursive_triggers = 0;
CREATE TABLE test
t do you need it to be? If it's still not fast enough, consider
> denormalizing selectively, and what the overhead will be in maintaining
> redundant data.
"Normalize 'til it hurts. Denormalize 'til it works."
(and in that order!)
-j
--
Jay A. Kreibich < J A Y @
1 - 100 of 1855 matches
Mail list logo