Re: Questions about database (PostgreSQL)

["Jason Robertson" <jason () ifutureinc com>]

Also so you do know on www.snort.org there is a php script that I created for 
this as well.. Oh and as for the portscan, you might want to make another 
table for that information, or to strip some of that data down (That module 
needs major rework, to clean it up)


On 26 Jul 2001, at 19:12, Jed Pickel wrote:

Date sent:              Thu, 26 Jul 2001 19:12:38 -0400
From:                   Jed Pickel <jed () pickel net>
To:                     Jason Robertson <jason () ifutureinc com>
Copies to:              Snort Users <snort-users () sourceforge net>
Subject:                Re: [Snort-users] Questions about database (PostgreSQL)

> On Thu, Jul 26, 2001 at 04:03:27PM -0400, Jason Robertson wrote:
> > Why not for postgres at least, use foreign keys.  
> > As I have to change the create_postgresql file each time 
> > to tie them in like that.. I use them primarily for cleaning the database.
>
> Good idea... I'll add Postgresql foreign keys in the next version of
> the schema.
>
> > This is what I have for that though using scheme 102 (I haven't had time to
> > change 103, though the changes do get annoying) (I might actually just do an
> > update script for this, instead)
>
> I'm working on a tool to generate consistent schemas across mysql,
> postgresql, oracle, etc that will be more user friendly than the
> current method of creating the database tables. This should also make
> adding and maintaining support for more databases easier. Once I get
> the basics tackled I'll add migration support so upgrading schemas
> will be automatic.
>
> * Jed



---
Jason Robertson                
Network Analyst            
jason () ifutureinc com    
http://www.astroadvice.com      

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users