• Mystic Question

    From Chad Adams@1:19/40 to g00r00 on Thu Mar 2 10:47:56 2023
    MSGID: 1:19/40 3486BAEE
    PID: CyberBBS v1.0.10
    g00r00,

    I have a question about how you laid our your db containing msgs that i
    thought you might answer.
    In storing messages, specifically echomail, do you save each kludge
    as a seperate value or do you just simply save the header info and then
    the entire message text with kludge?

    Appreicate it bud.

    -Nugax (cbbs)


    --- CyberBBS v1.0.10 2023/03/01 [Debian Linux/x64/x86_64]
    * Origin: CyberBBS WHQ BBS | http://www.cyberbbs.com (1:19/40)
  • From g00r00@1:129/215 to Chad Adams on Mon Mar 20 18:17:32 2023
    I have a question about how you laid our your db containing msgs that i thought you might answer.
    In storing messages, specifically echomail, do you save each kludge
    as a seperate value or do you just simply save the header info and then the entire message text with kludge?

    The message text and the kludges are stored separately. JAM bases have a message header/index with mostly integer-based data, and then a message text buffer. Part of that text storage is a sub-text buffer that stores custom fields and it has a variable length which allows field expandability without breaking the format. The subtext is where the kludges are stored.

    I believe Synchronet's format uses a similar approach too.

    ... A SQL query walks into a bar and sees two tables. Asks: 'Can I join you?'

    --- Mystic BBS v1.12 A49 2023/03/14 (Windows/64)
    * Origin: Sector 7 * Mystic WHQ (1:129/215)
  • From Chad Adams@1:19/40 to g00r00 on Thu Mar 23 06:33:12 2023
    thanks!
    -Nugax (cbbs)


    --- CyberBBS v1.0.11 2023/03/12 [Debian Linux/x64]
    * Origin: CyberBBS WHQ BBS | http://www.cyberbbs.co (1:19/40)