Re: [sqlite] New SQLite Forum requires Javascript?

2020-03-13 Thread J Decker
On Thu, Mar 12, 2020 at 10:32 PM Wout Mertens wrote: > Hi, > > I normally wouldn't do this on the internet, but this mailing list > goes deep. Not sure how that will go now that we have to use the > forum, but here goes. > > JavaScript makes websites much nicer to work with, by a wide margin, > e

[sqlite] Write complete pages to journal in VFS?

2020-03-01 Thread J Decker
I've recently changed the underlaying file system driver such that it allocates one of 2 sizes of blocks (4096 or 256), based on how much is written to the file at a time; so a write < 2048 will allocate 256 byte blocks instead; it's not a HUGE performance hit, but I am trying to keep it more on th

Re: [sqlite] more efficient JSON encoding: idle musing

2020-02-25 Thread J Decker
On Fri, Feb 21, 2020 at 6:03 AM Richard Hipp wrote: > On 2/21/20, Wout Mertens wrote: > > The idea is that upon storing the JSON > > data, the JSON1 extension parses it, extracts the layouts recursively, > > stores them when they are not known yet, and then only stores the > > values in the bina

Re: [sqlite] Searching by Guid index in table (.NET)? I can write and read, but not search by the Guid

2020-02-15 Thread J Decker
On Fri, Feb 14, 2020 at 7:36 AM Simon Slavin wrote: > On 14 Feb 2020, at 2:59pm, Andy KU7T wrote: > > > Do you suggest me keeping storing TEXT (and declaring the column as TEXT > instead of GUID) or storing and declaring BLOB (and remove HEX)? > > TEXT. Makes sorting and searching easier. > me

Re: [sqlite] New word to replace "serverless"

2020-01-27 Thread J Decker
Standalone (library / database provider ) native header-only (almost) there's an entry on 'standalone programs' in wikipedia, and there's lots of other libraries that have standalone versions, but it's not a very well defined word. in-process is probably closest (in-process database (interface/

Re: [sqlite] Implementing xLock/xUnlock VFS methods...

2020-01-08 Thread J Decker
On Wed, Jan 8, 2020 at 7:10 AM Dan Kennedy wrote: > > On 8/1/63 20:29, J Decker wrote: > > The documentation isn't very clear on what the intent of an xUnlock( > > SQLITE_LOCK_NONE ) is intended to do. Is it unlock everything? Is it the > > same as remove a

[sqlite] Implementing xLock/xUnlock VFS methods...

2020-01-08 Thread J Decker
The documentation isn't very clear on what the intent of an xUnlock( SQLITE_LOCK_NONE ) is intended to do. Is it unlock everything? Is it the same as remove a shared lock? The first few operations are xLock( SQLITE_LOCK_SHARED ) followed by xUnlock(SQLITE_LOCK_NONE)... sqlite.h.in https://github

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

2020-01-04 Thread J Decker
On Sat, Jan 4, 2020 at 2:59 AM Howard Chu wrote: > Keith Medcalf wrote: > > > > Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s) > performance increase. > > Changing the threading mode or the indirection level of the mutexes > calls seems to have no significant effect. > > > Goes

Re: [sqlite] How to determine the column type? – virtual table?

2019-12-14 Thread J Decker
I just don't see the trouble https://github.com/d3x0r/SACK/blob/master/src/SQLlib/sqlstub.c#L3613-L3680 for each row for each column = sqlite3_column_type( collection->stmt, idx - 1 ) and then get the data according to the type... sqlite3_column_double (for instance) It's not very expensive to g

Re: [sqlite] https://www.sqlite.org/draft/gencol.html Typo

2019-10-29 Thread J Decker
On Tue, Oct 29, 2019 at 5:08 PM Keith Medcalf wrote: > > On Tuesday, 29 October, 2019 16:17, Warren Young > wrote: > > >On Oct 29, 2019, at 7:20 AM, Simon Slavin wrote: > > >One question I had after reading the draft doc is whether an application- > >defined SQLITE_DETERMINISTIC function can be

Re: [sqlite] [EXTERNAL] Limit on number of columns in SQLite table

2019-10-16 Thread J Decker
On Wed, Oct 16, 2019 at 11:03 AM Mitar wrote: > Hi! > > On Wed, Oct 16, 2019 at 3:16 PM Hick Gunter wrote: > > 100k distinct column names? Or is that 1 repeats of 10 attributes? > > 100k distinct names. Like each column a different gene expression. > To me that sounds more like a table disti

Re: [sqlite] Date time input

2019-10-09 Thread J Decker
On Wed, Oct 9, 2019 at 9:05 PM Keith Medcalf wrote: > > On Tuesday, 8 October, 2019 12:40, James K. Lowden < > jklow...@schemamania.org> wrote: > > >OK, but it needs a better name. What better place than here to debate > >that? ;-) > > >What the opposite of "Lite"? > > It's 'ite' as in 'stalagm

Re: [sqlite] Request to get alias of table

2019-08-18 Thread J Decker
e does return 'someTable'. in current Sqlite API there is NO way to get 'ta' from the last query. > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > >-Original Message--

Re: [sqlite] Request to get alias of table

2019-08-18 Thread J Decker
count(*) count from table alias to have a origin column name of 'count(*)' (not null), an alias of 'count' , a table name of 'table' and a table alias of 'alias'. Although the ODBC stuff doesn't actually give you the choice to get the origin names of th

Re: [sqlite] Request to get alias of table

2019-08-18 Thread J Decker
Okay let's start with, I originally had an API compatible with ODBC, which the third information parameter is 'The name of the table, view, alias, or synonym.' https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/odbc/src/tpc/db2z_fncolumns.html Column 1 TABLE_CAT (VARCHAR(128))The name

Re: [sqlite] Request to get alias of table

2019-08-18 Thread J Decker
n option to use without breaking old stuff. > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mai

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
id': 1, 'address.users.address_id': 1, 'address.users.name': 'bob' } > > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message-

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
On Thu, Aug 15, 2019 at 2:53 PM Keith Medcalf wrote: > > Using AS to name columns means NOT using *. One only uses * when one does > not care about column names (or the ordering of the result columns). > Sounds like a personal gospel. This is closer to the test case (yes it doesn't make a

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
> > > > sqlite> select * from ( select count(*)count,* from addresses join users > on users.address_id=addresses.id ) address join pets pet on pet.user_id= > address.users.id; > Error: no such column: address.users.id > > >> console.log( db.do( "select count(*)count,* from ( select count(*)count,*

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
On Thu, Aug 15, 2019 at 12:33 PM J Decker wrote: > > > On Thu, Aug 15, 2019 at 12:24 PM Keith Medcalf > wrote: > >> After fixing the errors in the script (strings are quoted with single >> quotes, not double quotes): >> > .headers on > pragma full_column

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
On Thu, Aug 15, 2019 at 12:24 PM Keith Medcalf wrote: > After fixing the errors in the script (strings are quoted with single > quotes, not double quotes): > sqlite> .headers on > sqlite> create table addresses( id, name ); > sqlite> create table users( id, address_id, name ); > sqlite> create ta

Re: [sqlite] Request to get alias of table

2019-08-15 Thread J Decker
le_alias:pet [ { addresses: { id: 1, name: 'there' }, users: { 'id:1': 1, address_id: 1, 'name:1': 'bob' }, pet: { id: 1, user_id: 1, name: 'odif' }, count: 1, id: [ 1, 1, addresses: 1, pet: 1 ], name: [ 'there', &#

[sqlite] Request to get alias of table

2019-08-15 Thread J Decker
I would really like to get the table alias specified in the query, with an unpatched version of Sqlite. So here's a script... -- .headers on create table addresses( id, name ); create table users( id, address_id, name ); create table pets(id, user_id, name ); insert into addresses(id,name)

Re: [sqlite] Backward compatibility vs. new features (was: Re: dates, times and R)

2019-08-13 Thread J Decker
On Mon, Aug 12, 2019 at 6:54 AM Tim Streater wrote: > On 12 Aug 2019, at 14:30, J Decker wrote: > > > On Mon, Aug 12, 2019 at 5:42 AM Simon Slavin > wrote: > > > >> On 12 Aug 2019, at 1:27pm, Tim Streater wrote: > >> > >> > I don't exp

Re: [sqlite] Backward compatibility vs. new features (was: Re: dates, times and R)

2019-08-12 Thread J Decker
On Mon, Aug 12, 2019 at 5:42 AM Simon Slavin wrote: > On 12 Aug 2019, at 1:27pm, Tim Streater wrote: > > > I don't expect to do that with SQL. My "seconds since the epoch" is > based on converting any particular time to GMT and storing that. That > number is then converted to a date/time with TZ

Re: [sqlite] Hidden data

2019-08-05 Thread J Decker
On Sun, Aug 4, 2019 at 9:40 AM Simon Slavin wrote: > On 4 Aug 2019, at 5:33pm, bitwyse wrote: > > > Could it be hidden in a Blob? > > What program (command?) would diplay it and allow deleting it? > > (VACUUMing doesn't remove it.) > > There's only one program guaranteed to get at every element

Re: [sqlite] readfile() enhancement request

2019-05-17 Thread J Decker
On Fri, May 17, 2019 at 9:34 AM Tony Papadimitriou wrote: > It’s quite often (for me, at least) the case I need to do something like > this from the command line: > > >sqlite3.exe my.db “insert into t values(‘simple field’,’multi-line text > copied from some other app’) > > type con | sqlite3 my.

Re: [sqlite] Help with sqlite3_value_text

2019-04-14 Thread J Decker
On Sun, Apr 14, 2019 at 5:40 AM x wrote: > On second thoughts JD, can’t use strlen or sqlite3_value_bytes in case > values(1) contains more than a single unicode character. This looks OK. > > Bytes are what you need though; it doesn't matter how big the buffer is, as long as you have all of it.

Re: [sqlite] Help with sqlite3_value_text

2019-04-13 Thread J Decker
On Sat, Apr 13, 2019 at 12:04 PM x wrote: > This seems to work OK as a sqlite function. > > > > // assume values[0] & [1] are supplied and not null > > // find Count of values[1] in values[0] > > > > char *c = (char *)sqlite3_value_text(values[0]); > > char *Sep = (char *)sqlite3_value_text(value

Re: [sqlite] Help with sqlite3_value_text

2019-04-12 Thread J Decker
http://utf8everywhere.org/ On Fri, Apr 12, 2019 at 7:51 AM x wrote: > I’m still confused by utf strings. For simplicity, suppose I set up an > sqlite function that takes a single string parameter and I want to scan the > string to count the number of occurrences of a certain character . If I >

Re: [sqlite] ISO8601 vs Numeric Timestamp for Date Storage

2019-02-06 Thread J Decker
From a JS point of view new Date( ISOString )and .toISOString() are quick and available ISO format parsing is NOT that hard it's just a minor varient of parsing floats. (maybe the conversion from parts into numeric?) Haven't bothered to benchmark it. Date Diffs easily avaialble. On Wed, F

Re: [sqlite] Displaying hierarchical structure

2019-01-29 Thread J Decker
Probably just the order by just do 'order by parent_id,name' to group folders together and then alphabetcal? (was expanding it... I would also start with where parent_id=0 ) with recursive foo (id, parent_id, name) as ( select * from folders where parent_id = 0 union all select folders.i

Re: [sqlite] Feat Req Get Aliased Table Name.

2019-01-24 Thread J Decker
/* Number of COLNAME_xxx symbols */ Which "COLANME_N define automatically extends the array to have the appropriate number of entires, then there's a couple generic accessors to store/get from that using the other defined values. On Sun, Mar 18, 2018 at 9:07 PM J Decker wrote: > htt

Re: [sqlite] Building SQLite DLL with Visual Studio 2015

2019-01-21 Thread J Decker
On Mon, Jan 21, 2019 at 2:16 AM John Smith wrote: > Hi, > > > I need to build a data-layer DLL for a large project. > > My project is 64-bit built with Visual-Studio 2015. > > I want to ask about what would be the preferred way to build SQLite: > > 1. Build SQLite code as a separate DLL and use

[sqlite] A few warnings compiling sqlite (-Wextra)

2019-01-04 Thread J Decker
gcc version 8.2.1 20181127 (GCC) sqlite-amalgamation-326 gcc -Wextra -c sqlite3.c (-Wno-fallthrough) the last one ( sqlite3_trace ) is actually a pretty bad conversion, changing a pointer to a u32 and vice versa; but it is only an internal function so maybe it doesn't matter. The rest are

Re: [sqlite] Broken Foreign key

2018-11-13 Thread J Decker
ur parents and all will work just fine. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists

[sqlite] Broken Foreign key

2018-11-11 Thread J Decker
https://d3x0r.org:444/temporary/broken_fk.tgz (30k) this has a .option.db in it and a test.sh. It turns on foreign_keys, selects from the name_id that it says is a forieng key violation, and inserts into option4_map. option4_map has option_id(PK),parent_id(FK option_id),name_id(FK) option4_name

Re: [sqlite] Regarding CoC

2018-10-22 Thread J Decker
On Mon, Oct 22, 2018 at 12:22 PM R Smith wrote: > > On 2018/10/22 7:09 PM, Simon Slavin wrote: > > > > If you're not going to accept those rules, in exactly the translation > used, you might as well pick something entirely different. > > > > Simon. > > Indeed. Further to this, as I understand a C

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
(sorry for the math err s/16/32/g and s/512/256/ - I double and halfed the wrong directions.) On Sun, Oct 14, 2018 at 7:57 AM J Decker wrote: > > > On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote: > >> On 14-10-2018 16:17, Simon Slavin wrote: >> > On 14 Oct 2018,

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 7:24 AM Luuk wrote: > On 14-10-2018 16:17, Simon Slavin wrote: > > On 14 Oct 2018, at 12:56pm, J Decker wrote: > > > >> Is there maybe a compile option for sqlite to fill empty space in a db > with random data rather than 0 ? > > There i

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 7:17 AM Simon Slavin wrote: > On 14 Oct 2018, at 12:56pm, J Decker wrote: > > > Is there maybe a compile option for sqlite to fill empty space in a db > with random data rather than 0 ? > > There is not. But > > (A) It may be an easy chang

Re: [sqlite] Fill empty space with random

2018-10-14 Thread J Decker
On Sun, Oct 14, 2018 at 5:48 AM Bob Gailer wrote: > On Oct 14, 2018 7:57 AM, "J Decker" wrote: > > > > Is there maybe a compile option for sqlite to fill empty space in a db > with > > random data rather than 0 ? > > I don't know about compile opt

[sqlite] Fill empty space with random

2018-10-14 Thread J Decker
Is there maybe a compile option for sqlite to fill empty space in a db with random data rather than 0 ? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite Doc Error ?

2018-09-07 Thread J Decker
https://www.sqlite.org/limits.html *Maximum Length Of An SQL Statement* The maximum number of bytes in the text of an SQL statement is limited to SQLITE_MAX_SQL_LENGTH which defaults to 100. You can redefine this limit to be as large as the smaller of SQLITE_MAX_LENGTH and 1073741824. but fr

Re: [sqlite] sqlite3_column_* with error handling

2018-09-04 Thread J Decker
On Tue, Sep 4, 2018 at 2:11 PM Keith Medcalf wrote: > > On Tuesday, 4 September, 2018 14:00, Clemens Ladisch > wrote: > > >Keith Medcalf wrote: > >> 6) If the column type is SQLITE_BLOB > >> a) Retrieve the column value pointer using column_blob > >> b) If the returned pointer is NULL

Re: [sqlite] Strategies to reduce page-loads?

2018-08-31 Thread J Decker
On Thu, Aug 30, 2018 at 4:48 AM Richard Hipp wrote: > On 8/30/18, t...@qvgps.com wrote: > > > > Structure is simple: > > CREATE TABLE Lines(Id LONG PRIMARY KEY, Label VARCHAR(50), Coordinates > > BLOB, Flags INT, StyleId INT); > > And an rtree-index: > > CREATE VIRTUAL TABLE Lines_bb USING rtre

Re: [sqlite] keys

2018-08-24 Thread J Decker
On Fri, Aug 24, 2018 at 4:31 PM wrote: > "The parent key of a foreign key constraint is not allowed to use the > rowid. The parent key must used named columns only." > > Why is this? > Which would be more efficient? > 1) WITHOUT ROWID and column of INTEGER PRIMARY KEY > or > 2) an aliased rowid.

Re: [sqlite] Invalid Blob Length Error Message

2018-08-17 Thread J Decker
On Fri, Aug 17, 2018 at 5:14 AM Tim Streater wrote: > On 17 Aug 2018, at 01:24, Casey Rodarmor wrote: > > > I wrote an erroneous update statement: > > > > ``` > > UPDATE foo SET bar = x'01234'; > > ``` > > > > The error message was: > > > > ``` > > unrecognized token: "x'01234' > > ``` > > > > *

Re: [sqlite] PRAGMA case_sensitive_like

2018-08-16 Thread J Decker
https://www.sqlite.org/pragma.html#pragma_pragma_list A pragma can take either zero or one argument. The argument is may be either in parentheses or it may be separated from the pragma name by an equal sign. The two syntaxes yield identical results. In many pragmas, the argument is a boolean. The

Re: [sqlite] "Cheating" at making common tables

2018-08-04 Thread J Decker
I did this sort of thing in Xperdex ( https://sourceforge.net/projects/xperdex/ ) which is a C# thing, and enabled easy creation of DataTables similarly auto creating ID and Name by stripping pluralization from the name. Was working on a similar thing for JS; but keep getting distracted making it m

Re: [sqlite] Foreign Key error

2018-07-31 Thread J Decker
noise. On Mon, Jul 30, 2018 at 11:13 PM Clemens Ladisch wrote: > J Decker wrote: > > CREATE TABLE `option4_name` (`name_id` char(36) NOT NULL,`name` > > varchar(255) NOT NULL default '' CONSTRAINT `name` UNIQUE) > > > FOREIGN KEY (`name_id`) REFERENCES `opt

Re: [sqlite] Foreign Key error

2018-07-30 Thread J Decker
x27;; cc47f95a-e79a-11e7-872c-2e6fc90d301f|System Settings I have kinda an old command line tool - but it does the same thing. On Mon, Jul 30, 2018 at 8:11 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"

Re: [sqlite] Foreign Key error

2018-07-30 Thread J Decker
On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get differen

Re: [sqlite] (no subject)

2018-07-30 Thread J Decker
On Mon, Jul 30, 2018 at 7:09 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >> >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_MET

Re: [sqlite] (no subject)

2018-07-30 Thread J Decker
On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get differen

[sqlite] (no subject)

2018-07-30 Thread J Decker
I have these options ... version 3.23.0. "SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0","SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", "SQLITE_DEFAULT_FOREIGN_KEYS=1" This is the end of operations... It's starting to get an option... 13:31:12.541|88A08724~n...@sack.cc(91500):

Re: [sqlite] how to know which database is corrupted

2018-07-24 Thread J Decker
On Tue, Jul 24, 2018 at 5:11 PM Simon Slavin wrote: > On 24 Jul 2018, at 11:34pm, J Decker wrote: > > > If the system rebooted; did a screen size change, and terminated the > > program, it's possible it coild cause corruption. > > Step 1: use the command-l

Re: [sqlite] how to know which database is corrupted

2018-07-24 Thread J Decker
On Tue, Jul 24, 2018 at 1:47 PM Simon Slavin wrote: > On 24 Jul 2018, at 8:43pm, J Decker wrote: > > > I have a database that got corrupted; was working on implementing > automatic > > recovery > > It would be a million times better to figure out how the corrupt

[sqlite] how to know which database is corrupted

2018-07-24 Thread J Decker
I have a database that got corrupted; was working on implementing automatic recovery I have a callback configured on SQLITE_CONFIG_LOG sqlite3_config( SQLITE_CONFIG_LOG, errorLogCallback, 0); Which is global, and does not identify the instance. I figured, I could just easily register the sam

Re: [sqlite] Issue using SEE

2018-07-20 Thread J Decker
On Fri, Jul 20, 2018 at 11:05 AM Keith Medcalf wrote: > > Firstly, the SQLITE_DLL define does not exist (is this a bug in the docs>? > Secondly you did not define SQLITE_HAS_CODEC as required to integrate the > SEE codec/ > Thirdly a .dll file cannot be created with ar. ar is for creating > libr

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

2018-07-09 Thread J Decker
does it have to be text? There was serialization added to sqlite https://www.sqlite.org/c3ref/serialize.html On Mon, Jul 9, 2018 at 5:52 PM Randall Smith wrote: > I'm curious if there is some standard or normal way to convert a SQLite DB > to a text representation, and then recreate the DB

Re: [sqlite] Use with Visual Studio

2018-07-08 Thread J Decker
there's also nuget package for sqlite which handles updates pretty well. (IMO) On Sun, Jul 8, 2018 at 11:13 PM Mike King wrote: > Same here. Again, I download it from the main system.data site. No problems > at all. > > Cheers > > On Mon, 9 Jul 2018 at 06:57, Chris Locke wrote: > > > I use syst

Re: [sqlite] Mailing list shutting down...

2018-06-13 Thread J Decker
On Wed, Jun 13, 2018 at 5:17 PM Simon Slavin wrote: > 13 Jun 2018, at 11:52pm, Bob Friesenhahn > wrote: > > > The problem is knowing what "one" means. The subscription request is > likely submitted via http/https into the web form and using a bogus email > subscription address (of the "victim")

Re: [sqlite] [fossil-users] Mailing list shutting down...

2018-06-13 Thread J Decker
could use Gitter ( https://gitter.in ) is nice; emails on directed messges; retains discussion histories; integrates with various other platforms... git in particular such a referecning issues and pull requests with just # supports markdown formatting; which makes talking about `code fragments` nic

Re: [sqlite] Idea: defining table-valued functions directly in SQL

2018-06-10 Thread J Decker
On Sun, Jun 10, 2018 at 7:48 AM Simon Slavin wrote: > On 10 Jun 2018, at 2:40pm, J Decker wrote: > > > forget contributing code ... but funding? how much can I pay to get > better > > NUL support? > > Can you tell us what's wrong with NUL support ? > I hav

Re: [sqlite] Idea: defining table-valued functions directly in SQL

2018-06-10 Thread J Decker
On Sat, Jun 9, 2018 at 7:37 PM Andy Goth wrote: > > This is probably not going to be added > until SQLite's primary developers themselves decide they need it, or > until someone else decides it's important enough to them to contribute > code and/or funding. > forget contributing code ... but fun

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

2018-06-09 Thread J Decker
On Sat, Jun 9, 2018 at 10:00 AM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > what is your experience with temporary files requested by SQLite3 on > Android? I am using SQLite3 natively on Android - I compiled SQLite3 by > myself - and get an error when SQLite3 tries to create

Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

2018-05-08 Thread J Decker
On Tue, May 8, 2018 at 2:11 PM, Richard Hipp wrote: > On 5/8/18, Francis Kus wrote: > > I am able to open my database file if the path contains no accents. > However, > > if I change even one letter to an accented letter (e.g. replace 'e' with > > 'é'), the database does not open and I get the e

Re: [sqlite] Stored Procedures

2018-05-08 Thread J Decker
maybe Virtual tables? can register functions of various types... mostly since the typical usage of sqlite is as a tightly coupled library, a function in your application is a 'stored procedure'. http://www.sqlite.org/c3ref/update_hook.html There are hooks which would trigger callbacks like trigge

Re: [sqlite] Getting statement column data types on Android

2018-05-07 Thread J Decker
https://www.sqlite.org/c3ref/column_blob.html int sqlite3_column_type(sqlite3_stmt*, int iCol); ? On Mon, May 7, 2018 at 4:28 PM, Bart Smissaert wrote: > Yes, thanks, that might be the best way, but it can get a bit complicated > with complex SQL. > > RBS > > > > On Tue, May 8, 2018 at 12:05 A

Re: [sqlite] Map a field type to a best suited sqlite3_result_* call

2018-05-05 Thread J Decker
On Sat, May 5, 2018 at 4:08 AM, Max Vlasov wrote: > On Sat, May 5, 2018 at 1:19 PM, J Decker wrote: > > > https://www.sqlite.org/c3ref/column_blob.html > > > > The sqlite3_column_type() routine returns the datatype code > > > > > Column api is not suitab

Re: [sqlite] Map a field type to a best suited sqlite3_result_* call

2018-05-05 Thread J Decker
https://www.sqlite.org/c3ref/column_blob.html The sqlite3_column_type() routine returns the datatype code for the initial data type of the result column. The returned value is one of SQLITE_INTEGER, SQLITE_FLOAT, SQLITE_TEXT, SQLITE_BLOB, or SQLITE_NULL. The return value of sqlite3_column_type() c

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

2018-04-28 Thread J Decker
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/gmail/vaG8BpMPov0/JqRR4wk2CQAJ On Sat, Apr 28, 2018 at 3:05 AM, J Decker wrote: > > > On Sat, Apr 28, 2018 at 3:01 AM, Luuk wrote: > >> >> On 28-4-2018 11:26, J Decker wrote: >>

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

2018-04-28 Thread J Decker
On Sat, Apr 28, 2018 at 3:01 AM, Luuk wrote: > > On 28-4-2018 11:26, J Decker wrote: > > On Sat, Apr 28, 2018 at 2:08 AM, Luuk wrote: > > > >> On 28-4-2018 07:36, Luuk wrote: > >>> On 27-4-2018 20:57, Denis Burke wrote: > >>>> I know st

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

2018-04-28 Thread J Decker
On Sat, Apr 28, 2018 at 2:08 AM, Luuk wrote: > On 28-4-2018 07:36, Luuk wrote: > > On 27-4-2018 20:57, Denis Burke wrote: > >> I know steps were taken to reduce it, but just confirming it is still > going > >> on today. > >> ___ > >> sqlite-users mailin

Re: [sqlite] Window functions

2018-04-25 Thread J Decker
What are 'window functions'? If you mean GUI; that's really outside the scope of Sqlite; and whatever environment you're in can provide your GUI; https://www.npmjs.com/package/sack-gui for instance for Javascript(Node.js). On Wed, Apr 25, 2018 at 12:04 PM, Charles Leifer wrote: > Hi, > > I'm su

Re: [sqlite] "Tagging" SQLite tables with attributes for introspection.

2018-04-20 Thread J Decker
You could make a extra table that has a foreign key on sqlite_master and add extra attributes... You could add comments ( -- ) in the create statemtents; and parse those back out ... On Fri, Apr 20, 2018 at 3:52 PM, Randall Smith wrote: > I'm writing some code to do processing of some (but not

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
tring functions, storing and retrieiving STRINGS with NUL characters is easily handled which is why I started with my first response of 'what tool are you actually using?' In the storage, both the length and data are stored. (have been since 3.0 or before) On Thu, Apr 19, 2018 at

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
r any > given value of X -- C strings do not). > > Obviously "javascript" strings contain a length indicator and are not > zero-terminated. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic v

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
On Thu, Apr 19, 2018 at 3:37 PM, J Decker wrote: > > > On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf > wrote: > >> >> Actually, nothing in the C or C++ world will "go past" the NULL byte >> since the very definition of a C string is a "bunch-o-by

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf wrote: > > Actually, nothing in the C or C++ world will "go past" the NULL byte since > the very definition of a C string is a "bunch-o-bytes that are non-zero > followed by one that is". > > that doesnt' mean you can use a custom token structure tha

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
On Thu, Apr 19, 2018 at 1:49 PM, David Raymond wrote: > After a little testing, of the core functions: > > Affected by \x00: > substr > like > length > quote > replace when you're trying to replace the \x00 > > Not affected by \x00: > plain ol select > instr > lower > upper > trim > ltrim > rtrim

Re: [sqlite] SQLite3 - Search on text field with \0 binary data

2018-04-19 Thread J Decker
are you testing this in the sqlite3 shell or in your own program? You should have no issue getting thisdata, sqlite3_column_text followed by sqlite3_column_bytes (the byte count is set when the data is fetched in some format). without modification, you can either excape \0 with'||char(0)||'

Re: [sqlite] Are you getting spam when you post to sqlite-users?

2018-04-17 Thread J Decker
On Tue, Apr 17, 2018 at 3:11 PM, Rich Shepard wrote: > On Tue, 17 Apr 2018, Simon Slavin wrote: > > Okay, that's enough. Thanks for the help, everyone. >> > > Simon, > > FWIW, I haven't seen any spam from this mail list. I do run my own MTA > which aggressively rejects known spam. Over 20 years

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

2018-04-17 Thread J Decker
having replied in this thread I got one. (can the real simon slavin please stand up?) On Tue, Apr 17, 2018 at 3:00 PM, Warren Young wrote: > On Apr 17, 2018, at 3:39 PM, Simon Slavin wrote: > > > > Are you getting a new dating-spam each time you post to this list ? If > you are, please post a

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

2018-04-17 Thread J Decker
march 26, apr 7 I found one each day in 'spam' On Tue, Apr 17, 2018 at 2:39 PM, Simon Slavin wrote: > Dear list-posters, > > Are you getting a new dating-spam each time you post to this list ? If > you are, please post a brief follow-up to this message. Please do /not/ > include any details ab

[sqlite] Constraints must be defined last?

2018-04-11 Thread J Decker
Is there something about SQL that requires constraints to follow all column definitions? sqlite> create table `option4_blobs` (`option_id` char(36) default '0', CONSTRAINT `value_id` UNIQUE (`option_id`),`binary` blob, FOREIGN KEY (`option_id`) REFERENCES `option4_map`(`option_id`)ON UPDATE CASCA

[sqlite] Insert with foreign keys enabled prevented in transaction

2018-04-11 Thread J Decker
I was trying to debug this set of commands, which is actually run on two connections within the same process... but that detail apparently doesn't matter. PRAGMA foreign_keys=on; create table `option4_name` (`name_id` char(36) NOT NULL,`name` varchar(255) NOT NULL default '

Re: [sqlite] Help using 'attach database' or Why is this an error?

2018-04-11 Thread J Decker
On Wed, Apr 11, 2018 at 7:54 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Try this: > > attach database 'test.db' as con2; > ahh that makes sense. I'll split this into a separte thread for the real issue... > > On 4/11/18, 9:51

[sqlite] Help using 'attach database' or Why is this an error?

2018-04-11 Thread J Decker
When I attempt to use attach database I get an error about 'no such column' M:\sqlite3\sqlite3\build>sqlite3 test.db SQLite version 3.23.0 2018-04-02 11:04:16es Enter ".help" for usage hints. sqlite> attach database test.db as con2; Error: no such column: test.db sqlite> I was trying to debug

Re: [sqlite] Fossil Feature Request

2018-03-30 Thread J Decker
On Fri, Mar 30, 2018 at 12:46 PM, Richard Hipp wrote: > On 3/30/18, J Decker wrote: > > Sqlite's Fossile browser can't link line numbers... > > > > > > Add ability to link to lines of source... > > > > > > was trying to share this as

[sqlite] Fossil Feature Request

2018-03-30 Thread J Decker
Sqlite's Fossile browser can't link line numbers... Add ability to link to lines of source... was trying to share this as another reference for getting UTF8 characters from strings #define READ_UTF8(zIn, zTerm, c) https://www.sqlite.org/src/artifact/810fbfebe12359f1 which is like line 15

Re: [sqlite] json question

2018-03-28 Thread J Decker
On Tue, Mar 27, 2018 at 8:22 PM, Ian Zimmerman wrote: > On 2018-03-27 19:26, Keith Medcalf wrote: > > > Actually, it is very simple and straightforward to implement > > hierarchical structures using Relational Database Models. > > But not recursive structures (or to be more precise, recursive que

[sqlite] Feat Req Get Aliased Table Name.

2018-03-18 Thread J Decker
https://sqlite.org/c3ref/column_database_name.html Source Of Data In A Query Result The names returned are the original un-aliased names of the database, table, and column. Okay. and there's... https://sqlite.org/c3ref/column_name.html These routines return the name assigned to a particular c

Re: [sqlite] Question regarding 3.23.0 (pending) and TRUE/FALSE

2018-03-02 Thread J Decker
On Fri, Mar 2, 2018 at 4:19 AM, Richard Hipp wrote: > On 3/2/18, Olivier Mascia wrote: > > > > What values will be considered FALSE, and hence will TRUE be NOT FALSE or > > equality to some other specific value? > > I have a note to provide additional documentation on this before the > release.

Re: [sqlite] sqlite problem - field names missing in select

2018-02-23 Thread J Decker
https://sqlite.org/c3ref/column_name.html You can get the column names. On Fri, Feb 23, 2018 at 4:46 AM, M wrote: > sqlite has an integral problem, field names cannot be selected each one > inside a program, there is way to do it, but it is not straight and > complicates the software program

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-20 Thread J Decker
On Mon, Feb 19, 2018 at 7:49 PM, petern wrote: > There are other uses for padding strings besides user reports. Consider > scalar representations of computations for example. Also: > > 1.There was no mention of user display formatting in Ralf's original > report. It was a bug report about missi

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread J Decker
On Mon, Feb 19, 2018 at 5:38 PM, petern wrote: > FYI. See http://www.sqlite.org/src/timeline for the equivalent DRH > checkins: http://www.sqlite.org/src/info/c883c4d33f4cd722 > Hopefully that branch will make a forthcoming trunk merge. [Printing > explicit nul terminator by formatting an int

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread J Decker
On Mon, Feb 19, 2018 at 2:54 AM, Ralf Junker wrote: > On 19.02.2018 09:50, Rowan Worth wrote: > > What is your expected answer for: >> >> select length(printf ('%4s', 'です')) >> > > 'です' are 2 codepoints according to > > http://www.fontspace.com/unicode/analyzer/?q=%E3%81%A7%E3%81%99 > > The req

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

2018-02-19 Thread J Decker
On Mon, Feb 19, 2018 at 3:21 AM, Cezary H. Noweta wrote: > Hello, > > On 2018-02-18 00:36, Richard Hipp wrote: > >> The current behavior of the printf() function in SQLite, goofy though >> it may be, exactly mirrors the behavior of the printf() C function in >> the standard library in this regard

  1   2   3   4   >