Re: [sqlite] Is the table created by "create temp table" in the database file or in memory?

Also these links which maybe easier to grok: https://sqlite.org/tempfiles.html (sections 2.6 and 3) https://sqlite.org/tempfiles.html#tempstore -Neal On Sat, Feb 1, 2020 at 10:09 AM J. King wrote: > On February 1, 2020 10:03:28 a.m. EST, Peng Yu

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

Also maybe Slipstreamed? -Neal On Monday, January 27, 2020, 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: >> > >> > &

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

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" has become a popular buzz-word that > > means "managed by my hosting provider rather than by me.” > > “Serverless” it a

Re: [sqlite] Capturing the changes in columns in a table

> Yes, a dumb of a system is provided daily There are some great solutions already here for offline processing as stated in your question. However, something you might also want to consider (if you have requisite access to the system) is to use ‘after insert’ trigger(s) to online capture the

Re: [sqlite] Allow inclusion of generate_series function

Hi, I think both your requirements and Dr Hipp's point-of-view are valid if we continue to see SQLite as just a tool. Yes, SQLite is an amazing tool for all the things it does and especially for a great design which almost never stands in the way of user customization and extension. However,

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

On Tue, Oct 9, 2018 at 5:18 PM Warren Young wrote: > ... The problem is happening because spam gets reflected off this list, so > people click “This is Spam” in Gmail, which causes Gmail’s spam filters to > treat all messages on the list as more spammish. The more that happens, > the less

Re: [sqlite] LIMIT

> What would the window-function query be? Note: For anyone stumbling upon this thread, below code is not supported in SQLite natively. SELECT F1, F2 FROM ( SELECT F2, F1, Rank() OVER (PARTITION BY F2 ORDER BY F1 ) AS Rank FROM T )

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

t 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 sub sk79 > >Sent: Tuesday, 5 December, 201

[sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

Hi All: The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite and Oracle-TM BerkeleyDB (https://www.metatranz.com/stepsqlite) is due soon and is packed with Super Powers which will blow your mind! For a start, how about powerful Analytic Window Functions, Collections, Bulk-Ops?

Re: [sqlite] Any chance of exposing INTEGER PRIMARY KEY metadata? Needed by many tools

On Tue, Nov 28, 2017 at 9:33 PM, J. King wrote: > ...*that I never thought to ask*, many of which have been helpful in > refining my application. ... > +1 that. That is the main advantage of a mailing list over a forum with filter-bubble or god forbid 'personalization'. I

Re: [sqlite] Many ML emails going to GMail's SPAM

Sqlite had a forum in the past on Nabble. Seems nice to me, I still get several hits to nabble when googling for sqlite issues. What didn't work there? -SK On Tue, Nov 21, 2017 at 9:30 AM, Richard Hipp wrote: > On 11/21/17, Paul Sanderson wrote:

Re: [sqlite] Many ML emails going to GMail's SPAM

I vote to keep mailing list. It works great for me with GMail (accessible from all my devices instantly) Reasons: 1. GMail has a threaded view built-in which works great. You might need to enable it in settings. 2. I doubt if any spam filter can ever be better than Gmail's. Spam fighting is not

[sqlite] segfault in load-extension but not in app

Hi, I am getting seg fault when same code is run as loadable-extension but not when run as shared lib linked to app. Thanks in advance for all help. The C++ code is compiled to 1. shared library and linked to app 2. loadable-extension and loaded from sqlite command line using '.load'. The C++

Re: [sqlite] Ordering a GROUP BY, or other concatenating tricks?

On Wed, Oct 4, 2017 at 12:29 PM, Richard Hipp wrote: > > This restriction on the query flattener causes your example > query above to do what you want. > If subquery-flattening needs to be disabled explicitly, is using "LIMIT -1 OFFSET 0 " the recommended way? > SQLite

[sqlite] Held transaction: behavior different for Rollback-To and Rollback

Hi, Using SQLite3.6.22 If a transaction is holding database lock (transaction started using BEGIN IMMEDIATE) and application code, without first calling sqlite3_reset(), tries to 1. Rollback-To: hangs waiting for the lock 2. Rollback: fails with message "database is locked". Is this

[sqlite] Membership operator 'IN' documentation

Hi, The 'IN' operator syntax diagram shows a possible table name operand IN [Database_Name DOT ] Table_Name But its description seems to be missing from the paragraph about 'IN' operator down on the page. Thanks, SK ___ sqlite-users mailing list

Re: [sqlite] Avoiding Database Is Locked Error

> I'm running on SCO OpenServer so I'm not sure your product would work for me but I'll take a look StepSqlite compiler's Linux target generates shared objects (.so) that should work on virtually all Unix-like systems thanks to ELF format. As an aside, further in SQLite exploration you may find

Re: [sqlite] Avoiding Database Is Locked Error

Hi Shawn, > demonstrate SQLite best > practices, including how to correctly handle error conditions, such as > the database is locked condition? > If you pre-select and then modify, you have to be aware enough to > realize you MUST wrap the whole process in a manual transaction, > and you

[sqlite] Berkeley DB adds SQL using SQLite API !!

Hi, Somehow no one seems to have mentioned it on this mailing list so far!? Here is the scoop... On March 23, Oracle announced the latest release of Oracle® Berkeley DB - 11g Release 2 - which introduces a new SQL API, based on lo and behold, SQLite v3 API. What this means is that all tools

Re: [sqlite] Need Help SQL

Hi!, Here is a non-math version using PL/SQL date operators and functions available in StepSqlite (https://www.metatranz.com/stepsqlite/). Hopefully this should be easier to follow. You can compile the below code directly to a win32 dll on the StepSqlite website and then use it in your VB code.

Re: [sqlite] ROWID bug in SELECT with JOIN?

gor Tandetnik <itandet...@mvps.org> wrote: > sub sk79 <subs...@gmail.com> wrote: >> Select with two tables joined has no _rowid_ column in select columns. >> I think this is a bug - just a quick check with the community before >> filing a bug report. >> >&g

Re: [sqlite] Most wanted features of SQLite ?

StepSqlite PL/SQL compiler for SQLite is certainly not for all. It is simply aimed at what we believe is a majority. http://www.metatranz.com/stepsqlite/ regards, -sk >>But I write stored procedures and triggers for PostgreSQL on Tcl. PL/pgSQL or >>PL/SQL is not the best solution to all.

Re: [sqlite] Most wanted features of SQLite ?

>> 1. Generate a loadable SQLite extension and distribute it with DB. > > We can write C extension without any wrapper. Why we need to learn > your extension for getting the same result and possible new bugs? PL/SQL has a very wide user-base and a huge repository of existing code-base in the

Re: [sqlite] Most wanted features of SQLite ?

The word 'Stored Procedures ' when used in the context of DBMS is used to refer to several meanings: 1. Efficiency - compile once when 'stored' and run multiple-times. 2. Data Encapsulation & Access control for DB - DB owns and controls access to its API 'stored' in it. 3.

Re: [sqlite] Booleans in SQLite

> >                I'm just curious how difficult it would be to add > support for booleans in SQLite. > > as well as use those keywords instead of creating integer > fields using 0 and 1. > Check out StepSqlite PL/SQL compiler for SQLite which supports BOOLEAN data type among many other

Re: [sqlite] load extension -- unload hook?

Sure! Here are the results: Good: The 'destructor' function attribute works just as advertised. I have included below the modified half.so example code from sqlite website with the 'constructor' and 'destructor' functions (for linux using gcc). Bad: The '.q' command on

Re: [sqlite] load extension -- unload hook?

Firstly thanks to both of you for useful replies. Here is the new info I got from your replies: 1. sqlite_load_extension is per-db-connection - Oddly I did not see any explicit reference to this in either of the two places I looked for it: i)

[sqlite] load extension -- unload hook?

Hi, When we load an extension it invokes sqlite3_extension_init(). Lets say, in addition to creating functions, the loaded extension library also does some internal data structure allocations, initializations etc here. Now, when the database is closed the loaded extension needs to do cleanup.

Re: [sqlite] loadable extension doesn't load

Thanks! -SK On Tue, Aug 25, 2009 at 8:09 PM, Roger Binns <rog...@rogerbinns.com> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > sub sk79 wrote: > > I followed the exact instructions ( > > http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions) on

[sqlite] loadable extension doesn't load

Hi, I followed the exact instructions ( http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions) on SQLite wiki for loadable extensions and still have run into this issue. Can someone help me here? @HOME-Ubuntu:~/utils/sqlite/sqlite-3.6.17$ gcc -I`pwd` -fPIC -shared ./loadableext.cpp -o

Re: [sqlite] how can we solve IF EXIST in SQLite

Hi, You might want to check-out StepSqlite PL/SQL compiler for SQLite at http://www.metatranz.com/stepsqlite Using it you can write the trigger (as part of a package body) almost the way you wrote in original post. StepSqlite compiles the PL/SQL code to a linux x86 shared library which can be