On Thu, Nov 12, 2015 at 6:44 PM, J Decker wrote:
> So... I guess something like this works; other than the triplication
> of the initial path string. works for read-only access... doesn't
> return where it failed (although can with leaf == 0 )
>
You can use multiple WITHs to get rid of some of t
On 11/12/2015 03:44 PM, James K. Lowden wrote:
> Fork? Isn't that what CreateProcess is for?
I think not. That's a lonesome chopstick.
--
Christian Werner
Having an "array of values" in a single field violates zero'th normal form and
therefore cannot be represented nor manipulated efficiently in a algebraically
correctly implemented Relational Database. You would need one with
non-relational extensions which handle such non-relational data in th
On Thu, Nov 12, 2015 at 4:52 PM, J Decker wrote:
> > So something like "select value from option_map_view where path is
> > set type>"?
> > A path name like '/system/device/com port/1' is used as an array of names
> > here. Only the indexing with intst and substr is laborious. Maybe some
> > fut
> So something like "select value from option_map_view where path is set type>"?
> A path name like '/system/device/com port/1' is used as an array of names
> here. Only the indexing with intst and substr is laborious. Maybe some
> future SQLite version includes a group_split function to make this
12 nov 2015, om 07:02, J Decker:
> So I've used CTE to solve a simple problem... I'm tempted to use it to
> fix more problems... but I'm wondering how to select different values
> at different levels. I know there's like 'select * from table where
> column in ( set,of,things) ' but can I index in
On 2015/11/12 8:02 AM, J Decker wrote:
> So I've used CTE to solve a simple problem... I'm tempted to use it to
> fix more problems... but I'm wondering how to select different values
> at different levels. I know there's like 'select * from table where
> column in ( set,of,things) ' but can I i
Hi,
I'm a developer with the AstLinux project and we cross-compile for x86 embedded
hardware using the "autoconf" version of sqlite.
When upgrading from SQLite 3.8.9 to 3.9.2 I noticed our binary image grew by
about 600KB, the culprit was the /usr/bin/sqlite3 shell tool is now statically
linke
On 11 Nov 2015, at 10:38pm, Adams, Justin
wrote:
> VARCHAR(20)
Not a solution to the problem or a diagnosis of the bug, it's worth saying that
SQLite has no VARCHAR type. Columns where you specify VARCHAR will be
understood as TEXT, and truncation will never occur.
Simon.
On Nov 12, 2015 7:44 AM, "James K. Lowden" wrote:
>
> On Tue, 10 Nov 2015 13:45:52 -0700
> Warren Young wrote:
>
> > This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet,
> > DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry,
> > Access, SQL Server Express?
>
> The
So... I guess something like this works; other than the triplication
of the initial path string. works for read-only access... doesn't
return where it failed (although can with leaf == 0 )
option4_map ( option_id,parent_option_id,name_id )
option4_names ( name_id, name )
option4_values ( option_i
On Tue, 10 Nov 2015 22:20:59 +0100
"Christian Werner" wrote:
> When SQLite is the spoon, will they give us Linux binary
> compatibility for the fork?
Fork? Isn't that what CreateProcess is for?
--jkl
On Tue, 10 Nov 2015 13:45:52 -0700
Warren Young wrote:
> This from the same company that gave us ODBC, ESQL, OLE DB, MDAC/Jet,
> DAO, RDO, ADO, ADO.NET, ADO Entity Framework, LINQ, the registry,
> Access, SQL Server Express?
The real irony is that every one of those technologies had (I'll bet)
m
On Thu, Nov 12, 2015 at 7:16 AM, E.Pasma wrote:
> 12 nov 2015, om 07:02, J Decker:
>
>
>> So I've used CTE to solve a simple problem... I'm tempted to use it to
>> fix more problems... but I'm wondering how to select different values
>> at different levels. I know there's like 'select * from tabl
Outstanding!
it is kudos which is so richly deserved, and IMHO, an example of REAL
integrity earned. Over the years I have watched as SQLite developed,
learned much from this list, and was impressed by Dr Hipps hands-on
leadership in directing development in what he and the team deemed an
appropri
On 11/11/15, Adams, Justin wrote:
>
> I was trying to create a table with a column for IPv4 addresses as VARCHAR.
> It seems when I set the .mode to column that some records are truncated on
> the right. Changing the .mode fixes the problem, so I would think it has to
> do with the column width ca
On 11/12/2015 1:02 AM, J Decker wrote:
> would like to do something like ' select value from option_map where
> name is ["system","device","com port", "1" ] ' where the program
> statement would look more like
>
> GetOptionValue ( "/system/device/com port/1" ) where the name is
> really sort of re
17 matches
Mail list logo