Re: [sqlite] Shell doesn't do

Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. On Aug 10, 2011 12:18 PM, "Kit" wrote: > 2011/8/10 Simon Slavin : >> I've never tried using this before for some

Re: [sqlite] Shell doesn't do

logic by piping sqlite output into use. It's much better than some on this forum give it credit. But as mentioned elsewhere: you've got the recompile option too... On Aug 10, 2011 12:58 PM, "Kit" <kit.sa...@gmail.com> wrote: > 2011/8/10 Brian Curley <bpcur...@gmail.com>: >&

Re: [sqlite] Shell doesn't do

, Kit wrote: > >> 2011/8/10 Brian Curley <bpcur...@gmail.com>: >>> Depending on your preferred shell...the sqlite CLI is just crazy flexible. >>> Just pipe your output through sed for upper/lower preferences. >> >> It is not entirely primitive. It ne

Re: [sqlite] Using dot commands with the command line binary

Use of a heredoc to simulate a session...or staging it all into a file for use via .read are good too. On Aug 16, 2011 6:55 AM, "Ryan Henrie" wrote: > I finally figured out how to load multiple "dot commands" or settings > from the command line tool. (Some users only have the

Re: [sqlite] Export Blob data from sqlite database to html

I'd agree with the SQLite Expert option (Windows)...it ships, or at least used to ship with sample data that presents a scenario like you're describing (ie, jpeg and text as BLOB), plus it allows visual assists, such as BLOB masking over a certain size of data in a column. Otherwise, you'd need

[sqlite] Trigger mask entities...

Looking for some guidance or enlightenment on the available fields within a given trigger. In reading through the code as a non-C kind of guy, it looks like there's an array of columnar values lumped together as old.* and new.* would need them, but nothing that contains the individual field or

Re: [sqlite] [Query] Sqlite

What's your question on SQLite? (The sqlite-users@sqlite.org address is fairly straightforward. It's sort of like a forum style of help, where you ask your question via e-mail and 90-95% of the answers come from roughly 10 seemingly never-sleeping experts from around the English-speaking world.

Re: [sqlite] Simple web query tool

Would the SQLite Manager extension on Firefox suffice? I don't know the scope of your use case, but internal file shares are all that's needed to connect to a distributed file. You can achieve variables through a miscellaneous table and coalesce() as needed. Regards. On Wed, Feb 1, 2017 at

Re: [sqlite] importing csv

Windows requires that you escape the \ in the path, effectively doubling them up. Regards. Brian P Curley On Aug 24, 2016 8:24 PM, "Simon Slavin" wrote: > I hope someone else can help. > > Does that table already exist in the database file ? > > Is the first line of the

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

The sqlite_master table will always preserve any comments embedded between the "CREATE" and ";" keywords for a given table definition. Is this not sufficient? You can parse the sql for a table's record to retrieve comments, in whichever format you're using. I know that SQLite supports both single

Re: [sqlite] Filter results based on contents of another single field table

I recently had a case where I needed to stack the strings that I did want, minus those that I didn't. The in() and like() options weren't all that flexible given their assumption of known strings and I needed to accommodate near-hits. I found that group_concat() and regexp() work pretty well

Re: [sqlite] A CTE to count the records (rows) for each table

Statistics, even if generated at run-time, might be useful. One option, at least per the CLI, might be to output a variant of DRH's last SQL to be read back in. I've no idea as to the portability of this onto embedded systems, but it works "okay" on the CLI and on desktop apps...my test file was

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

...besides, one might argue that anyone who can programmatically predict the best route for Minesweeper should actually focus on a tool that predicted the lottery (or even elections... ;) What I wonder though is if CTEs could actually serve as a stand-in for the lack of Dynamic SQL, sort of how

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

it just to read in as an update. Regards. Brian P Curley On Mar 7, 2017 7:30 AM, "Clemens Ladisch" <clem...@ladisch.de> wrote: > Brian Curley wrote: > > What I wonder though is if CTEs could actually serve as a stand-in for > the > > lack of Dynamic SQL > >

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

;michael.tier...@gmail.com> wrote: > On Mar 7, 2017 6:56 AM, "Brian Curley" <bpcur...@gmail.com> wrote: > > I have successfully coupled shell scripts and the CLI > > I'd love to see examples of this sort of use case and I suspect that > there's others who wou

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

Not exactly. You're free to extend it yourself and submit it for consideration though. I think that you'll just need to adopt the same standards as are in use within the usual enhancements channels. Regards. Brian P Curley On Wed, Jun 7, 2017 at 12:09 PM, PICCORO McKAY Lenz

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

@issue buton@ > > only see that all contact way must be in the mail list... its a 21 century > and ID urls its the standar way of integration... > > Lenz McKAY Gerardo (PICCORO) > http://qgqlochekone.blogspot.com > > 2017-06-07 12:12 GMT-04:00 Brian Curley <bpcur...@gmail.

Re: [sqlite] CTE question...

that is perfect. Thanks, Clemens! Regards. Brian P Curley On Sat, Sep 16, 2017 at 5:14 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Brian Curley wrote: > > WITH cte_name --(my_row, code_key) > > AS ( > >SELECT

Re: [sqlite] checking if a table exists

This is for a bash function, but you can adapt it for perl as you need to. PRAGMA table_info() will poll the schema for you, and you can grep for your table name: function sq3_info () { # Debug/verbose mode... if [ "${1}" == "-v" ]; then set -x fi not_sqlite="Error: file is

[sqlite] CTE question...

Admittedly it's a bit of a hack and there may be alternate approaches to some of it, but I am curious if there's an issue within the WITH behavior. It could just my approach. DDL for my base table: CREATE TABLE _misc_log ( CODE_KEY NOT NULL, CODE_VAL NOT NULL, ATTRIB, PRIMARY

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

Doesn't the Fossil site already have a Capcha interface built into it that could be adopted to enforce additional authentication around subscriptions? Or a 2-step, email confirmation-type option, maybe? If they're robots causing the problem, then they wouldn't be able to mive beyond the initial

Re: [sqlite] Feature request for the Shell Tool: .mode json

Is there even a need to embed it into sqlite itself? Since you're on the shell, and in keeping with the whole 'do one thing well' mandate: pipe it through jq instead. Beautiful creature that jq... Regards. Brian P Curley On Jan 21, 2018 9:54 AM, "J Decker" wrote: > On

Re: [sqlite] Can an SQL script be built from within sqlite?

I use Termux on Android. Very useful build of sqlite available there. Regards. Brian P Curley On Jan 14, 2018 7:42 PM, "Simon Slavin" wrote: > > > On 15 Jan 2018, at 12:30am, petern wrote: > > > Shane. That's very interesting considering

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

Not exactly sure of the OP's full issue. This does arise on occasion though, especially for when you try to maintain a self-sustaining database. Ignoring the API for a moment, there is some rationale for keeping metadata available for use. My primary use is as a CLI toolkit, if not as a desktop

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

Curley On Fri, Feb 23, 2018 at 1:44 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 23 Feb 2018, at 6:28pm, Brian Curley <bpcur...@gmail.com> wrote: > > > If there's pragmas like table_info available...can these be made > available > > for parsing, or used as

Re: [sqlite] Why trigger (UPDATE) does not work?

You don't list your trigger definition if there's anything that might need troubleshooting, but I will say that I've recently stopped using SQLiteStudio for its somewhat erratic behavior. While it's got a great regex implementation (which doesn't port to running in pure CLI-based scripts) and a

Re: [sqlite] Can an SQL script be built from within sqlite?

Bash can be found on prettt much all of these platforms if you're only prototyping in the shell. Even Windows offers Cygwin, Git, and Msys2 versions of the bash shell and I've had good success in running these w SQLite. (I cannot speak for iOS and bash, but I'm sure there's an option...) You can

Re: [sqlite] Feature request for the Shell Tool: .mode json

rror: %s \n" "No input file found..." fi # Turn off debug/verbose mode...IF it was us that did it... if [ "${1}" == "-v" ] \ && [ ! -z "$(set |grep xtrace )" ]; then set +x fi } ​ Regards. Brian P Curley On Sun, Jan

Re: [sqlite] Feature request for the Shell Tool: .mode json

it seamlessly as a function or an aliased call. Regards. Brian P Curley On Jan 21, 2018 10:15 AM, "Luuk" <luu...@gmail.com> wrote: On 21-01-18 16:05, Brian Curley wrote: > Is there even a need to embed it into sqlite itself? Since you're on the > shell, and in keeping with t

Re: [sqlite] Question about a query

well... It's not quite that categorical "no", although Simon's more than correct. There's extensions that allow for regexp(), such as you might find in SQLite Studio that allow for some really handy cross-functionality when paired with group_concat(), for example. (It's addictive to have it

Re: [sqlite] importing data to a table that has generated-columns

Is there a missed parsing on the input file? It's likely to be a bare word situation where an extra delimiter is encountered in the record. It's probably only on one record in particular, although I don't know if the error message reads that back. The shell is sensitive to these, as it's expected

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

"Serverless" has worked flawlessly since inception. Why change now...? The marketing buzzword usage will disappear...long before Dr Hipp convinces the list that email is dead even.  Regards. Brian P Curley On Wed, Jan 29, 2020, 5:39 PM Jim Dodgen wrote: > I vote for ignoring the marketing

Re: [sqlite] List of innocuous functions?

separate but somewhat related question, based on the response: Has any thought been given to updating the documentation to cover those pragmas that have been upgraded to selectable entities? I've only been able to find a handful of references along the way, such as pragma_table_info,