Re: [sqlite] New SQLite Forum requires Javascript?

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, >

[sqlite] Write complete pages to journal in VFS?

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

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

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

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

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. >

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

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

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

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 share

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

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

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

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?

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

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

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

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

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

Re: [sqlite] Date time input

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

Re: [sqlite] Request to get alias of table

ay 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.org] On Behalf Of J Decker > >Sent: Sunday, 18 August, 2019 18:14 > >To:

Re: [sqlite] Request to get alias of table

(*) 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 things. On Sun, Aug 18, 2019 at 5:01 PM J Decker

Re: [sqlite] Request to get alias of table

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

Re: [sqlite] Request to get alias of table

Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of J Decker > >Sent: Thursday, 15 August, 2019 19:19 > >To: SQLite

Re: [sqlite] Request to get alias of table

} > > -- > 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.org] On Behalf Of J Decker &

Re: [sqlite] Request to get alias of table

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

> > > > 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

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

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

Re: [sqlite] Request to get alias of table

: { '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', 'odif', addresses: 'there', pet: 'odif' ] } ] On Thu, Aug 15, 2019 at 11:51 AM J Decker wrote: > I would really like to

[sqlite] Request to get alias of table

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

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

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 expe

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

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

Re: [sqlite] Hidden data

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

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

Re: [sqlite] Help with sqlite3_value_text

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

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

Re: [sqlite] Help with sqlite3_value_text

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

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,

Re: [sqlite] Displaying hierarchical structure

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

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

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: > https://sqlite.org/c3ref/column_d

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

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)

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

> > --- > 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.org] On Behalf Of J Decker > >Sent:

[sqlite] Broken Foreign key

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

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

Re: [sqlite] Fill empty space with random

(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

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 ? > > Ther

Re: [sqlite] Fill empty space with random

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

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 options.

[sqlite] Fill empty space with random

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 ?

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

Re: [sqlite] sqlite3_column_* with error handling

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

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

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

Re: [sqlite] keys

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

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

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

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

Re: [sqlite] Foreign Key error

. 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 `option4_name`(`nam

Re: [sqlite] Foreign Key error

1f|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: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0",&qu

Re: [sqlite] Foreign Key error

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

Re: [sqlite] (no subject)

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)

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

[sqlite] (no subject)

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...

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

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-line t

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

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 corr

[sqlite] how to know which database is corrupted

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

Re: [sqlite] Issue using SEE

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 >

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

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

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

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

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

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

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`

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

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 have, re

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

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

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

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 è)

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 > > 'é'),

Re: [sqlite] Stored Procedures

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

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

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

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

On Sat, May 5, 2018 at 4:08 AM, Max Vlasov <max.vla...@gmail.com> wrote: > On Sat, May 5, 2018 at 1:19 PM, J Decker <d3c...@gmail.com> wrote: > > > https://www.sqlite.org/c3ref/column_blob.html > > > > The sqlite3_column_type() routine returns th

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

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()

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

https://productforums.google.com/forum/?utm_medium=email_source=footer#!msg/gmail/vaG8BpMPov0/JqRR4wk2CQAJ On Sat, Apr 28, 2018 at 3:05 AM, J Decker <d3c...@gmail.com> wrote: > > > On Sat, Apr 28, 2018 at 3:01 AM, Luuk <luu...@gmail.com> wrote: > >> >>

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

On Sat, Apr 28, 2018 at 3:01 AM, Luuk <luu...@gmail.com> wrote: > > On 28-4-2018 11:26, J Decker wrote: > > On Sat, Apr 28, 2018 at 2:08 AM, Luuk <luu...@gmail.com> wrote: > > > >> On 28-4-2018 07:36, Luuk wrote: > >>> On 27-4-2018 20:57

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

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. > >> ___ > >>

Re: [sqlite] Window functions

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

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

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

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

, 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 4:11 PM, J Decker <

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

s contain an embedded length for 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 abou

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

On Thu, Apr 19, 2018 at 3:37 PM, J Decker <d3c...@gmail.com> wrote: > > > On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf <kmedc...@dessus.com> > wrote: > >> >> Actually, nothing in the C or C++ world will "go past" the NULL byte >> sinc

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

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

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

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 >

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

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?

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

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

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

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

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/ >

[sqlite] Constraints must be defined last?

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

[sqlite] Insert with foreign keys enabled prevented in transaction

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?

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 AM, "sqlit

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

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

On Fri, Mar 30, 2018 at 12:46 PM, Richard Hipp <d...@sqlite.org> wrote: > On 3/30/18, J Decker <d3c...@gmail.com> wrote: > > Sqlite's Fossile browser can't link line numbers... > > > > > > Add ability to link to lines of source... > > > >

[sqlite] Fossil Feature Request

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

Re: [sqlite] json question

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

[sqlite] Feat Req Get Aliased Table Name.

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

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

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

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

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 >

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

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.

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

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

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

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 > >

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

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

  1   2   3   4   >