Rocksolid Light

Welcome to RetroBBS

register  nodelist  faq  

'Tis more blessed to give than receive; for example, wedding presents. -- H. L. Mencken


rocksolid / Rocksolid Nodes / latest

Re: sqllite, huh ?

rocksolid.nodes

Posted: 2 Days 1 Hour ago by: retro.guy"

More than 12 hours now as I'm making sure expire and nocem are working properly with the new setup, and making a few changes in the newsportal code to clean itself up when things change. Once I'm comfortable with it, I'll merge my dev br

Re: sql in rslight

rocksolid.nodes

Posted: 2 Days 2 Hours ago by: Retro Guy"

Exactly. novabbs.com is now a clone of rslight.i2p (the spool is a clone). I just zipped /var/spool/rslight and extracted it on novabbs.com and it works fine.

Re: sql in rslight

rocksolid.nodes

Posted: 2 Days 2 Hours ago by: Anonymous"

So on a new installation you can just unzip the sqlite files, and start from the status when you created the archives ?

Re: sqllite, huh ?

rocksolid.nodes

Posted: 3 Days ago by: retro.guy"

So far this seems fine. I also zipped the spool on one site and extracted it to another and ran it. All works fine. This only copies the spool, not the config settings, look of the site etc. Just wanted to make sure the dbs are portable a

Re: sqllite, huh ?

rocksolid.nodes

Posted: 5 Days 5 Hours ago by: retro.guy"

I'm currently upgrading rslight.i2p (novabbs.org) to use the new articles database. It's a test and I really hope it doesn't have too many issues. Yes, I have a full backup. Using a database for articles is a simple config option/toggle.

Re: rate limiting in rslight

rocksolid.nodes

Posted: 11 Days 17 Hours ago by: trw"

thx for the explanation. I was just wondering how a specific request is mapped to a session, but I can read it up in the php documentation then. if there are no cookies involved it is probably done with a session token ? I will check it o

Re: sqllite, huh ?

rocksolid.nodes

Posted: 13 Days 4 Hours ago by: retro.guy"

I've been working on the np "bug" for a while now and I think I have it working much better. This is the one where it rebuilds the entire group every chance it gets, which takes processing time. Now the groups are pruned if necessary, and

Re: rate limiting in rslight

rocksolid.nodes

Posted: 14 Days 13 Hours ago by: Retro Guy"

What I do is connect to the session in specific files, not every file: session_start(); Then verify a start time or create a start time (of the session), count hits (views), then I can monitor hit rates: $rate = ($_SESSION['views'] / (ti

Re: rate limiting in rslight

rocksolid.nodes

Posted: 14 Days 23 Hours ago by: Anonymous"

I was not aware that rslight uses sessions. How did you do that, cookies ? Good that it works against the crawlers, though. I just realized that cookies will not work against crawlers that do not take them, so probably you have found ano

rate limiting in rslight

rocksolid.nodes

Posted: 15 Days 1 Hour ago by: retro.guy"

I've finally set up rate limiting in rslight so that it's not necessary to do so with web server settings. The server works great for this as long as each client has it's own ip address, which is fine in clearnet and i2p, but does not wor

spamassasin

rocksolid.nodes

Posted: 15 Days 2 Hours ago by: retro.guy"

Apparently I had spamassassin disabled on novabbs.com for a while. Not sure how long. That is fixed now, hopefully it will do it's job :)

Re: sqllite, huh ?

rocksolid.nodes

Posted: 20 Days 1 Hour ago by: Retro Guy"

One issue I had with the way np handled it is that the entire group is serialized into a file, and it (np) would just delete the file and recreate it (takes a long time) for any changes (like the server expired an article, etc.). Now th

Re: sqllite, huh ?

rocksolid.nodes

Posted: 21 Days 5 Hours ago by: Retro Guy"

I finally have newsportal using a sqlite database for thread data. I have not done anything past that, just changed the way it stores the data from a big 'serialized' file to a .db3. It seems to be working fine. Right now this is only run

Re: sqllite, huh ?

rocksolid.nodes

Posted: 28 Days 11 Hours ago by: Retro Guy"

That is something I've given some thought to and I agree, a full text search on text files is very slow and keeps the server pretty busy. It's not an idea I've dropped, just that it will take some more consideration. But I agree, it woul

Re: sqllite, huh ?

rocksolid.nodes

Posted: 28 Days 11 Hours ago by: trw"

If I had one feature request, it would be fulltext search on a group or section (so: doing the search also on the bodies). Not sure if this is doable in a sane time window though if messages are not in a db.

Re: sqllite, huh ?

rocksolid.nodes

Posted: 29 Days ago by: retro.guy"

Thank you for that feedback :) I just made a change to handle multibyte (names, subject) better. Seems ok but I'll keep monitoring. Next is to combine search across 'sections'. This is part of a change that will make it simple to move a

16 recent articles found.

rocksolid light 0.6.7
clearnet i2p tor