Hey guys, I wanted to have this a little more open of a discussion, so I made a new thread.
So I'm starting to plan out the new system and I'm going SQL based. The old system used a boat load of regex, awk, grep, etc. It was pretty dirty, but it worked. The lists generated were stored in a flat file. The new system is going to be way more flexible.
My thoughts are this...
- SQL based realtime list generation
- Subscriber managed private black/white lists (configured per device)
- Subscriber selectable list size (for 32M, 64M, 256M, 512M, 1G+ device)
- Subscriber selectable country blocking (for devices that have enough memory)
Moving to SQL will give this functionality, it will also allow the server to update the blacklists in realtime without blocking downloads. I haven't yet found a way to do non-blocking updates on the client side. (Sorry, no BGP - too complicated to manage, this needs to be fully automated)
So, this is all still only on paper, so if anyone has more ideas, lets hear it.