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
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
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
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
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/
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
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
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
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
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
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
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
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--
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
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
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
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-
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
>
>
>
> 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,*
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
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
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', &#
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)
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
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
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
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.
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.
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
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
>
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
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
/* 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
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
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
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
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
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
(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,
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
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
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
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
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
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
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
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.
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'
> > ```
> >
> > *
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
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
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
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:
>
>>
>> >"
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
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
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
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):
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
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
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
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
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
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
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")
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
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
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
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
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
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
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
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
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
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:
>>
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
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
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
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
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
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
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
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
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
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)||'
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
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
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
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
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 '
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
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
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'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
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
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
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.
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
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
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
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
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 - 100 of 372 matches
Mail list logo
