On 2018/12/05 5:20 AM, Ryan Schmidt wrote:
Hello,
I have a corrupt SQLite database about which I'd appreciate your advice. The
data is not critical but I'd like to fix it if it's possible and not too
time-consuming. Even just knowing why the problem occurred or how to prevent it
in the
On 5 Dec 2018, at 5:16am, Ryan Schmidt wrote:
> https://kb.vmware.com/s/article/1008542
>
> "VMware ESX acknowledges a write or read to a guest operating system only
> after that write or read is acknowledged by the hardware controller to ESX.
> Applications running inside virtual machines on
On Dec 4, 2018, at 22:42, Simon Slavin wrote:
> On 5 Dec 2018, at 3:20am, Ryan Schmidt wrote:
>
>> $ sqlite3 /opt/local/var/macports/registry/registry.db
>> SQLite version 3.25.2 2018-09-25 19:08:10
>> Enter ".help" for usage hints.
>> sqlite> .load /tmp/macports.sqlext
>> sqlite> pragma
On 5 Dec 2018, at 3:20am, Ryan Schmidt wrote:
> $ sqlite3 /opt/local/var/macports/registry/registry.db
> SQLite version 3.25.2 2018-09-25 19:08:10
> Enter ".help" for usage hints.
> sqlite> .load /tmp/macports.sqlext
> sqlite> pragma integrity_check;
> *** in database main ***
> On tree page
Hello,
I have a corrupt SQLite database about which I'd appreciate your advice. The
data is not critical but I'd like to fix it if it's possible and not too
time-consuming. Even just knowing why the problem occurred or how to prevent it
in the future would be helpful. If there's something the
On Nov 19, 2018, at 07:58, Charles Hudson wrote:
> I come from an ANSI SQL client / server background (Oracle, MS SQL) but am
> interested in finding a SQL database to install on an old Macintosh G3 Power
> PC that is running OS 9.2. I don't need network connectivity as this would
> be limited
On Tue, Dec 4, 2018 at 5:57 PM Richard Hipp wrote:
>
> On 12/4/18, Digital Dog wrote:
> >
> > I vote for GENERATE_SERIES to be included in official sqlite3 binary and
> > libraries.
>
> We are under pressure to keep SQLite as small and compact as possible.
> We cannot go adding every feature
My introspection pragma's work, and always have. Then again, I compile with
them turned on. Perhaps if they are available the option should appear in the
compile_options output, at least?
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated
On 12/4/18, Digital Dog wrote:
>
> I vote for GENERATE_SERIES to be included in official sqlite3 binary and
> libraries.
That seems unlikely, since you can accomplish the same thing using a
recursive common table expression.
We are under pressure to keep SQLite as small and compact as possible.
On Thu, 25 Oct 2018 09:32:05 -0700 Nathan Green wrote:
> According to the online documentation (https://www.sqlite.org/series.html
),
> generate_series is compiled into the command line shell. As it turns out,
> this is not so. It is not even an option in the build system from what I
> can tell.
WHERE filtering happens before aggregates, so you can't use it on an aggregate
column, only a HAVING clause works for that. Or you need to make it a sub-query
and surround it with another select to get the where
so something like...
select c, group_concat(p) as P from t group by c having P =
Prior to my original message I was playing around with group concat (even
though I know the order is considered arbitrary) but found I couldn't put a
where clause on that column.
Is there anything wrong with this code?
sqlite> select c, group_concat(p) as P from t group by c;
c P
On Tue, Dec 4, 2018 at 3:30 PM Richard Hipp wrote:
> On 12/4/18, Dominique Devienne wrote:
> > Wrong pragma never give errors AFAIK,
>
> That is how pragmas are designed to work, yes. Unknown pragmas are
> silently ignored.
Thanks for confirming my "AFAIK" Richard.
But no comment on my
On 12/4/18, Dominique Devienne wrote:
> Wrong pragma never give errors AFAIK,
That is how pragmas are designed to work, yes. Unknown pragmas are
silently ignored.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
On Tue, Dec 4, 2018 at 10:08 AM Dominique Devienne
wrote:
> On Fri, Nov 30, 2018 at 4:11 PM Dominique Devienne
> wrote:
>
>> Nothing returned, so obviously the -DSQLITE_INTROSPECTION_PRAGMAS
>> compile-time option is not used [1]. Could it be ON by default please?
>> TIA, --DD
>>
>
I've mixed up the adding orders to make sure they have no affect on the
outcome - and in the final results examples I've left all the columns so
you can see what is going on, but you of course need only one of the
columns in your desired output.
CREATE TABLE t (id integer primary key, c, p);
So reading your example I think you mean
Given a table with two columns, c and p, with no constraints what would be
the best way to query for those values of c such that
the set of corresponding values of p is equal to a specified set.
If p isn't text then I'd say something using group_concat
On Fri, Nov 30, 2018 at 4:16 PM Dominique Devienne
wrote:
> sqlite> select json_each('[1, 3, 5]');
> Error: no such function: json_each
> [...]
> Any chance we might get a more user-friendly error message?
> Like perhaps "Error: table-valued function not usable here: json_each"?
>
ping.
On Fri, Nov 30, 2018 at 4:11 PM Dominique Devienne
wrote:
> Nothing returned, so obviously the -DSQLITE_INTROSPECTION_PRAGMAS
> compile-time option is not used [1]. Could it be ON by default please?
> TIA, --DD
>
ping.
___
sqlite-users mailing list
19 matches
Mail list logo