Is there a command to 'browse' the schema?

[DR]

I would like to scroll through the scheme data base to see some values
which are being stored perhaps showing all 111 columns and displaying
row by row.


I couldn't find a weewx command to do that, but wonder if there is
something there which is a view only so damage cannot easily be done?

Back in my dBase days (yes, I'm that old) it was helpful to be able to
peer into the rows and columns and I'm wondering if there is an easy,
safe way to do that?   Dale

[Vince Skahan]

Google for ‘print sqlite3 schema’ please and look at the AI generated answer top of page.

(deleted previous answer that had a cut/paste error)

[DR]

Thank you.  That is helpful and I'll go looking.  Dale

[DR]

Yeah, but you have to be smart enough to know what question to ask! 
Thanks for the pointer.  Dale

[Vince Skahan]

Cmon Dale you asked the same question.  Or search the form for ‘sqlite3 schema’ which points you https://groups.google.com/g/weewx-user/c/fnWMiM1pvWs/m/sWYJeJb7AAAJ

Use the search tools. They work.

[DR]

They key was 'sqlite3' which did the trick and opened a whole lotta
stuff to study.  So far so good.  Dale

[Chuck Rhode]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 18 Feb 2026 18:53:54 -0600
DR <wxe...@gmail.com> wrote:

> I would like to scroll through the scheme data base to see some
> values which are being stored perhaps showing all 111 columns and
> displaying row by row.

There's always *sqlitebrowser*, which ought to be available as a Linux
package to install:

GUI editor for SQLite databases

> SQLite Database Browser is a visual tool used to create, design and
> edit database files compatible with SQLite. Its interface is based
> on QT, and is meant to be used for users and developers that want to
> create databases, edit and search data using a familiar
> spreadsheet-like interface, without the need to learn complicated
> SQL commands.

- --
.. Be Seeing You,
.. Chuck Rhode, Sheboygan, WI, USA
.. Weather: https://LacusVeris.com/Wx
.. 46° — Wind W at 7 mph. Sky clear.
-----BEGIN PGP SIGNATURE-----

iF0EARECAB0WIQT+MY/5I/LMPSswTbVg2/xipKOWUgUCaZZ2ewAKCRBg2/xipKOW
UhGEAJ9qV9ZStwZoBg3b7MYkKKEJuRX33QCeOqO+B242+eWX9CZ2X+vfcheRhyk=
=KkHe
-----END PGP SIGNATURE-----