Subj : Re: Mystic 2.0
To   : Ryan Fantus
From : g00r00
Date : Tue Sep 29 2020 11:02 am

 RF> Right - and making ontological changes or adding rows here and there
 RF> would be pretty straightforward, without some gross migration binary
 RF> each release.
 RF> 
 RF> That shit scares me. Hehe.

Yeah it is annoying to do and of course risky to some extent.

 RF> Memory is damn near free these days :) My VPS has 8GB RAM and idles
 RF> around 400MB. I love efficiency and optimization but also love utility,
 RF> hehe.

You're not wrong but it depends on what your target is! Lets say someone has 25
active nodes each with the need to have a DB connection.  It might look
something like:

  Mystic: 20kb * 25 = 500kb used for 25 active nodes
  SQLITE: 20MB * 25 = 500MB of memory
   MYSQL: 150MB

I just made those numbers up as estimates but consider that Mystic is developed
to target a Pi 1 or $5 Pi Zero that has 500MB of RAM as its minimal hardware.

I realize I am creating scenarios that are unlikely but I still like to take
scaling into consideration.  Maybe its left over trauma from writing Mystic
on a 386/16 and trying to make it run in 400kb of memory back in the day lol

There actually has been one Mystic BBS in recent times that I've seen 20+
active nodes on which is hard to believe but still possible somehow.

I tossed MYSQL in there because at some point MYSQL running locally becomes
more efficient due to the poor scaling and concurrancy of SQLITE.  Not trying
to knock SQLITE its awesome for what its designed for (its just not designed to
scale in a server).

 RF> Did The Millionaire fire up your Mystic 2 spirit?!

Nah I always have some sort of "dreamer" version of Mystic 2 in the works and
occasionally I release them if they start to become usable/I want people to
provide feedback.  I have all types of concepts for ideas laying around on disk
here (things like Threddit for example if you ever saw that)

I have three iterations of Mystic 2.x on my disk now.  The first was last
released in 2007 or so, the second was last released in 2016 or so, and the
third was never released.

Unfortunately I lost the Java version which was developed between the first and
second released iterations.  I am sad about that it was fun to work on!

--- Mystic BBS v1.12 A47 2020/09/27 (Windows/64)
 * Origin: Sector 7 | Mystic WHQ (1:129/215)

.