The SUBCLUB discussion FORUM -- which started in 1996 -- is now archived

[xkaes]

If you have subminiature photography questions, the SUBCLUB discussion FORUM -- which started in 1996 -- is now archived and available to all. After all, many questions pertaining to these cameras were a lot easier to answer 30 years ago.

Here's a summary from the "manager":

I’m happy to announce the first release of the Submini-L Archive v1.2, a fully searchable and curated edition of our mailing list covering messages from 1996 through 2025.

This version includes:

Cleaned message content (MIME headers removed)
Full-text search (FTS5) for subjects and message bodies
Custom SQL views (search by year, sender, or topic)
Metadata and versioning for long-term access

Designed for use with SQLiteFlow, DB Browser, or your favorite SQLite tool. (I am using SQLiteFlow on my iphone and iPad with great success).

This is the first release of the databse. I welcome feedback, corrections, and suggestions for future versions — including any missing messages (there are many missing from 1996) or new view ideas.

Download v1.2 ZIP Package:
https://www.dropbox.com/scl/fo/5led...ey=nqy0zk26itkfjbr4js2sfae79&st=pv3e0w82&dl=0

Many thanks to everyone who contributed over the years and made this list a success.

—
Larry Feldman
Submini-L Archivist

 

[koraks]

Congratulations with getting this useful resource online! Good job, I hope it'll serve many well.

 

[tjwspm]

Great!

For those who, like me, are not very familiar with SQLite, here is a brief guide to search the database:

1. Access the Website:
- Open your browser and go to https://sqliteonline.com/.

2. Open the Local Database:
- Extract the file submini_archive_full_v1_2.db of the .zip file
- In the browser click the „Import“ button on the top menu.
- Upload your local SQLite database file (e.g., `.db` file) from your computer by selecting it in the file chooser.
- Wait for the database to load; it will appear in the database list (`subminl_archive_full_v1.db`).

3. Explore the Database:
- In the left panel, expand the database name to see tables and views (e.g., `view_minox_mentions`).
- To view all data, enter `SELECT * FROM view_minox_mentions` in the SQL editor and click „Run“.

4. Run a new Query:
- In the SQL editor, enter the following query to find entries with "mamiya super 16" in `subject` or `body`, sorted by date (newest first):
SELECT * FROM view_minox_mentions
WHERE subject LIKE '%mamiya super 16%'
OR body LIKE '%mamiya super 16%'
ORDER BY date DESC;
- Click „Run“ to display the results: