Is there any way to SELECT out the row number of returned results in a
query?
For example:
SELECT row_number(), value from some_table;
1 ValueA
2 ValueB
3 ValueC
... etc ... ??
What I really want this for is a query where I am inserting from table A
into table B, and table B has a column
On 5/18/05, Gerhard Haering <[EMAIL PROTECTED]> wrote:
> On Wed, May 18, 2005 at 10:22:39AM -0500, Mike Owens wrote:
> > What about sqlite3_set_authorizer()? Implement a callback function and
> > monitor changes in transaction state for each connection object: [...]
>
> Didn't try, yet. But does
If anyone is interested on Modified Preorder Tree Traversal Algorithm
and has PHP5 on its PC, here is the class with an example file:
class: http://www.devpro.it/code/85.html
example_file: http://www.devpro.it/examples/TEST_SqliteMPTTA.zip
Thank you for debugging.
Regards,
Andrea Giammarchi
Will Leshner wrote:
On May 18, 2005, at 8:02 AM, Jay Sprenkle wrote:
When I wrote applications that allowed the user to enter queries
I added the unique key row to their query. I presented them with the
data they requested and either did not show the record id, or made
it read only. This allowed
It gets worse when you throw in journaled file systems. The problem linux
faces is there are many filesystems you can pick, so the kernel/system needs
to be a bit wishy-washy and leave some implementation details up to other
codes. I think if your using ext3 (in data=journal and data=ordered
Hi Mike,
good to know you're still around :-)
On Wed, May 18, 2005 at 10:22:39AM -0500, Mike Owens wrote:
> What about sqlite3_set_authorizer()? Implement a callback function and
> monitor changes in transaction state for each connection object: [...]
Didn't try, yet. But does this get called
On May 18, 2005, at 8:22 AM, Mike Owens wrote:
What about sqlite3_set_authorizer()? Implement a callback function and
monitor changes in transaction state for each connection object:
open_database(...) {
...
sqlite3* db = ...
connection_object* object = ...
Stuff below relates to IDE drives.
On Linux, the fsync() call doesn't actually force that the data reaches the
physical disk platters. It just makes sure that the data is sent to the
cache on the disk.
On Windows, FlushFileBuffers() forces the disk to actually write the data to
the physical
In pysqlite, I need to keep track of the transaction state (in
transaction/not in transaction). To handle ON CONFLICT ROLLBACK in
pysqlite correctly, I need to be able to query the transaction state.
As I see it, that's currently not possible. Am I mistaken?
Otherwise, could you please
Christian Smith wrote:
> No, because *every single* write to that handle will involve a sync to the
> underlying device! That would decimate performance.
> Using a single FlushFileBuffers batches multiple write's in a single sync
> operation.
> That this hurts performance on Windows says more
On Wed, 18 May 2005, Ludvig Strigeus wrote:
>Link:
>http://searchstorage.techtarget.com/tip/1,289483,sid5_gci920473,00.html
>
>Quote: "FlushFileBuffers is an API call that forces all data for an open
>file handle to be flushed from the system cache and also sends a command to
>the disk to flush
Link:
http://searchstorage.techtarget.com/tip/1,289483,sid5_gci920473,00.html
Quote: "FlushFileBuffers is an API call that forces all data for an open
file handle to be flushed from the system cache and also sends a command to
the disk to flush its cache (contrary to the name, this call
How about using the FILE_FLAG_WRITE_THROUGH to CreateFile on Windows?
Description:
Instructs the system to write through any intermediate cache and go directly
to disk. The system can still cache write operations, but cannot lazily
flush them.
I guess you can remove a few of the calls to
I believe you are wrong. The rowid is the primary key in the SQLite
B-tree representation. It is always unique and allows you not to use
your own primary key. But if you have a column of type INTEGER PRIMARY
KEY, the values in this column become rowid. Otherwise a new
autoincremented column is
14 matches
Mail list logo