Rocksolid Light

Welcome to RetroBBS

mail  files  register  newsreader  groups  login

Message-ID:  

If it wasn't for Newton, we wouldn't have to eat bruised apples.


devel / comp.sys.acorn.apps / Re: Sqlite files

SubjectAuthor
* Sqlite filesDave
+* Re: Sqlite filesTim Hill
|`- Re: Sqlite filesDave
`* Re: Sqlite filesKevin Wells
 `* Re: Sqlite filesDave
  `* Re: Sqlite filesSteve Fryatt
   `* Re: Sqlite filesDave
    `- Re: Sqlite filesJean-Michel

1
Sqlite files

<5947cda3d2dave@triffid.co.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=573&group=comp.sys.acorn.apps#573

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: dave@triffid.co.uk (Dave)
Newsgroups: comp.sys.acorn.apps
Subject: Sqlite files
Date: Tue, 06 Jul 2021 14:38:04 +0100
Organization: TLP
Lines: 9
Message-ID: <5947cda3d2dave@triffid.co.uk>
X-Trace: individual.net KdRNDT9oWctWd9+bVUjAlQvyjZZynhTnqmpIWMzaBO0alwNSyI
X-Orig-Path: triffid.co.uk!dave
Cancel-Lock: sha1:ugyc0dacRQzEf+y96HAvBqfwsvc=
User-Agent: Pluto/3.18 (RISC OS/6.20) NewsHound/v1.52-32
 by: Dave - Tue, 6 Jul 2021 13:38 UTC

G'day folks.
Are there any RISC OS apps to read/edit sqlite files?

Thanks
Dave

--

Dave Triffid

Re: Sqlite files

<5947e3eddbtim@invalid.org.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=574&group=comp.sys.acorn.apps#574

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!aioe.org!ulnWVT+wgYxOCZOKlcBxbw.user.gioia.aioe.org.POSTED!not-for-mail
From: tim@invalid.org.uk (Tim Hill)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Tue, 06 Jul 2021 18:41:32 +0100
Organization: timil.com
Lines: 6
Message-ID: <5947e3eddbtim@invalid.org.uk>
References: <5947cda3d2dave@triffid.co.uk>
NNTP-Posting-Host: ulnWVT+wgYxOCZOKlcBxbw.user.gioia.aioe.org
X-Complaints-To: abuse@aioe.org
User-Agent: Pluto/3.16 (RISC OS/5.24) NewsHound/v1.50-32
X-Notice: Filtered by postfilter v. 0.9.2
 by: Tim Hill - Tue, 6 Jul 2021 17:41 UTC

In article <5947cda3d2dave@triffid.co.uk>, Dave <dave@triffid.co.uk>
wrote:
> G'day folks. Are there any RISC OS apps to read/edit sqlite files?

https://www.riscosopen.org/forum/forums/1/topics/16428?page=1

Re: Sqlite files

<5947e6da1bdave@triffid.co.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=575&group=comp.sys.acorn.apps#575

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: dave@triffid.co.uk (Dave)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Tue, 06 Jul 2021 19:13:27 +0100
Organization: TLP
Lines: 15
Message-ID: <5947e6da1bdave@triffid.co.uk>
References: <5947cda3d2dave@triffid.co.uk> <5947e3eddbtim@invalid.org.uk>
X-Trace: individual.net p/ffiIDs+SMh5GabThRypgEET1ld2pydvf6Odfo45OHM7Ke80O
X-Orig-Path: triffid.co.uk!dave
Cancel-Lock: sha1:/41o7fCwPsOiAYhagGF4eTwH0os=
User-Agent: Pluto/3.18 (RISC OS/6.20) NewsHound/v1.52-32
 by: Dave - Tue, 6 Jul 2021 18:13 UTC

In article <5947e3eddbtim@invalid.org.uk>,
Tim Hill <tim@invalid.org.uk> wrote:
> In article <5947cda3d2dave@triffid.co.uk>, Dave <dave@triffid.co.uk>
> wrote:
> > G'day folks. Are there any RISC OS apps to read/edit sqlite files?

> https://www.riscosopen.org/forum/forums/1/topics/16428?page=1

Thank Tim, I'll have a butchers later.

Dave

--

Dave Triffid

Re: Sqlite files

<5466ec4759.Kevin@Kevsoft>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=576&group=comp.sys.acorn.apps#576

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!aioe.org!SdFN+szAwyWXHnxp90OhJg.user.gioia.aioe.org.POSTED!not-for-mail
From: kev@kevsoft.co.uk (Kevin Wells)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Tue, 06 Jul 2021 20:14:03 +0100
Organization: Aioe.org NNTP Server
Lines: 16
Message-ID: <5466ec4759.Kevin@Kevsoft>
References: <5947cda3d2dave@triffid.co.uk>
NNTP-Posting-Host: SdFN+szAwyWXHnxp90OhJg.user.gioia.aioe.org
X-Complaints-To: abuse@aioe.org
User-Agent: Messenger-Pro/8.04 (MsgServe/8.04) (RISC-OS/5.29) NewsHound/v1.52-32
X-Notice: Filtered by postfilter v. 0.9.2
 by: Kevin Wells - Tue, 6 Jul 2021 19:14 UTC

In message <5947cda3d2dave@triffid.co.uk>
Dave <dave@triffid.co.uk> wrote:

>G'day folks.
>Are there any RISC OS apps to read/edit sqlite files?
>

This thread from the RISC OS Open fourns may be of use:

<https://www.riscosopen.org/forum/forums/1/topics/16428>

--
Kev Wells
http://kevsoft.co.uk/ https://ko-fi.com/kevsoft
carpe cervisium
An' if sometimes our conduck isn't all your fancy paints,

Re: Sqlite files

<594826eb97dave@triffid.co.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=577&group=comp.sys.acorn.apps#577

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: dave@triffid.co.uk (Dave)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Wed, 07 Jul 2021 06:53:15 +0100
Organization: TLP
Lines: 24
Message-ID: <594826eb97dave@triffid.co.uk>
References: <5947cda3d2dave@triffid.co.uk> <5466ec4759.Kevin@Kevsoft>
X-Trace: individual.net zdq8wyhDPgE5hoPJcWlT1Q0KttwlcVkeSUm/4CifMHJKD0Jh38
X-Orig-Path: triffid.co.uk!dave
Cancel-Lock: sha1:hU6VUsq5gzXliSCvqf8jGmPZT5U=
User-Agent: Pluto/3.18 (RISC OS/6.20) NewsHound/v1.52-32
 by: Dave - Wed, 7 Jul 2021 05:53 UTC

In article <5466ec4759.Kevin@Kevsoft>,
Kevin Wells <kev@kevsoft.co.uk> wrote:
> In message <5947cda3d2dave@triffid.co.uk>
> Dave <dave@triffid.co.uk> wrote:

> >G'day folks.
> >Are there any RISC OS apps to read/edit sqlite files?
> >

> This thread from the RISC OS Open fourns may be of use:

> <https://www.riscosopen.org/forum/forums/1/topics/16428>

Thanks Kevin and Tim,
I've had a look, even downloaded but it appears to be a CLI operation and
that's not what I'm looking for, so I guess over to MS-Windows again.

Thanks anyway. :-)

Dave

--

Dave Triffid

Re: Sqlite files

<mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=578&group=comp.sys.acorn.apps#578

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!aioe.org!zrJrIZDGYKPN2HyOkNjc9g.user.gioia.aioe.org.POSTED!not-for-mail
From: news@stevefryatt.org.uk (Steve Fryatt)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Wed, 7 Jul 2021 22:39:14 +0100
Organization: Aioe.org NNTP Server
Lines: 15
Message-ID: <mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk>
References: <5947cda3d2dave@triffid.co.uk> <5466ec4759.Kevin@Kevsoft>
<594826eb97dave@triffid.co.uk>
NNTP-Posting-Host: zrJrIZDGYKPN2HyOkNjc9g.user.gioia.aioe.org
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@aioe.org
User-Agent: Messenger-Pro/2.73.6.4252 (Qt/5.12.8) (Linux-x86_64)
X-Notice: Filtered by postfilter v. 0.9.2
 by: Steve Fryatt - Wed, 7 Jul 2021 21:39 UTC

On 7 Jul, Dave wrote in message
<594826eb97dave@triffid.co.uk>:

[SQLite]

> I've had a look, even downloaded but it appears to be a CLI operation and
> that's not what I'm looking for, so I guess over to MS-Windows again.

SQLite is a database library for developers to use to implement a databse in
their software, not a database itself.

--
Steve Fryatt - Leeds, England

http://www.stevefryatt.org.uk/

Re: Sqlite files

<5948aa21abdave@triffid.co.uk>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=579&group=comp.sys.acorn.apps#579

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: dave@triffid.co.uk (Dave)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Thu, 08 Jul 2021 06:46:26 +0100
Organization: TLP
Lines: 29
Message-ID: <5948aa21abdave@triffid.co.uk>
References: <5947cda3d2dave@triffid.co.uk> <5466ec4759.Kevin@Kevsoft> <594826eb97dave@triffid.co.uk> <mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk>
X-Trace: individual.net k2ukVHMzyV1EuWkCQQMFLwVAFnq/cXnfh0jANC9Dbbn2LTqZzi
X-Orig-Path: triffid.co.uk!dave
Cancel-Lock: sha1:wec1TLdDVqpvpxSdjWGjhxzPB+c=
User-Agent: Pluto/3.18 (RISC OS/6.20) NewsHound/v1.52-32
 by: Dave - Thu, 8 Jul 2021 05:46 UTC

In article <mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk>,
Steve Fryatt <news@stevefryatt.org.uk> wrote:
> On 7 Jul, Dave wrote in message
> <594826eb97dave@triffid.co.uk>:

> [SQLite]

> > I've had a look, even downloaded but it appears to be a CLI operation
> > and that's not what I'm looking for, so I guess over to MS-Windows
> > again.

> SQLite is a database library for developers to use to implement a
> databse in their software, not a database itself.

Indeed...
And my original question was:
"Are there any RISC OS apps to read/edit sqlite files?"

That being a DB browser for sqlite files.

Obviously not! :-)

Thanks for clearing up the confusion.

Dave

--

Dave Triffid

Re: Sqlite files

<c0a6bb4859.jmb@jmc.bruck.orange.fr>

  copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=580&group=comp.sys.acorn.apps#580

  copy link   Newsgroups: comp.sys.acorn.apps
Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: jmc.bruck@orange.fr (Jean-Michel)
Newsgroups: comp.sys.acorn.apps
Subject: Re: Sqlite files
Date: Thu, 08 Jul 2021 10:57:48 +0200
Organization: Jean-Michel
Lines: 36
Message-ID: <c0a6bb4859.jmb@jmc.bruck.orange.fr>
References: <5947cda3d2dave@triffid.co.uk> <5466ec4759.Kevin@Kevsoft> <594826eb97dave@triffid.co.uk> <mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk> <5948aa21abdave@triffid.co.uk>
Injection-Info: reader02.eternal-september.org; posting-host="2c19da759a394837593b482293d61f92";
logging-data="24677"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18POpnn485Es4nYo4p7NSm9xw0Ycr1kHSU="
User-Agent: Messenger-Pro/8.04 (MsgServe/8.04) (RISC-OS/5.29) NewsHound/v1.53-32 RC1
Cancel-Lock: sha1:objPnMYtT+ulhvv0Y09wa2tgvYk=
X-Editor: EmailEdit 2.03
 by: Jean-Michel - Thu, 8 Jul 2021 08:57 UTC

In message <5948aa21abdave@triffid.co.uk>
Dave <dave@triffid.co.uk> wrote:

> In article <mpro.qvw9h900k7qei03sy.news@stevefryatt.org.uk>,
> Steve Fryatt <news@stevefryatt.org.uk> wrote:
>> On 7 Jul, Dave wrote in message
>> <594826eb97dave@triffid.co.uk>:

>> [SQLite]

>>> I've had a look, even downloaded but it appears to be a CLI operation
>>> and that's not what I'm looking for, so I guess over to MS-Windows
>>> again.

>> SQLite is a database library for developers to use to implement a
>> databse in their software, not a database itself.

> Indeed...
> And my original question was:
> "Are there any RISC OS apps to read/edit sqlite files?"

> That being a DB browser for sqlite files.

> Obviously not! :-)

> Thanks for clearing up the confusion.

> Dave
Did you try with SQL tool?

You can see the different tables and their content. This can be exported
in csv.

--
Jean-Michel

1
server_pubkey.txt

rocksolid light 0.9.8
clearnet tor