Re: Storing a chain

On Wed, Nov 19, 2003 at 16:08:47 +0100,
Johan Fredrik Øhman <johanfo(at)ohman(dot)no> wrote:
>
> 1) Use a Sequence number in the table. This way it is possible to use ORDER
> BY sequencenumber to retrive the correct list. This works, but you have to
> do some massive updating when you what to insert a rule between i.e "12" and
> "13".

I wouldn't think using a sequence would make much sense. You don't want
automatically generated unique values, you want to impose an order.
If you want easy insertion at the expense of larger indexes you are
probably better off using a text or numeric (using digits to the right
of the decimal point) key.

Why do you want your rules in a database? I would think that a plain
text file would be a better approach unless you either want to be able
to ask questions about your firewall rules or have some automated
system for changing the firewall rules based on contidions (e.g. time of day).