>And every reply, even if it is not helpful, is worthy of grateful
>thanks because it is being provided free by a list member.
This is why i put help in quotes.
Please tell me how helpfull comments like:
"Rule 1: Assume nothing. Demand proof.
"
"So produce believable evidence.
"
"Nobody is going
yes the example works as expected. This is the first step in debugging this
problem which could of course turn out to be my code. But since you were baying
for something to execute... I should also say that it is interesting to note
the "vigor" with which some of you are 'helping'!
The next
To make it really easy, I have created three .sql files and an application that
is NOT command line akward. There are three .sql files with the statements
needed to create two databases and execute the outer join.
Drag and drop them onto the application to execute them...
Hello,
There is no need to get upset. I am trying to simplify the table names and
column names to make your life easier...
You can assume that I have carefully studied the responses I got and tried
everything suggested. I have also read all the links given. Thank you for those
I then
I have read and searched but I am not able to get the following statement to
run:
SELECT MyID, Zip FROM TableOne d LEFT OUTER JOIN DatabseTwo.sdb.TableTwo n ON
n.MyID=d.MyID WHERE d.Zip > 8 ORDER BY d.Zip
I just get error at "."
I tried specifiying the databse name without the file
Thnk you for your thoughts. I have learned a few things as always.
There is a tenency these days to question the question these days
as most developers could benefit from a better design. It tends
to divert the question in directions that were not intended
and requires defending the underlying
Yes this is the first SELECT Querie that returns a result set.
- The Client app launches and opens a connection,
- A TRANSACTION is begun
- Multiple UPSERTS are performed if data is available ( about 5k rows of:
REPLACE INTO MyTable ( RowID, UpDtUNIX, Zip, cCode, RecID, jDate, Blob1, Blob2,
I am using
sqlite3_prepare_v2()
to process my SQl queries. This takes around 80% of the processing time
compared to recovering the result set.
Once the querire has been processed i can obviously provide a progress bar when
stepping through the result set, but what progress indication is
I am using
sqlite3_prepare_v2()
to process my SQl queries. This takes around 80% of the processing time
compared to recovering the result set.
Once the querire has been processed i can obviously provide a progress bar when
stepping through the result set, but what progress indication is
, 2008 at 6:33 PM, Derek
Developer
wrote:
> Dennis thank you for taking the time to explain that. I have read the
> Architecture page and I think I have a better idea.
>
> Since this does seem to be a viable way to protect the data I would like to
> implement the schema, but usi
>No, the index is stored in a separate Btree. The master table simply
>stores the page number of that btree's root page. With that information
>SQLite can read and decrypt the index's root page and begin a O(log N)
>search for the first matching record, reading in and decrypting more
>pages as
dary
column.
Before I implement this, I wanted to make sure I understand the implementation
at the page level. Obviously a single Row can take up more than one page, but I
am still not clear if a single page can ever contain more than one Row?
Igor Tandetnik <[EMAIL PROTECTED]> wrote:
/archive/2005/12/22/506931.aspx
If I am storing CC# or SS#, the index would contain them yes?
Igor Tandetnik <[EMAIL PROTECTED]> wrote: Derek Developer
wrote:
> Thank you for your replys, but I am still not sure I understand how a
> Query is executed on (page) encrypted data w
appreciate a detailed explanation.
Cory Nelson <[EMAIL PROTECTED]> wrote: On Sun, Aug 24, 2008 at 12:36 AM, Derek
Developer
wrote:
> Well that implies that the "parsing" decrypts each page in the database for
> each query. How else would it traverse a key that is encypted
Well that implies that the "parsing" decrypts each page in the database for
each query. How else would it traverse a key that is encypted?
Isn't that going to be very slow?
Cory Nelson <[EMAIL PROTECTED]> wrote: On Sun, Aug 24, 2008 at 12:07 AM, Derek
Developer
wrote:
> I
I am still not clear if page level encryption permits equality searches and
range searches?
Intuitively it would seem that these searches would require every page to be
decrypted to access the column data for each record...
unless a proxy Index is used as suggested here
We are in Beta with a windows tool:
The RemSQL Library consists of standard dynamic link libraries (DLLs) that can
be used in a wide variety of programming languages. Because most programming
languages
support calling functions exported from a DLL, the Library Edition provides the
broadest
Just wanted to check that there is no "reset" statement that I can use with
UPDATE's.
My understanding is that for multiple Row updates the complete sequence needs
to be executed for each row ie:
"UPDATE mytable SET ' name=?, street=?, Phone=? WHERE ROWID=333"
Prepare
Bind the data
step
In trying to break my code with the seinfeld database examples, I found this.
SELECT f.name as food, e1.name, e1.season, e2.name, e2.season FROM episodes e1,
foods_episodes fe1, foods f, episodes e2, foods_episodes fe2
Why does this put SQLite into an endless loop?
(I am not using the shell tool,
In SQLite a NUL is nothing. Inserting a NUL into a column defined as Integer
for example creates a zero length entry not an Integer of value zero.
How do traditional databases with static typing deal with this?
Do they check the column delaration and convert the NUL to a zero value upon
entry?
(2nd attempt... bounced back for some reason...)
In testing a my code I came across this example.
Could someone help me understand what this syntax is doing please
(from the Seinfeld demo database examples)
...m col
...h on
...w 20 17 6 23 6
...e on
Is this some form of typecasting?
This is
In testing a my code I came across this example.
Could someone help me understand what this syntax is doing please
(from the Seinfeld demo database examples)
..m col
..h on
..w 20 17 6 23 6
..e on
Is this some form of typecasting?
This is how they are used
SELECT f.name as food, e1.name,
Is it possible to search a sequence of bytes within a BLOB?
Lets say i have a BLOB that contains 4 text fields 32 characters long ie
firstname, lastname, street, city.
Can I form a query that looks something like:
SELECT Bytes33to64 FROM MyTable WHERE Bytes33to64 LIKE 'Jones'
instead of
SELECT
I watched the google? video presentation DRH gave (very nice, thank you). I was
interested to hear him suggest using SQLite Tables as persistent storage for
Objects/UDTs. I want to do this for an application that has a very well defined
UDT that is used throughout the application. It would make
24 matches
Mail list logo