Re: [sqlite] sqlite_column_table_name() and table alias name

Hi Peter, Currently the query result returned by node-sqlite3 has the rows formatted into objects all ready. Given SQL `SELECT foo.*, bar.* FROM foo JOIN bar`, the columns of foo and bar collide with each other. I've already sent a PR https://github.com/mapbox/node-sqlite3/pull/932

Re: [sqlite] sqlite_column_table_name() and table alias name

Jake. Maybe somebody else can see the patch. There's a login screen at the linked page. Others are using Node.js with the current version of SQLite. Are you sure that patch is needed? If you can briefly explain what's not working I'm sure somebody else will reply. Peter On Sun, Jan 14, 2018

Re: [sqlite] possible bug: separator string and quote mode

Pamela. Shell .mode quote uses hardwired separator, presumably to rule out errors when the mode is requested to generate SQL compatible strings. It seems to me the enhancement you're requesting could be made backward compatible by using p->colSeparator instead of the hardwired ',' and then

Re: [sqlite] sqlite_column_table_name() and table alias name

Hi, My apologies if it's impolite to reply to such an ancient thread. I've encountered the same problem while implementing an object-relational mapping library for Node.js. Is there any chance that OP's patch gets merged into master? If this email weren't able to get related to the original

Re: [sqlite] sqlite3_column_decltype and max and min

Igor, Two comments: - Why Homebrew? Because it's an invaluable tool for keeping up with the latest release of not just SQLite but every installed package of interest. - I think you missed the point. Niall is referring to the SQLite3 executable, not just the C source file. The excutable is

[sqlite] possible bug: separator string and quote mode

I have been using SQLite for a small data-processing application. I am hoping to get quote mode output with a field separator that is not a comma.Many thanks, Pamela-- Problem Quote mode output ignores separator string Background https://www.sqlite.org/cli.html5. Changing Output

Re: [sqlite] os_unix.c:36136: (2)

On 12 January 2018 at 07:21, wei1.z wrote: > What is the meaning of this line? > > 01-11 14:40:59.733 10011 2864 2877 E SQLiteLog: (14) os_unix.c:36136: (2) > open() - > > db file cannot be found, or permission issue ? > To decipher this in future, the first number in

Re: [sqlite] Can an SQL script be built from within sqlite?

On 1/14/18, Simon Slavin wrote: > > I’ve never seen anyone compile sqlite3 (the shell tool) for iOS. Android I > have even less idea about. Can you run command-line tools on Android ? Has > anyone compiled sqlite3 for it ? > You can easily compile and run all of the

Re: [sqlite] Can an SQL script be built from within sqlite?

I use Termux on Android. Very useful build of sqlite available there. Regards. Brian P Curley On Jan 14, 2018 7:42 PM, "Simon Slavin" wrote: > > > On 15 Jan 2018, at 12:30am, petern wrote: > > > Shane. That's very interesting considering

Re: [sqlite] Can an SQL script be built from within sqlite?

On 15 Jan 2018, at 12:30am, petern wrote: > Shane. That's very interesting considering the effort to make the one > thing happen exactly once without external software dependency. On 13 Jan 2018, at 7:33pm, Shane Dev wrote: > I use mainly

Re: [sqlite] Can an SQL script be built from within sqlite?

Shane. That's very interesting considering the effort to make the one thing happen exactly once without external software dependency. Does the capability to write specially named local files but not have a periodic loop nor network capability somehow get your application off the ground? Based on

Re: [sqlite] Can an SQL script be built from within sqlite?

On 14 Jan 2018, at 10:33pm, Shane Dev wrote: > I have found a way achieve this purely in the SQLite shell. The trick is to > make all rows in tcout1 SQL statements and then execute them. That’s clever. Nice one. Simon. ___

Re: [sqlite] Can an SQL script be built from within sqlite?

You can use .output file and .print for most cases (except those that need a calculated result) to simplify your script a bit. -Original Message- From: Shane Dev I have found a way achieve this purely in the SQLite shell. The trick is to make all rows in tcout1 SQL statements and

Re: [sqlite] Can an SQL script be built from within sqlite?

Hi Simon, I have found a way achieve this purely in the SQLite shell. The trick is to make all rows in tcout1 SQL statements and then execute them. sqlite> CREATE TABLE tcout1(sql text); sqlite> CREATE TABLE tcout2(sql text); sqlite> insert into tcout1(sql) select "insert into tcout2(sql) select

[sqlite] Defect: single row table cross join causes infinite loop

Consider the hypothetical CTE concerned with displaying the n'th coin flip of a random series as follows. [This is a simplified proxy for any computation where an earlier computed table supplies the parameters for a later computed table.] sqlite> .v SQLite 3.22.0 2018-01-12 23:38:10

Re: [sqlite] Change the update hook from the update hook?

For the record, removing the update hook from the update hook works as expected in both SQLite 3.19.3 and 3.21, with a connection which is opened with the SQLITE_OPEN_NOMUTEX flag, and the guarantee that no two threads use the same connection at the same time. But I'm just not sure if this is

Re: [sqlite] database type graph

merlinverde...@infomed.sld.cu wrote: > How can I design in a database a database type graph? As the first step, by telling us what a "database type graph" is. The meaning was probably lost in translation. Regards, Clemens ___ sqlite-users mailing list

[sqlite] Change the update hook from the update hook?

Hello, Is it valid to change the update hook from the update hook itself? The reason for this question is the following: when a notified database change makes it useless to perform further observation, one may want to remove the update hook alltogether. Can it be done from the update hook

Re: [sqlite] SQLite 3.22.0 coming soon

On Tue, Jan 9, 2018 at 12:30 PM, J Decker wrote: > swarmvtab3 test is still failing... (windows 10, msvc 2017) 10.0.16299.0 > > swarmvtab3-1.2.3... > Error: inconsistent ::dbcache and disk > swarmvtab3-1.3.3... > Error: inconsistent ::dbcache and disk > > This works > > On