SQLnetNews - new small NNTP server with SQLite

[🇧🇫 🇧🇮 🇰🇭 🇨🇲]

check out this mega-awesome open-sourced freeware !



On 10/28/19 12:21 AM, ne...@zzo38computer.org usenetted:

> I wrote a new NNTP server software called sqlnetnews. It is using SQLite
> to store the data, it is written in C (with only 1411 lines of code so
> far!) and configuration is compiled into the program. (I actually wrote it
> some time ago, although I have not announced it util now.)
>
> I wrote it because I found that other NNTP server software does not have
> what I wanted, and may be too big and complicated, too. Also, I don't
> really like web forums and mailing lists and I think that NNTP is better.
>
> You can also mention any questions/comments you have on here, please.
>
> There are a few nonstandard features:
>
> * The POSTQUIT command is meant to be helpful for users who do not have
> specialized NNTP software. If using a server with this nonstandard command
> then you can prepare a "POSTQUIT" file and then just use nc and redirect
> stdin to read that file, in order to post the article.
>
> * SUBSCRIBE and UNSUBSCRIBE commands will work if enabled in the
> configuration file, although currently it won't send them to anyone; the
> program to do that would be a separate program and it is not yet written.
> Allowing mentioning an email address for subscription might also be useful
> for users who want to receive them by email. Therefore, probably this
> command should be disabled for now unless you can use it.
>
> * Supports 63-bit article numbers. If you do not post so many articles to
> reach the 31-bit limit then it will still be only 31-bits; if you have
> more articles than that then this is probably the simplest way that it can
> work; clients that do not understand this extension are guaranteed to
> break as soon as there are too many articles no matter what you do (I have
> seen other suggestions posted on this news.software.nntp, although you
> can't make it "automatically work" if the software doesn't support it, and
> my way is probably the simplest way, and works with the "bystand" NNTP
> client software, and maybe others too that I do not know about).
>
> It can also be helpful to mention Unusenet. Unusenet is a format for
> newsgroup names which are not part of Usenet; a server or client can
> easily deal with both Usenet and Unusenet together if wanted. There is
> many Unusenet hierarchies (all of which start with "un" and then one or
> more digits and then a dot), but perhaps the most common kind will be as
> follows: Start with "un" and then the number of parts of the domain name,
> and then a dot, and then the reverse domain name; you can then add further
> parts to the newsgroup name if wanted. That specifies the "authoritative
> server" for that newsgroup; non-authoritative servers are still possible.
> (In this way, the namespaces do not clash. Other Unusenet hierarchies can
> be used to avoid namespace clashes in different ways, which do not
> necessarily have any "authoritative server", or might use some method
> other than the internet; in all cases other than the reverse domain name
> case, they start with "un0.".)
>
> Fossil repository: http://zzo38computer.org/fossil/sqlnetnews.ui/
>
> Download: http://zzo38computer.org/prog/sqlnetnews.zip
>
>