Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

I've read a bunch of the posts here, and quite honestly, I'm kind of looking forward to having Fossil send me notes that messages have been added, then, if I want to reply, I just log into the site and do the reply. I'm not 100% sure about the anon sending to Fossil, if that's a thing I thought I

Re: [sqlite] DRH interview on why/how SQLite succeeded

I just finished listening to this. Really cool. Thanks for ALL of your hard work SQLite team. I appreciate it sincerely. On Wed, Feb 19, 2020 at 12:39 PM Simon Slavin wrote: > > > Podcast / transcription of DRH interview: > > " We talked to Richard about

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

I'd stick with "serverless". The marketing teams that make "serverless" mean that websites don't run with "servers" are I-D-TEN-Ts. It's a fad phrase that'll go away eventually. I understand marketing, and its purpose, but, in this case, they're pushing it. On Mon, Jan 27, 2020 at 9:31 PM sub

Re: [sqlite] SQLite version 3.30.0 in about two weeks.

"Still says" due to 3_30_0.html is in a draft, I would assume. On Thu, Sep 26, 2019 at 3:31 PM Olivier Mascia wrote: > > Le 26 sept. 2019 à 20:26, Richard Hipp a écrit : > > > > Our plan is to release SQLite version 3.30.0 in about two weeks - on > > or about 2019-10-10. Please review the

Re: [sqlite] General Amalgamation vs Your Own

getting the two different sets of code to work with each other going forward. On Sat, Sep 21, 2019 at 10:41 PM Warren Young wrote: > On Sep 21, 2019, at 11:29 AM, Stephen Chrzanowski > wrote: > > > > How does one have their own code base for SQLite, with their own

[sqlite] General Amalgamation vs Your Own

With a post that someone made here, and the thought that I've been running in my head over the past while... How does one have their own code base for SQLite, with their own customer logic or functionality or whatever, then, have updates provided by the SQLite team implemented in when updates and

Re: [sqlite] Odd behaviour with JulianDay

%s') - > strftime('%S') + stftime('%f')) will get you the unixepoch offset in > floating point corresponding to 'now'. > > -- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > >-Original Messa

Re: [sqlite] Odd behaviour with JulianDay

UnixEpoch, so, 43711.819791667 as an example. So I'm comparing oranges to apples. Now I just need to figure out how to compare apples to apples when using 'now'. On Sat, Sep 7, 2019 at 4:01 PM Stephen Chrzanowski wrote: > I'm creating a new database to keep track of time difference between >

[sqlite] Odd behaviour with JulianDay

I'm creating a new database to keep track of time difference between logins and logoffs for a particular system. I have the following query: select NodeOpened, JulianDay(NodeOpened), JulianDay('now') from EventEntry where NodeClosed is null The results are: NodeOpened

Re: [sqlite] lockfile but using db table row instead of file

What Keith said, plus, SQLite does not do row locking, period. It's a full file lock when required. SQLite has some embedded functionality to deal with locking things like this, and your program will need to be written to be aware of how to deal with locking. If you're attempting to fix race

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

to whatever the stores location TZ info is, then present the appropriate information. So even if you are in BC, you can look at NFLD info and get the NFLD local times. On Wed, Aug 14, 2019 at 12:24 PM Warren Young wrote: > On Aug 14, 2019, at 9:55 AM, Stephen Chrzanowski > wrote: > >

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

On Tue, Aug 13, 2019 at 7:30 PM J Decker wrote: > > > Why are you storing the timezone? You display the TZ of the user who is, > > later, viewing the data. And that user could be anywhere. > > Because the actual time on the clock on the wall matters. > I want to know cashiers that are making

Re: [sqlite] Feature request: import MySQL dumps in CLI

The BIGGEST problem I had with importing data from MySQL to SQLite is the table definitions. If you do two dumps, one specifically for table definitions, the other for the actual data to be imported, you could get a script to handle the table definition file to make it conform to what SQLite can

Re: [sqlite] Proposal: SQLite on DNA

Do we really want to start going down this path? Like... we already have parents who won't allow their kids to get flu shots. Will we need to give our PCs the same kind of shots?! On Thu, Jul 25, 2019 at 11:31 AM Chris Brody wrote: > > > May I humbly suggest that the development team look

Re: [sqlite] Ionic SQLite get error: "Cannot read property 'executeSql' of undefined"

I don't know a single thing about Ionic other than how to spell it, but what I do know is that there are two types of SQL calls that do different things, and depending on the wrapper or interface, you might be looking at a different command or implementation. With SQL, one style of execution is

Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

ing. On Thu, Jul 18, 2019 at 1:13 PM Stephen Chrzanowski wrote: > NULL is a special thing. It's never considered unique. > > SQLite version 3.20.0 2017-08-01 13:24:15 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open

Re: [sqlite] I can insert multiple rows with the same primary key when one of the value of the PK is NULL ...

NULL is a special thing. It's never considered unique. SQLite version 3.20.0 2017-08-01 13:24:15 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> create table TheTable (ID Integer, Info Text, PRIMARY KEY

Re: [sqlite] Grammar police

"an historical oversight" feels dirty to me, mostly because it's an incomplete sentence and can be understood in different ways. It's a "point", or answer to a question. In my verbage, "historical" begins with an H (Note here "AN H", not "A H", because when saying "H", it starts with a vowel

Re: [sqlite] the sqlite3 documentation would be pretty good if it wasn't tragic...

I've always been perturbed by the term "Real World Examples". Because... well.. Everything is different from one building to the next. How I make my SQL calls is going to be different than the company across the street. Heck, even the guy sitting across from me will come up with a different way

Re: [sqlite] bug in sqlite3??

Let's not forget that the size of the database is going to grow above and beyond the "number of rows" due to pages that aren't reserved for your data, such index pages, etc. On Tue, May 28, 2019 at 1:49 PM Jens Alfke wrote: > > > > On May 26, 2019, at 7:21 PM, John Brigham wrote: > > > > The

Re: [sqlite] [EXTERNAL] Re: SQL Features That SQLite Does Not Implement

2019 WISH LIST --- - A list of libraries that are known to be successfully added to SQLite. - Have a base instance, select some check-boxes, press SUBMIT, something somewhere somehow generates your .DLL, .SO, etc. so that you have everything you want built in - A

[sqlite] Affinity Performance - Non Issue?

Hey all; I've seen it grumbled about before about giving a field a property of CHAR, and have seen the correction that it should be TEXT. I understand that SQLite doesn't really "care" what the contents of the field is, but, just out of curiosity, is there a kind of performance hit on using CHAR

Re: [sqlite] seeking information on the throughput requirement using Sqlite

All of that is going to ENTIRELY depend on your hardware, and how fast it's going to allow the electrical pulses and actual processing of the different chips on your mobo, and the kind of data you're going to be adding, requesting, and removing. There's no clear-cut answer with the information

[sqlite] Page Size question

When I get my act together and get un-lazy about it, I want to take a large set of "small" files and put them into a SQLite database blobs in a table, then have my app run some kind of CRC check (CRC32/MD5SUM/SHA1/custom/whatever - Haven't decided on a CRC or just byte-for byte comparisons) to

Re: [sqlite] Use cases for sqlite3_value_frombind()?

this particular function to my wrapper... .. one of these days. On Wed, Apr 17, 2019 at 2:22 PM Simon Slavin wrote: > On 17 Apr 2019, at 6:37pm, Stephen Chrzanowski > wrote: > > > What measures the trustworthiness? At what point would the running > > application be notifi

Re: [sqlite] Use cases for sqlite3_value_frombind()?

What measures the trustworthiness? At what point would the running application be notified that the statement was bound or injection avenue? On Wed, Apr 17, 2019 at 12:40 PM Richard Hipp wrote: > On 4/17/19, Jens Alfke wrote: > > The new sqlite3_value_frombind() function sounds intriguing —

Re: [sqlite] Help with loading .DAT files

.DAT files can be anything. If you can just use sqlite3.exe to open the .DAT and do proper queries on it (IE: sqlite3.exe yourfile.dat), then it's a proper SQLite3 database, so then you SHOULD be able to use the Attach command. Otherwise, you need to change the .DAT contents to something else

Re: [sqlite] Remove row to insert new one on a full database

This almost sounds like "Full" is a software limitation, in that your application is specifying that "Full" means you can only have "X" number of rows. If you're looking to remove data, I'd suggest that you find some way to isolate the oldest record, either by a row identifier (Like an ID field

Re: [sqlite] Database backup with writers present?

Does write blocking still come into play when using "vaccum into", or are writes put into the WAL file? I know that with the regular backup API, any writes to the DB restarts the backup process, but I hadn't thought about putting either into a transaction. (I'm an I-D-TEN-T, I know) On Wed, Feb

Re: [sqlite] MySQL Dumps into SQLite

Ah yes. I forgot about that. I don't use WITHOUT ROWID typically, so it didn't enter the thought process. On Mon, Feb 11, 2019 at 2:29 PM J. King wrote: > On February 11, 2019 2:19:27 PM EST, Stephen Chrzanowski < > pontia...@gmail.com> wrote: > >This is a dump from a MyS

[sqlite] MySQL Dumps into SQLite

This is a dump from a MySQL table I created a few years ago. I'm not moving this particular database into SQLite, but, from what I learned today about MySQL dumps and the commenting system, I was kind of interested on how SQLite would handle the rest of the following statement: CREATE TABLE

Re: [sqlite] Is this rewrite of a query OK

I can see this query being useful as a part of an abstraction theory. You take away the responsibility of having a developer handle the math, so the developer doesn't need to worry about what the two primary values are. They can just pick what they need from the query. Back in the Borland Pascal

Re: [sqlite] Variable Declaration

But then in BASH, for example, the temp table would only last for the life of the initial connection, so you'd have to throw everything in one execution. This goes along the lines of just setting a variable. A BIG time question comes to scope of the life of the variable. Does it live for the

Re: [sqlite] Variable Declaration

I know about the bindings. I don't know about all languages supporting it. On Fri, Jan 18, 2019 at 11:26 PM Simon Slavin wrote: > On 19 Jan 2019, at 3:57am, Stephen Chrzanowski > wrote: > > > I was going to have three variable set with > > three different strings I

Re: [sqlite] Variable Declaration

pated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski > >Sent: Friday, 18 January, 2019 18:52 > >To: General Discussion of SQLite Database > >

[sqlite] Variable Declaration

Tonight, I wanted to write up a small database to keep tabs on certain things I've done in a game, and show me new tasks I can do based on what I've completed. I have a full list of items, and what pairs of items I need to poses to get the next thing, but, getting the data into the DB is tedious.

Re: [sqlite] WAL mode for in-memory databases?

That doesn't sound healthy at all. If your application dies, what happens to the database? What if something rogue starts hitting it and just chews up your memory? IMO, Mem databases should be short lived and treated simply as an intentional cache. I get they're fast, but, long term life for a

Re: [sqlite] Syntax clarification

The .add indicates you're using some kind of dictionary type of class like a tStringList and would append that string to the end of that dictionary. The .Text would replace the contents of the dictionary with that string. On Friday, December 28, 2018, Dave Delage wrote: > I've searched without

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

Right up until procedures change and the identifier has changed from an integer only data type to something that starts containing characters. There's so many different types of UPCs out there, for example, that a company can switch from an integer only type of UPC to something that contains

[sqlite] Monitoring SQLite Web Site

This email is more to Dr Hipp, but, there are other members of this list that might also benefit from this site I'm about to mention. I know there are many out there, but monitoring 50 sites for free for their up-time is kind of nice. Right up front, I have exactly ZERO affiliation with the

Re: [sqlite] Segmentation Fault When Using Window Function

I'm only seeing the one email, no duplicates. On Fri, Nov 9, 2018 at 10:35 AM Dennis Clarke wrote: > On 11/08/2018 04:05 PM, Richard Hipp wrote: > > In case you are not following the ticket at... > > > > The list mail server sends this out about thirty times. Not sure if > anyone else sees

Re: [sqlite] Database identified as zip

That said, I still didn't know the shell/CLI could do that. But 14.5 and 14.6 are pretty far down https://sqlite.org/cli.html so, I probably gave up after 6.1 or 6.2 {smirk} Good nugget to keep rattling in my head. On Tue, Oct 30, 2018 at 10:44 AM Richard Hipp wrote: > > The core SQLite

Re: [sqlite] Database identified as zip

First off, I didn't know that SQLite could read from zip files directly. I don't like it, but, I'm sure there's a use case somewhere. Second, shouldn't SQLite only consider reading a file if the file size is zero or if the appropriate SQLite header is found, and completely ignore the file

Re: [sqlite] Regarding CoC

I like this. If I were to use this (And I don't expect I'll ever have to since I typically write just for me) the only addition I'd make to this is about the reporting. From a users perspective, if the utility has something to report "home" with (lets say crash reports), it'd have to be

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

I suppose you COULD get rid of the \n in the query Its a Linux thing. *sigh* On Fri, Oct 19, 2018 at 10:50 AM Stephen Chrzanowski wrote: > This would be something you'd need to write something quick for. There's > no application in the world that knows how to use your specific

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

This would be something you'd need to write something quick for. There's no application in the world that knows how to use your specific schema and react to it. There may be apps that will read the values and automatically 'understand' that http:// and https:// are addresses, but, these probably

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

FSCK is File System ChecK, so the equivalent in Windows Scandisk. Trace through the code to find out when exactly the SQLite is reporting the lock. Is it at a query, on opening, is it multi-thread or multi-application access? Is the query taking too long? If you're debugging and everything is

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

nately! > > -Oprindelig meddelelse- > Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > På vegne af Stephen Chrzanowski > Sendt: 12. oktober 2018 14:25 > Til: General Discussion of SQLite Database > Emne: Re: [sqlite] error message: [Fire

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Change the timeout value on the connection to 5 seconds or so. The DB will retry. The AV has its grip on it, doing a scan, and won't let anything else touch it until its done. On Fri, Oct 12, 2018 at 3:11 AM Lars Frederiksen wrote: > Hello, > > I have made (in Delphi) a program that writes to

Re: [sqlite] DB To DB Transfer Time

You're kind of asking if a 4 cylinder engine can outrun an 8 cylinder engine by just physically looking at the engines. The answer is yes. It can. Given the right circumstances. Your transfer rates are going to be subjective based on your hardware, network speeds at the source and destination

Re: [sqlite] Some queries with ORDER BY and LIMIT lock DB

I can reproduce this issue with the SQLite3.exe under Win7. The first sqlite3 was pulled from a sqlite3.exe I have somewhere in my path, I then extracted the 3.24.0 version to the Ramdrive and executed from there. On the first run, r:\sqlite3.exe did not exist. R:\>sqlite3 lock_issue.db SQLite

Re: [sqlite] Is there permanent link to the latest SQLite amalgamation source?

I don't do the compiling, but I run this daily: #!/bin/bash cd /mnt/drobo/Development/SQLite3 wget --no-check-certificate -q -O - https://sqlite.org/download.html | grep "win32\|amalgamation" | grep ";" | cut -f4 -d\' > sqlite.list wget --no-check-certificate --no-clobber -i sqlite.list -o

Re: [sqlite] Safe sqlite over remote filesystem?

Have you read through this document: https://www.sqlite.org/howtocorrupt.html On Tue, Aug 14, 2018 at 9:46 AM, Wout Mertens wrote: > In the meantime I found this discussion from 2011 about sqlite on CIFS: > http://sqlite.1065341.n5.nabble.com/How-to-make-SQLite- >

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

Simon; Interesting approach that I'd forgotten about. The tables aren't "variable". This is a "beginning of the project, one-time execution" thing I was hoping to get at database initialization. Meaning, 0-byte SQLite file size kind of initialization, with not a single line of application code

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

I was right. I got the tables done before a response. But still would like to know if there's a SQLite method of doing so. My method was to use a templating application that I wrote at work. I give it this variable declaration: Name=Resource I then give it this text: CREATE TABLE [%(Name)s](

[sqlite] "Cheating" at making common tables

I'm making a small database for a game, and a bunch of the tables follow the same kind of naming convention due to normalization, like {Name_Of_Information}s {Name_Of_Information}ID as Integer {Name_Of_Information}Name as Char So for example: Resources ResourceID as Integer ResourceName

Re: [sqlite] Network share & disk I/O error

With Richards comment, the only additional thing I'd weigh in on is what your remote file server is doing with the physical file. Virus scanners can interfere with the usual operation of your program, and can cause certain things to happen. Because the OS you're running your software on is told

Re: [sqlite] Minimum Delta Time

tTime, '+10 minutes') > > ) > > where > > EventID = ? > > and (EndTime is null or EndTime = ''); > > > > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Stephen Chrzanowsk

[sqlite] Minimum Delta Time

I've got an application that I've written that keeps track of time spent on particular tasks. I do many things throughout the day, going between different tasks, and tasks I've already worked on for today, so this tool is incredibly helpful to help justify my warming a chair. I'd prefer the SQL

Re: [sqlite] [EXTERNAL] Bind Question -- Is this correct?

Thanks for the replies gents. This just caught me off guard a bit and needed a check. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bind Question -- Is this correct?

I'm attempting to do a simple bind for an integer. The partial query is: V1: *datetime(date(current_timestamp,'localtime'),'+'||:StartTime||' hours')))/60) MinutesSince9* V2: *datetime(date(current_timestamp,'localtime'),'+:StartTime hours')))/60) MinutesSince9 * I'm getting a failure with V2,

Re: [sqlite] (no subject)

*sigh* I wish I had this kind of homework back in the day.. On Tue, Jun 19, 2018 at 3:22 PM, Simon Slavin wrote: > On 19 Jun 2018, at 8:15pm, Vicente minguez gabarda > wrote: > > > hello I need a simple example of relationship between table, > > I would like to be able to visualize the

Re: [sqlite] Newbie help

SQLite is a library that is built into applications. Other than sqlite3.exe, its not a standalone 'thing', if you will. If your application can't be rebuilt to directly write to a SQLite database, then the only alternatives I can think of are - to keep doing what you're doing, or, - look at your

Re: [sqlite] sqlite.org website is now HTTPS-only

On Thu, Jun 7, 2018 at 4:07 PM, Warren Young wrote: > > That OS is over 9 years old now. > Trust me, its showing its age, and I'd really like to get rid of it, but there's a bunch of things I really don't want to migrate as some of what is doing relies on functionality in the underlying

Re: [sqlite] sqlite.org website is now HTTPS-only

Probably, yes. Its running Debian Lenny. I'm trying to locate a resource right now to see if I can get the appropriate files, and how to keep them updated. On Thu, Jun 7, 2018 at 3:43 PM, Simon Slavin wrote: > On 7 Jun 2018, at 8:35pm, Stephen Chrzanowski wrote: > > > stephen@vm

Re: [sqlite] sqlite.org website is now HTTPS-only

I've got a script that runs daily and scrapes the download page and grabs everything new. The last run was this morning at midnight eastern (-4UTC) and it successfully grabbed the list of files that could be downloaded, however, when I run it now, it doesn't seem to want to see anything. After

Re: [sqlite] Getting call backs on WRITEs?

Thanks Dan. Initial glance, looks to be something that I can tie into. On Tue, Jun 5, 2018 at 12:14 PM, Dan Kennedy wrote: > > It might be worth looking at the "sessions" module: > > https://www.sqlite.org/sessionintro.html > > Sessions uses this to get SQLite to make the required callbacks:

Re: [sqlite] Getting call backs on WRITEs?

already been done, but, I've got the desire to save on tire wear and go down the path that gets me to where I want without having to dodge roadblocks. On Tue, Jun 5, 2018 at 11:58 AM, Warren Young wrote: > On Jun 5, 2018, at 9:46 AM, Stephen Chrzanowski > wrote: > > > > I'm *D

[sqlite] Getting call backs on WRITEs?

Using the Amalgamation DLL, I'd like to know if there is a function that is exposed when any WRITE function to the database happens on a per connection basis, a call back to my program (Delphi - Tokyo and Berlin) will happen and I can act on the results. I don't think I'll be concerned about the

Re: [sqlite] random rows

Here's my two cents. Don't spend it all in one place... CREATE TABLE [RandomTable]( [PriID] INTEGER PRIMARY KEY AUTOINCREMENT, [DataCol] CHAR); INSERT INTO [RandomTable]([PriID], [DataCol]) VALUES(1, 'a'); INSERT INTO [RandomTable]([PriID], [DataCol]) VALUES(2, 'b'); INSERT INTO

Re: [sqlite] ALTER TABLE

Thinking off the cuff, there'd be a seven step process for this; Begin Transaction Turn off the PK/FK relationship PRAGMA constraint checks Rename old table to a temp table via whatever means are available Create the new table INSERT INTO the new table Turn on the PK/FK relationship PRAGMA

Re: [sqlite] Is this really the best way to do this?

Out of curiosity, where's the guarantee that the OK won't be displayed if an email is found? Do all unions show up in the return result based on where in the query they're called? On Wed, May 16, 2018 at 6:25 AM, Clemens Ladisch wrote: > > SELECT action FROM blocked WHERE

[sqlite] OR statement in LIKE

I can't remember if I asked this before. Went to google and didn't find an answer. Could there be a plan put in place that would including an "OR" mask character? The reason I ask is that I've got a user input field that searches the required field in a database using % as the "AND" statement,

Re: [sqlite] About storage of large amounts of image data

In my experience, store the blob information in a table to itself and do a 1:1 or 1:Many relationship between your main data and the blob data. The reason for this is that SQLite will read the data of your request per row if the query is asking for information past the field to which your blob

Re: [sqlite] The upcoming 3.23.0 release

If only all tech manuals were written like that, I'd be doing much MUCH more entertaining things with my life. Mind you, I love my job as is On Fri, Mar 23, 2018 at 1:14 PM, Simon Slavin wrote: > > You'll get mixed up, as you know > You're not sure what you know > So

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

Every table I create that is considered a primary resource, I use auto-increment on exactly one field. Any table I create that uses auto-increment is used for internal use within the database, or, an "object" to point an item in a tStringList to the database row. This integer is NEVER given

Re: [sqlite] iOS Watchdog and database corruption

That number doesn't surprise me. At my company, one of our products is built around iPads. Airlines give their pilots 16-32GB iPads to bring into the cockpit to look at maps, charts, weather info, etc. The iPads essentially become EFB, or, Electronic Flight Bags. Compressed, we push two or

Re: [sqlite] Clarification on Storage

Thanks all. I'll consider this thread done. With Ryan and Bills comments, I've decided that I'll truck on as is, and not worry about special string considerations. Thinking about how Delphi Berlin is handling strings at the compiler level, and how the wrapper I use is handling the strings based

Re: [sqlite] Clarification on Storage

t shows (blob). > > > > The reason I'm asking is that I've got an application that handles bulk > > text inserts, and I want to make sure that I don't run into some kind of > > stupid (My code, not SQLite) limitation that'd chop text out, or what > have > > you. > >

Re: [sqlite] Clarification on Storage

s not doing and just shows (blob). The reason I'm asking is that I've got an application that handles bulk text inserts, and I want to make sure that I don't run into some kind of stupid (My code, not SQLite) limitation that'd chop text out, or what have you. On Tue, Feb 20, 2018 at 11:17 AM, Stephen

[sqlite] Clarification on Storage

I'm fully aware that any kind of data can be stored in any kind of field. Strings can be in integer declared fields, etc. What I'm interested in finding out, without changing my code at this time, is if SQLITE3.EXE is handling things differently than what SQLite Expert is. In "SQLite Expert", if

Re: [sqlite] Different kind of constraint

f other data, and maybe storing that alone in a table > of covers would keep that index shorter for the entry pages... > And then you could enforce unique parent id on the cover and not on the > content. > > On Sun, Feb 11, 2018 at 2:36 AM, Stephen Chrzanowski <pontia...@gmail.com>

Re: [sqlite] Reset value of sqlite_sequence

my insert statement was bad. On Sun, Feb 11, 2018 at 3:20 AM, R Smith <ryansmit...@gmail.com> wrote: > (Apologies if this is duplicate) > > On 2018/02/11 3:12 AM, Stephen Chrzanowski wrote: > > How does one reset the sqlite_sequence values? >> > > How about: >

Re: [sqlite] Different kind of constraint

Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski > >Sent: Saturday, 10 February, 2018 22:35 > >To: General Discussion of SQLite Database > >Subject: [sqlite] Different kind of constraint > > > >I

[sqlite] Different kind of constraint

I've been mucking with this for the last half hour or so. I have a table which is kind of in a unique situation. In the app I was talking about earlier, I have a table that will contain BLOB that has FK data referencing a magazine table. This blob-tables responsibility is going to hold the

Re: [sqlite] Reset value of sqlite_sequence

Half thought... SQLite Wrapper from Tim Anderson at itwriting.com On Sat, Feb 10, 2018 at 9:06 PM, Stephen Chrzanowski <pontia...@gmail.com> wrote: > Delphi Berlin 10.1 using his SQLite Wrapper from I don't know how long > ago. Its served me well in Delphi 7, but with the mov

Re: [sqlite] Reset value of sqlite_sequence

Slavin <slav...@bigfraud.org> wrote: > > > On 11 Feb 2018, at 1:39am, Stephen Chrzanowski <pontia...@gmail.com> > wrote: > > > What I had before was this: > > db.ExecSQL('delete from sqlite_sequence where > > name=?',[ansistring('Magazines')]); &

Re: [sqlite] Reset value of sqlite_sequence

'Magazines'''); The code did what I needed it to do. On Sat, Feb 10, 2018 at 8:19 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 11 Feb 2018, at 1:12am, Stephen Chrzanowski <pontia...@gmail.com> > wrote: > > > How does one reset the sqlite_sequence values? > > S

[sqlite] Reset value of sqlite_sequence

How does one reset the sqlite_sequence values? I'm trying with [ delete from sqlite_sequence where name='...' ] but my app continuously goes and keeps adding up the number. If I go into a 3rd party tool and delete the table, the next time my app goes and populates data, the counter starts at 1.

Re: [sqlite] GMail blocking

I ran into this a couple of years ago. To add to this, the only thing to know about is that GMail (un)helpfully warns you that this was not sent to junk because you marked it as not-junk. Just marking mail as "Not Junk" doesn't help. On Wed, Feb 7, 2018 at 6:18 AM, R Smith

Re: [sqlite] Vetting SQLite

I was surprised to see that statement, so, checking my system, this isn't true. Win7Pro-x64. Not with that filename anyways. Searching my system with the "Everything" tool, [ *sqlite3.exe ] comes up with DLLs that I've touched only. The DLL's I've dumped into the Windows directories exist in

Re: [sqlite] Atoi64 bug(s)

According to https://www.sqlite.org/datatype3.html *2. Storage Classes and DatatypesEach value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:NULL. The value is a NULL value.INTEGER. The value is a signed integer,

Re: [sqlite] Atoi64 bug(s)

RE the first question, the largest positive 64-bit number is 18446744073709551615, or, 18,446,744,073,709,551,615. Your number is overloading that value. 12,345,678,901,234,567,890,123 vs 18,446,744,073,709,551,615 AFAIK, SQLite uses max of 64-bit integer math, not 128. On Thu, Jan 25, 2018 at

Re: [sqlite] Efficient query to count number of leaves in a DAG.

Playing devils advocate, there may be a purpose to those aliases (Application code requirement, which can't be changed), and/or, the single letter aliases are documented and understood throughout the application. But, you're absolutely correct. The only time I personally use single letter

Re: [sqlite] Move to Github!!?

As stated, SQLite is managed by Fossil, and Fossil is managed by SQLite. (I think it was) Dr Hipp that stated that "Fossil is eating its own dog food". https://www.google.ca/search?q=eating+your+own+dog+food=utf-8=utf-8=firefox-b_rd=cr=0=SENBWvCGOs6fXo7ynMAJ

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

First, be careful with modifying a database you don't control. This can result in unexpected results, even if you're tailing onto the end of the table. Some calls are like [select * from ThisTable] and the code itself is expecting exactly the number of fields to be returned. You may also be

Re: [sqlite] values ?

Nifty... but... With no option for "where" or "order by", where would this come in useful? On Tue, Dec 12, 2017 at 1:48 PM, Mark Wagner wrote: > Argh. Yes, I was on 3.8.2. Thanks! > > On Tue, Dec 12, 2017 at 10:45 AM, Richard Hipp wrote: > > > On 12/12/17,

Re: [sqlite] Seasonal syntax

You had to do that just beclause On Tue, Dec 12, 2017 at 12:24 PM, Simon Slavin wrote: > Some SQL terminology: > > Selection Clause: WHERE >Sort Clause: ORDER BY > Sublist Clause: LIMIT OFFSET > Subsort Clause: GROUP BY HAVING > Santa

Re: [sqlite] Emulate right-join

Thanks all for the input. My knowledge from nearly 20 years ago is a bit rusty when it came to material like this. Just adding "LEFT JOIN" instead of just "JOIN" has my query working as I need it to. This type of result set isn't something I regularly perform. On Wed, Dec 6, 2017 at 4:41 AM,

[sqlite] Emulate right-join

I'm working on a pretty simplified event tracking system (So I stay out of trouble of not updating time spent throughout the day), and each item that I need to track has an associated priority with it, which ranges for any positive integer value. This priority can be user defined as a positive

  1   2   3   4   5   6   >