Did you check out
http://www.sqlite.org/inmemorydb.html
Could you use an in-memory db to act as a db for a save point?
When you are ready to commit, do so from 1 in memory db, while accumulating
into another in preparation for that save point.
Adam
On Tue, May 15, 2012 at 1:55 PM, Charles
STW:
http://stackoverflow.com/questions/740523/getting-a-webkit-executesql-transaction-to-return-a-value
other references
http://stackoverflow.com/questions/61972/javascript-sqlite
On Wed, May 9, 2012 at 10:32 AM, Pavel Ivanov wrote:
> And again you wrote to the wrong mailing list. Use "Reply"
Good day,
Is anyone using .NET c# code as a client to connect to one of the free
network server implementations?
regards,
Adam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Good day,
This page
http://sqlite.org/cvstrac/wiki?p=SqliteNetwork
Is giving an error 404 for this link
*SQL4Sockets* (http://www.oneledger.co.uk/sql4sockets.html)
regards,
Adam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
or .NET
is missing a letter 'd'. The word "an" should be "and". .... " source
code and binaries"
regards,
Adam DeVita
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Sorry for false alarm. Please disregard this thread:
Solution: make sure you quit everything and isolate the code. There is a
subsequent write to the new record that made it appear as a problem, when
it wasn't.
Adam
On Wed, Mar 21, 2012 at 3:25 PM, Adam DeVita wrote:
> Good day,
cationID|record_updatetime|write_out_ok
DT00-13-D3-50-AF-F9|2|2009.02.03.13.41|0
PROGRAMMER-LAB00-1E-90-31-8D-19|3||0
PROGRAMMER-LAB00-03-0D-00-00-01|3||0
ADAM-PC00-25-64-8C-5A-3B|3|2012.03.21.18.57.19|0
attach
'Z:\PINTS\modules\deltafiles\deltas\2012.03.21_ADAM-PC00-25-64-8C-5A-3B_r006.db'
as &#x
value ,
X'reference_to_your_hex_data' )
the X' ' to denotes your hex value. This is listed in the documentation.
regards,
Adam DeVita
On Wed, Jan 18, 2012 at 10:02 AM, Petr Lázňovský wrote:
> > On 18 Jan 2012, at 12:30pm, Petr Lázňovský wrote:
>
> >>>> have windows b
is is enough, or if I
need to drop all of the indexes entirely and create them again.
The latter is obviously a more problematic situation when the schemas
are arbitrary.
Thanks for your advice
Adam Kennedy
___
sqlite-users mailing list
sqlite-users@sqlit
this happen for this workstation? I'm
not sure if we will ever know, given that the offending records are create
date 2 years ago, modified 1 year ago.
Command prompt reports version 3.6.10 on start up.
Adam
On Wed, Jun 29, 2011 at 9:08 AM, Simon Slavin wrote:
>
> On 29 Jun 2011
Success!
On Tue, Jun 28, 2011 at 11:34 AM, Simon Slavin wrote:
>
> On 28 Jun 2011, at 4:22pm, Adam DeVita wrote:
>
> > I can see the data that I want to export. How do I fix these indexes?
>
> Use the sqlite3 command-line shell to dump the database to SQL commands
from ... table above.
I can see the data that I want to export. How do I fix these indexes?
regards,
Adam DeVita
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t; IN (SELECT "id" FROM "One")));
Error: subqueries prohibited in CHECK constraints
sqlite>
It appears I remembered correctly. Yes, I also once had a use case for
that; I solved it easily with a trigger. Not sure about the doc issue you
also mention.
Very truly,
SA
your log at the beginning of
your program.
if (this_log_entry_id > max_log_entries){
this_log_entry_id =1;
}
else{
this_log_entry_id
}
call_insert_function (this_log_entry_id /*becomes the primary key that you
are inserting or replacing*/ , data_to_be_logged ,.
Adam
On
t;col2" = 1);
2
sqlite> SELECT count() FROM
...> (SELECT "col1" FROM "Test" WHERE "col2" = 3);
0
That looks like a fairly “magic way” to me—and I have actually used that
method with nontrivial queries. Am I missing something? Too, I know how
s:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg58853.html
Very truly,
SAMUEL ADAM ◊ http://certifound.com/ ◊ I read list mail sporadically.
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
April 15, 2011 Courtroom Video in re Adam v. Supreme Court of N.J.:
http
think the potential solutions we may implement are all in application
code, so not really an SQLite problem.
Thanks,
Adam
On Mon, Apr 18, 2011 at 10:07 AM, eLaReF wrote:
> Talking as a Windows user only rather than an SQL expert (I'm not even
> good enough to call myself a beginner!)
Good day,
What happens if you insert more than your RAM size into an in memory
database?
(I'm particularly interested in the Windows context).
regards,
Adam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/ma
Hello all,
Anyone know where I can download the latest System.Data.Sqlite.Linq.dll? I
tried compiling it from what I found at System.Data.Sqlite.org, but it gave me
errors because the SQL Generation folder was blank. I also tried SourceForge,
but the Setup file said "A network error occurre
LECT * FROM multiturnTable WHERE rowid in (SELECT rowid FROM
> multiturnTable WHERE player1 ='?' UNION ALL SELECT rowid FROM
> multiturnTable WHERE player2 = '?') AND (complete=0 OR p1SubmitScore=0
> OR p2SubmitScore=0)
>
> And I only want to consider the last 5000 for any SEL
select id from table order by id desc limit 5000
Adam
On Mon, Mar 14, 2011 at 1:52 PM, Ian Hardingham wrote:
> Hey guys.
>
> I have a table with an autoincrement primary ID, and as part of a select
> I would like to only take the 5000 "largest"/most recent ids. Is
On Sun, 20 Feb 2011 14:51:12 -0500, Nico Williams
wrote:
> On Sun, Feb 20, 2011 at 6:24 AM, Samuel Adam wrote:
[big snip]
>> Any numerics experts (which I am not) or fp-software gurus care to chime
>> in? *If* I am correct in my inductive hypothesis that the SQLite core
&g
On Sun, 20 Feb 2011 14:46:06 -0500, Nico Williams
wrote:
> On Sun, Feb 20, 2011 at 6:28 AM, Samuel Adam wrote:
>> On Sat, 19 Feb 2011 17:12:31 -0500, Pavel Ivanov
>> wrote:
>>
>>> [snip] On
>>> Windows it’s different - process is much more heavy-wei
On Sat, 19 Feb 2011 10:37:42 -0500, Afriza N. Arief
wrote:
> On Sat, Feb 19, 2011 at 6:27 AM, Samuel Adam wrote:
>
>> A FAQ[2] isn’t enough, as we can see.
>>
>> To put it another way: Bug reporters should have probable cause before
>> they bug others.
hich use worker processes for concurrency the same
way my *nix server daemons do. There’s a reason for that.
Lots to say about threads, but well—that will need await another thread.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ Unite
which may affect SQLite.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey, its agents, and its officers did.”
pular pthreads/win32 package; it is
reputed slow, I cannot attest either way as thereto, and it may or may not
be what the original poster was using.)
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from
ead at a time. Then I realized the obvious problem: I’m
dealing with a signal handler. Duh. Back to square one.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t
ocument thereby referenced[3] explain SQLite’s
position on compiler warnings, it is futile to expect that somebody who
missed that would read a source code comment. Did I mention the
FAQ[2,supra]?
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough
gt; SELECT date( '2011-01-01', digit || 'days' ) AS d FROM digits;
s/'days'/' days'/
(Thanks for the tip on quotes; I should have added
http://www.sqlite.org/lang_expr.html and
http://www.sqlite.org/lang_keywords.html .)
Very truly,
Samuel Adam ◊ <
lang_select.html
(and a few others)
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey, its agents, and its officers did.”
h
On Thu, 10 Feb 2011 16:38:40 -0500, Stephan Beal
wrote:
> On Sun, Feb 6, 2011 at 2:36 PM, Samuel Adam wrote:
>
>>
>>* Make sure the binding is done as BLOB and not TEXT. PDO
>> probably
>> has
>> its own flags defined for this. This is the part
On Thu, 10 Feb 2011 15:21:57 -0500, Yves Goergen
wrote:
> On 07.02.2011 23:47 CE(S)T, Samuel Adam wrote:
>> On Mon, 07 Feb 2011 03:16:54 -0500, Philip Graham Willoughby
>> wrote:
>>> What about:
>>>
>>> UPDATE "message_revision" SET &q
On Wed, 09 Feb 2011 20:14:19 -0500, Igor Tandetnik
wrote:
> On 2/9/2011 7:29 PM, Samuel Adam wrote:
[…snip garbage…]
>
> It seems (1, 2) and (2, 1) would result in distinct xk values, thus
> defeating the point of the exercise. It is again possible to insert two
> pairs that
it really
depends on application requirements. And the XOR could also be done in
pure SQL with SQLite patched to have a ^ operator.
Due credit: I of course cribbed from the quoted idea to correct my
previous error.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery
On Wed, 09 Feb 2011 18:51:45 -0500, Samuel Adam
wrote:
> On Wed, 09 Feb 2011 18:39:14 -0500, David Bicking
> wrote:
>
>> I don't think this will work. xor(6,1) = 7 and xor(4,3) = 7, so you
>> would fail to insert proper pairs. Or am I missing something? (At
xamples.
You are right, as xoring on my fingers would have verified. In polite
terms, evidently I just demonstrated publicly math as not my forté ||
today as not my day. Apologies for the noise.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough,
r in mind, this suggestion stems from a personal bias toward clever XOR
tricks; at that, I once wrote a set of endian-swab functions with no
(explicit) temporary variables, purely using XOR-swap and shifts. I found
it the most pleasant way to satisfy aliasing rules; yet I am to this day
unc
know the urban legend about the folks at the restaurant who design a
complicated plan for switching the contents of salt and pepper shakers
which have their hats juxtaposed, and then a passer-by suggests just
switching the caps?
Thank you, Mr. Willoughby!
Very truly,
Samuel Adam ◊ <htt
On Sun, 06 Feb 2011 11:54:37 -0500, Samuel Adam
wrote:
> On Sun, 06 Feb 2011 11:41:03 -0500, Teg wrote:
>
>> Hello Yves,
>>
>> You could alway mime/uu/yenc encode it into text before insert, and do
>> the reverse when you retrieve it. Then the problem goes a
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey, its agents, and its officers did.”
http://www.youtube.com/watch?v=iT2hEwBfU1
On Sun, 06 Feb 2011 10:53:05 -0500, Yves Goergen
wrote:
> On 06.02.2011 14:36 CE(S)T, Samuel Adam wrote:
[snip]
>> * Make sure the binding is done as BLOB and not TEXT. PDO probably has
>> its own flags defined for this. This is the part that tells SQLite
>> whet
f them offers full access to all the useful features
provided by SQLite3’s C API. Sorting out which library and version is
being used in each place can be a pain, too, as briefly seen (but not
really explored) in a thread I was involved in last week.
Very truly,
Samuel Adam ◊ <http://c
"Test";
3
1
sqlite> SELECT typeof("") FROM "Test";
text
text
sqlite>
I understand that both the reliance on zero-termination and the lack of
validation are architectural decisions, and thus “features” rather than
“bugs”. Yet it does bear pointing out that thi
value” rather than
“string”.)
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey, its agents, and its officers did.”
http://www
On Sun, 06 Feb 2011 08:10:49 -0500, Yves Goergen
wrote:
> On 06.02.2011 13:52 CE(S)T, Samuel Adam wrote:
>> For the original poster: To prevent problems like this, if it will
>> always
>> be a BLOB then add a constraint to your table:
>>
>> CHECK (typ
n INSERTs a bit; data integrity is more important, as
you have just seen.
Very truly,
Samuel Adam ◊ <http://certifound.com/>
763 Montgomery Road ◊ Hillsborough, NJ 08844-1304 ◊ United States
Legal advice from a non-lawyer: “If you are sued, don’t do what the
Supreme Court of New Jersey,
d.
>
> Ralf
Does the crash also occur when the zero occurs naturally, or is that
codepath not exercised? Perhaps an assert() is in order.
Very truly,
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304 • United States
http://certifound.com/
On Mon, 31 Jan 2011 15:33:24 -0500, Gabe da Silveira
wrote:
> On Mon, Jan 31, 2011 at 7:42 PM, Samuel Adam wrote:
>
>> I suggested rewriting your schema. Non-TEXT data which will not be
>> subjected to a MATCH search is best stored in another table and JOINed
>> wi
On Mon, 31 Jan 2011 14:05:15 -0500, Gabe da Silveira
wrote:
[...]
> On Mon, Jan 31, 2011 at 1:24 PM, Samuel Adam wrote:
[...]
>>* Is the database being populated with parameter binding, or
>> not? If so,
>> is id being bound as SQLITE3_INTEGER? (I don’t k
On Mon, 31 Jan 2011 13:37:35 -0500, Samuel Adam
wrote:
> The FTS3
> columns declared INTEGER indeed seem to behave as regular INTEGER columns
> in regular, non-MATCH queries (although I did not test to see if affinity
> would coerce a '1' to INTEGER on insertion).
No c
hat
intended? It rather uglifies things.)
Very truly,
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304 • United States
http://certifound.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Mon, 31 Jan 2011 12:34:24 -0500, Samuel Adam
wrote:
> According to the docs, results from those queries should be reversed. I
> suspect that Mr. da Silveira’s different platforms actually have
> different SQLite versions, and that one version is consistent with the
> docs
ount = 999
sqlite> SELECT * FROM "Test" WHERE "id" = '101';
sqlite>
According to the docs, results from those queries should be reversed. I
suspect that Mr. da Silveira’s different platforms actually have different
SQLite versions, and that one version is
On Mon, 31 Jan 2011 11:46:21 -0500, Samuel Adam
wrote:
> On Mon, 31 Jan 2011 11:05:13 -0500, Simon Slavin
> wrote:
>
>> In the definition given in the original post, which I quoted, the table
>> was defined as follows:
>>
>>> CREATE VIRTUAL TABLE Directo
to address the original poster’s question:
sqlite> SELECT * FROM "Test" WHERE "id" = 101;
id = 101
Content = This is a test.
sqlite> SELECT * FROM "Test" WHERE "id" = '101';
sqlite>
You were right; I was wrong. I saw FTS
On Mon, 31 Jan 2011 08:44:22 -0500, Simon Slavin
wrote:
> On 31 Jan 2011, at 1:24pm, Samuel Adam wrote:
[snip]
>> Actually since this is an FTS3 table, the form with the quotes is the
>> correct one. As Mr. da Silveira alluded later in his post, in FTS3, the
>> row ID a
o check
to see where your PHP is getting its sqlite3 with fts3 support.
Better approach: Cut PHP from the equation and examine the databases in
the sqlite3 shell. Core function typeof() might be helpful to see if the
tables actually contain different data
r the docs is good, probably should have
its own thread to discuss how to implement.
best wishes,
Adam
On Tue, Jan 11, 2011 at 9:09 AM, Philip Graham Willoughby <
phil.willoug...@strawberrycat.com> wrote:
> On 11 Jan 2011, at 13:36, Andy Gibbs wrote:
>
> > On Tuesday, January 11,
does prevent an executable from running with a
debugger open. It may be that newer versions of compiler or key will work,
but I can't say that they will (nor does safenet's technical "support"
actually provide answers). Bitter experience so far says "Don't use HASP
for da
o the officially released
code.
Now, after showing that my 64 bit problems go away when I include the
amalgamation source in the project, the whining just stops.
thanks
:)
Adam
On Fri, Dec 17, 2010 at 5:20 PM, Simon Slavin wrote:
>
> On 17 Dec 2010, at 4:30pm, Adam DeVita wrote:
>
>
Will a 64 bit Windows DLL eventually be posted for download?
On Fri, Dec 17, 2010 at 9:45 AM, Eric Smith wrote:
> On Fri, Dec 17, 2010 at 4:36 AM, giuseppe500 wrote:
> > There is a version of SQLite 3 for 64-bit systems?
> > or, you can simply compile the source of sqlite3 at 64-bit with c++
arser. Somewhere in a sqlite__columns table would be totally fine
too.
In summary, the enforcement of foreign key constraints is not the only
use case for the pragma. While the enforcement use case is now
removed, the rest still remain.
Adam K
On 9 December 2010 06:44, Richard Hipp wrote:
>
On Fri, 26 Nov 2010 08:40:42 -0500, Jean-Christophe Deschamps
wrote:
> At 14:26 26/11/2010, [Samuel Adam ] wrote:
>
>> N.b., there is a severe bug (pointers calculated based on truncated
>> 16-bit
>> values above plane-0) in a popular Unicode-properties SQLite extensi
r when I discovered it, but
was unable to find a private contact method on a brief glance through the
author’s site. Perhaps the bug has been fixed by now; I never checked
back; anyone who intelligently investigates compiler warnings would not be
bitten anyway. I write off the whole
ease answer this urgent question, as I am bad at math and I’d
like to get to the bottom of it.
free(OT); return 0; }
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304
United States
http://certifound.com/
([0] …with extraneous spaces becau
matura”.
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304
United States
http://certifound.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
vantage of a hypothetical faster-than-memcmp()
function.
Those are the only two SQLite3 datatypes capable of holding a 16-byte
value.
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304
United States
http://certifound.com/
___
sqlite-users
On Wed, 03 Nov 2010 19:17:48 -0400, Samuel Adam
wrote:
> SQLite uses its own variable-length integer representation
> internally, occupying between 1 and 64 bits per value; if this is for a
Sorry to reply to my own post; I wish to be precise. By “internally”, I
meant (and should hav
robably also
be done in your protocol’s representation.
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304
United States
http://certifound.com/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/lis
e in characters; since the cast will
only return values <127, the result will be in bytes for UTF-8 and half
the byte-size for UTF-16.
Casting to BLOB will not fix this, as the value is still first cast to
TEXT.
Samuel Adam
763 Montgomery Road
Hillsborough, NJ 08844-1304
United
Why would you want to do this in plane sql, as opposed to using the API to
go through the list and derive it?
On Fri, Oct 1, 2010 at 3:37 PM, Andy Chambers wrote:
> Given the following
>
> create table events (
> id,
> date,
> status
> );
> insert into events values ('001','a','N');
> in
Are you looking for
http://www.sqlite.org/c3ref/funclist.html
?
On Fri, Aug 13, 2010 at 12:37 PM, Peng Yu wrote:
> Hi,
>
> http://www.sqlite.org/docs.html
>
> I don't see a table that shows all the available functions in sqlite3.
> Would you please let me know if there is such a table?
>
> --
suming that one letter is all you are after,
either 'starts with' or 'contains' and not in order combinations.)
Adam
On Thu, Aug 5, 2010 at 5:40 PM, Simon Slavin wrote:
>
> On 5 Aug 2010, at 10:03pm, Sam Roberts wrote:
>
> > But do you think the section would
and don't use strcpy
here is why
https://buildsecurityin.us-cert.gov/bsi-rules/home/g1/848-BSI.html
On Fri, Jul 9, 2010 at 3:06 PM, rollerueckwaerts
wrote:
>
> Hello,
> I try to get an sql query string from 2 const chars.
>
> const char *language;
> language = "'6'";
> const char *sql2 = "SELECT
read through
http://www.sqlite.org/c3ref/bind_blob.html
There are lots of examples on the list of binding.
regards,
Adam
On Fri, Jul 9, 2010 at 3:06 PM, rollerueckwaerts
wrote:
>
> Hello,
> I try to get an sql query string from 2 const chars.
>
> const char *language;
> langua
Is it possible for the list admin to seed a message to the list that, if
auto-replied, would automatically remove one from the list?
This thread, although off the sqlite topic, is still interesting.
regards,
Adam
On Mon, Jun 14, 2010 at 10:06 AM, Black, Michael (IS) <
michael.bla...@ngc.
on dates.
(How many sales did we make this month?)
regards,
Adam
On Wed, Jun 9, 2010 at 9:09 AM, Oliver Peters wrote:
> Hello,
>
> despite it's just a question about construction I hope somebody is willing
> to
> push me into the right direction if necessary.
>
> my si
dir\db2.db' as 'db2'
Suppose both files have a table named 'some_table'.
select * from db2.some_table ; /*refers to the attached db*/
select * from main.some_table ; /*refers to the db you first made a
connection with.*/
I find the command line tool wonderful for testing o
start by doing an open db1 (as main)
then attach path to db2 as 'db2'
insert into main.table_one_name select * from db2.table_one_name ;
This selects all records from db2 and puts them into db1 in one statement.
Adam
On Tue, Jun 8, 2010 at 3:02 PM, Scott Frankel wrote:
>
> Hi
re request: DECIMAL type (such as IEEE 754-2008
BCD format). Why? Humans use decimal; computers ought be made to serve
humans, not vice versa; and if you put a penny into a database, you should
be able to get a penny back out.
Very truly,
Samuel Adam http://certifound.com/+A
763 Mon
Yes.
One can also
attach 'somedatabase path' as anothername ;
and you can run a query accessing both at the same time.
regards,
Adam
On Tue, May 11, 2010 at 1:45 PM, john cummings wrote:
> hi all,
>
> i'm new to this forum and sqlite.
>
> is it possible to have
but...
...but I LOVE my hammer! How dare every problem not be a nail?
;)
Good point. Likely all the updates can fit nicely into a transaction.
On Mon, May 10, 2010 at 5:11 PM, Simon Slavin wrote:
>
> On 10 May 2010, at 9:25pm, Adam DeVita wrote:
>
> > Simon, can you exp
y d on
x.property1 =d.property1 and x.property=d.property2 and x.property3
=d.roperty3
where x.comboid=-1;
This somehow feels like cheating, though it seems to produce an acceptable
result quickly enough (on my relatively small db)
Adam
On Sun, May 9, 2010 at 5:23 PM, Simon Slavin wrote:
>
Is there a primary key on the table?
Is it possible to use insert or replace instead of update, and then not
reference the column you want to set as a default?
On Thu, May 6, 2010 at 10:41 AM, Andy Gibbs wrote:
> > You could write a trigger that sets default value if NULL is inserted
> > or set
Is it possible there is a null, tab, newline or other invisible character?
Try
select timeStamp, '' || resourceType || 'xx' From MyTable where
resourceType like 'PSM' LIMIT 10;
On Fri, Apr 30, 2010 at 9:53 AM, ecforu wrote:
> I don't think it is a case issue. See below from sqlite3 co
Could you include a bit more information about your post? (Version number,
operating system etc.)
I'm unsure if you have compiled something or are using the command line
tool.
There are lots of very knowledgeable and helpful people on the list.
On Thu, Apr 22, 2010 at 6:31 PM, Derek Martin wro
good ideas.
The spread sheet trick hadn't occurred to me. I think I'll go that route
since it keeps things user readable
thank you for your thoughts, all.
regards,
Adam
On Thu, Apr 22, 2010 at 2:51 AM, Oliver Peters wrote:
>
> Adam DeVita writes:
>
> >
> [...]
&
n
parsing the string to get ye year, month, day, day of year, age from epoch,
month name, etc?
regards,
Adam
On Wed, Apr 21, 2010 at 3:59 PM, P Kishor wrote:
> On Wed, Apr 21, 2010 at 2:37 PM, Adam DeVita wrote:
> > Yes.
> >
> > A Date dimension is a table that has
p://en.wikipedia.org/wiki/Dimension_(data_warehouse)<http://en.wikipedia.org/wiki/Dimension_%28data_warehouse%29>
> .
> But I don't have any answer to the question asked.
>
>
> Pavel
>
> On Wed, Apr 21, 2010 at 3:21 PM, P Kishor wrote:
> > On Wed, Apr 21, 2010 at 1:
ering if there is somewhere to download a pre-defined
Date Dimension? I could write my own script, but re-invent and debug the
wheel?
regards,
Adam
--
VerifEye Technologies Inc.
905-948-0015x245
7100 Warden Ave, Unit 3
Markham ON, L3R 8B5
Canada
_
Is this a 1 off import? If so, perhaps the command line tool can .read it.
On Fri, Apr 9, 2010 at 2:13 PM, Shaun Seckman (Firaxis) <
shaun.seck...@firaxis.com> wrote:
> Greetings,
>
> I've got a .SQL file that contains multiple SQL insert statements for
> various tables as well as comments embed
How does
$ time sqlite3 test32k.db "select count(1) from role_exist"
perform?
On Thu, Apr 1, 2010 at 5:52 AM, Alexey Pechnikov wrote:
> Hello!
>
> $ time sqlite3 test32k.db "select count(*) from role_exist"
> 1250
>
> real0m58.908s
> user0m0.056s
> sys 0m0.864s
>
> $ sqlite3 test
Good day,
For the sake of fun, I have to share this - especially with tall this talk
of binding all the parameters.
void poem(CString pth)
{
sqlite3_stmt *ppStmt; //statement pointer
sqlite3 *db; //database
const char *pzTail;
char *pzerr;
if( sqlite3_open(pth, &db) ){
.
regards,
Adam
On Tue, Mar 2, 2010 at 2:37 PM, Kavita Raghunathan <
kavita.raghunat...@skyfiber.com> wrote:
> Simon and Gabriel,
>
> I'm using the C API, I'm inserting strings. One of the strings happens to
> have an "'" in it. I have to write extra code to p
Create the table using single quotes around the strange name.
sqlite> create table x (boomer int, 'squid-nick' text);
sqlite> insert into x values (1,'asdlh');
sqlite> select * from x;
1|asdlh
sqlite> select squid-nick from x;
SQL error: no such column: nick
sqlite> select 'squid-nick' from x;
sq
or to integration
on trunk. I don't know if/when those changes will be pulled into the main
repository trunk (I do know it's a significant effort to fully review, audit
and ensure test & branch coverage).
- adam
On Jan 19, 2010, at 12:40 AM, Jens Miltner wrote:
>
> Am 16
One may be able to make "measurement type" a column, thus eliminating the
need for a column for each type.
Some speed may be recoverable with indexing.
regards,
Adam
On Tue, Jan 12, 2010 at 1:21 PM, Pavel Ivanov wrote:
> > so normalization would lead to a doubling
> >
by making an encoded column to
aggregate, such as lots of mutually exclusive binary flag fields.
regards,
Adam
On Mon, Jan 11, 2010 at 3:46 PM, Stefan_E wrote:
>
> Hello all,
>
> I'm considering using SQLite for a new application. The schema will contain
> a bunch of small tabl
Apologies, that should be...
http://svn.ali.as/cpan/trunk/DBD-SQLite/Makefile.PL
2010/1/3 Adam Kennedy :
> The build code we're using is run across all operating systems.
>
> You can see the actual build script here.
>
> http://ali.as/cpan/trunk/DBD-SQLite/Makefile.PL
&
101 - 200 of 271 matches
Mail list logo
