I recently tried using Coalesce() to check existence of a column name.
SELECT DISTINCT COALESCE((SELECT 'AColumnThatDoesNotExist' FROM TD), -999)
FROM TD;
But, the SQL error code dominates? "no such column: AColumnThatDoesNotExist"
Had to resort to:
SELECT name FROM pragma_table_info('TD') WHERE
Easier still: Install https://nightlies.sqlitebrowser.org/latest/
Then open your sqlite database(s) directly within the browser.
There you can run queries and/or export to csv.
On Thu, Feb 27, 2020, 4:54 AM Shawn Wagner wrote:
> Use the standard sqlite3 shell program:
>
In the ever expanding bloat of tooling, DRH is my hero.
On Wed, Feb 19, 2020 at 2:56 PM Stephen Chrzanowski
wrote:
> 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
'rowid' is a common name and could be in anyone's schema regardless of
table type.
On Mon, Feb 17, 2020 at 2:35 AM x wrote:
> Re my earlier post (which didn’t go out to mailing list)
>
>
> sqlite3_table_column_metadata(db,dbName,tblName,"rowid",0,0,0,0,0)==SQLITE_OK
> returns false if table
Ok, not ideal. Still confusing, but I see the difference.
For my code, I know the schemas. I guess a SQL builder could offer up query
options to the user browsing new databases.
On Sat, Feb 15, 2020 at 11:26 AM Simon Slavin wrote:
> On 15 Feb 2020, at 3:14pm, sky5w...@gmail.com wrote:
>
> >> To
>
> To determine if table XYZ is a WITHOUT ROWID table, run "PRAGMA
> index_info('XYZ');". If you get back one or more rows, then XYZ is a
> WITHOUT ROWID table. If you get back no rows, then XYZ is a rowid
> table.
>
Confused...What if I made an index on a ROWID table?
CREATE INDEX "Z" ON "DOC"
SQLite is your everywhere database, except on servers ;)
On Mon, Jan 27, 2020 at 9:12 PM sub sk79 wrote:
> How about Seamless, Integrated or Baked-in?
>
> -Neal
>
> On Monday, January 27, 2020, Warren Young wrote:
>
> > On Jan 27, 2020, at 3:18 PM, Richard Hipp wrote:
> > >
> > > "serverless"
Client (only) db
Sequential db
On Mon, Jan 27, 2020, 5:27 PM Peter da Silva wrote:
> Local?
>
> On Mon, 27 Jan 2020, 16:19 Richard Hipp, wrote:
>
> > For many years I have described SQLite as being "serverless", as a way
> > to distinguish it from the more traditional client/server design of
>
Doh! I'm on 3.30.0.
Gotcha, thanks.
On Sat, Jan 25, 2020 at 8:22 PM Richard Hipp wrote:
> On 1/25/20, sky5w...@gmail.com wrote:
> > SELECT DISTINCT name FROM pragma_function_list
> > --WHERE (flags & 0x20)!=0 -- no such column: flags
> > ORDER BY name;
> >
> > Works if I drop the WHERE.
>
SELECT DISTINCT name FROM pragma_function_list
--WHERE (flags & 0x20)!=0 -- no such column: flags
ORDER BY name;
Works if I drop the WHERE.
Is there a special compile flag that must be used?
On Fri, Jan 24, 2020 at 5:42 PM Brian Curley wrote:
> separate but somewhat related question, based
haha, that is a mangled way of saying I wrapped my db functions in a dll
for multiple app use. I did not expose this config setting as I never knew
its impact. To be honest, I still don't. ;)
On Fri, Jan 3, 2020 at 5:18 PM Tim Streater wrote:
> On 03 Jan 2020, at 22:08, sky5walk wr
Well, I told you I'm getting SQLITE_MISUSE so that kinda answers your side
question?
I am only interested in this topic for the performance gain so quoted.
I need to create a personal test case(my use model) to verify these
statements.
Querying the config state is helpful for a dll wrapped
Is there a query function for these and other config settings?
I see no sqlite3_config_get() in sqlite3.h.
On Fri, Jan 3, 2020 at 11:36 AM Keith Medcalf wrote:
> On Friday, 3 January, 2020 09:30, sky5w...@gmail.com wrote:
>
> >I get SQLITE_MISUSE when attempting
>
I get SQLITE_MISUSE when attempting
sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 0);
immediately after opening a db connection?
My connection has THREADSAFE = 1.
On Thu, Jan 2, 2020 at 7:32 PM Keith Medcalf wrote:
>
> Indeed turning off memstatus leads to a 500% (from ~3s to ~0.5s)
> performance
Another point being, fully normalized data can be a bear to extract.
I see penalities in my humble database reports, so I leave 3rd and 4th
normalization for managers wish lists. ;)
On Fri, Dec 27, 2019, 6:37 PM Simon Slavin wrote:
> On 27 Dec 2019, at 9:57pm, Keith Medcalf wrote:
>
> >
Thanks for sharing!
Did his suggested optimization make it to a commit?
On Wed, Dec 25, 2019 at 10:46 AM Craig H Maynard wrote:
> All,
>
> Just watched an interesting lecture by UMass professor Emery Berger on
> improving software performance:
>
> https://www.youtube.com/watch?v=r-TLSBdHe1A
>
>
Ok, I'll bite.
The 'current consensus' in any system is tenuous and not an arbiter of its
effectiveness.
In this case, data modelers hoping to save a column. arrggg.
It flies in the face of data normalization and pushes the problem down the
line.
Forgive my simple linear thinking on the immensely
etiLQS or SQLead or SQLdark
Haha
On Thu, Oct 10, 2019, 3:07 PM David Raymond
wrote:
> SQLephantine
>
>
> -Original Message-
> From: sqlite-users On
> Behalf Of Ned Fleming
> Sent: Thursday, October 10, 2019 2:55 PM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: Re: [sqlite]
If you are uncomfortable with exporting to csv and importing csv from the
command line,
you could install DB Browser for SQLite,
https://github.com/sqlitebrowser/sqlitebrowser.
Then manually build your SQLite tables and cut and paste into them from the
spreadsheet.
On Tue, Oct 1, 2019 at 8:58 PM
Good catch! I will check if I have similar errors, but printf() returns
TEXT, round() returns FLOAT. So, do your numerical comparisons BEFORE
formatting statements.
On Mon, Sep 16, 2019 at 2:45 AM Hick Gunter wrote:
> This is well documented in https://sqlite.org/datatypes.html and
>
Yes, I fear users are attempting simplistic banking apps with floating
point rounds. :(
May explain where millions of my pennies went in my last android stock sale!
On Fri, May 24, 2019 at 1:55 PM Warren Young wrote:
> On May 24, 2019, at 7:10 AM, Jose Isaias Cabrera
> wrote:
> >
> > Dr.
Thank you for bringing topic back to original intent.
Clearly much is missing from the latest SQL standard. Debates aside, the
URL is equally lacking.
Yes, "own" extensions solve much of my needs.
On Thu, May 23, 2019, 7:26 AM J. King wrote:
> On May 23, 2019 6:46:52 a.m. EDT, R Smith wrote:
Yes, I expected some pushback. However, my post was to save the next person
having to search for answers. I did not expect to requote the top line of
the page I listed?
"SQLite implements most of the common features of SQL. Rather than try to
list all the features of SQL that SQLite does support,
I'm often scrambling to decide whether to do complicated queries in SQL or
my own code?
...Getting oh so close to a working query, only to fail at function not
defined?!!
Please add a note to the omitted page that many basic math functions are
NOT supported. (sqrt,mod,power,stdev,etc.)
Ok, "making" some headway. :)
; COMPILE SOURCE AS DLL:
; Use MS Visual Studio Command Prompt with the appropriate target: x86 or
x64.
; Ex. shortcut: x64 Native Tools Command Prompt for VS 2017
; %comspec% /k "C:\Program Files (x86)\Microsoft Visual
I was afraid you'd say that.
I wanted to edit the Windows x64 make file to reduce a lot of the options.
SQLite Version= 3.28.0
SQLite Lib= 2019-04-16 19:49:53
884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50
Anyway, I iterated this sql query:
"SELECT
Hi,
Searched a while...what was the makefile or the options used to create the
latest precompiled sqlite3.dll?
https://www.sqlite.org/download.html
--> sqlite-dll-win64-x64-328.zip
Thanks for SQLite!
___
sqlite-users mailing list
27 matches
Mail list logo