The Nightstar Zoo

Nightstar IRC Network - irc.nightstar.net
It is currently Sat Nov 18, 2017 5:06 am

All times are UTC - 6 hours [ DST ]




Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 18 posts ] 

Keep the nickname and channel database or dump them?
Poll ended at Mon Aug 03, 2009 3:00 pm
Keep them (Option 1) 21%  21%  [ 3 ]
Dump them (Option 2) 79%  79%  [ 11 ]
I don't care 0%  0%  [ 0 ]
Total votes : 14
Author Message
PostPosted: Mon Jul 20, 2009 3:00 pm 
Offline
Official, By Popular Demand
User avatar

Joined: Fri May 30, 2003 1:05 am
Posts: 25
Hello Nightstarians,

We are looking to update our IRCd and Services software on the network and we're running into a bit of a question which we'd like to hear the community express more thoughts about. Currently our services package has data that is over 8 years old and has been slowly growing since then. While we would not say that we have an inordinate amount of data in the databases it is still considerable for our network.

  1. If we do a database conversion to another services package we are limited to one package (we'll call it package A). While it is indeed an equivalent replacement for what we have we would infact have all the data we had before and a few added features. There is also a time investment to verify the export and import of the data. Looking forward, the development of this package may not be best for the longevity of Nightstar.
  2. If we skip the database conversion we are not limited to the same package and are open to a few more options. However with this option we would lose all data that is in the database. To this end, if we went this route we would keep a list of people with registered channels and nicknames to verify that people are just not squatting on others' channels. The packages we will have available for us will have more features and options than if we use package A. Also it would go without saying that we would notify all channel/nickname owners before hand to make sure they are ready for the transition.

If you have any concerns, questions, or comments please post them before. (please keep on topic as all posts that are not will be removed)


Top
 Profile  
 
PostPosted: Mon Jul 20, 2009 5:27 pm 
What, exactly, would be the ramifications of dumping the database? Is there anything that couldn't be remade/replaced with a modicum of effort?


Top
  
 
PostPosted: Mon Jul 20, 2009 6:26 pm 
Offline
Official, By Popular Demand
User avatar

Joined: Fri May 30, 2003 1:05 am
Posts: 25
When we say "dumping the database" we mean just that. Dropping it on the floor and walking away.

The major ramification of starting new or "dumping the database" is that people would have to re-register their nicknames and channels. As well as setup their access lists, channel modes, and any other settings they had before.


Top
 Profile  
 
PostPosted: Mon Jul 20, 2009 10:06 pm 
Don't know anything about access lists or channel modes, so unless registering a channel is significantly harder than registering a nick, or one of those access lists or chanel modes things is really complex... go for it.


Top
  
 
PostPosted: Mon Jul 20, 2009 10:23 pm 
Offline
Official, By Popular Demand
User avatar

Joined: Fri May 30, 2003 1:05 am
Posts: 25
Volkai wrote:
Don't know anything about access lists or channel modes, so unless registering a channel is significantly harder than registering a nick, or one of those access lists or chanel modes things is really complex... go for it.


Harder? No. More involved. Yes, but only for the larger channels. Most people would experience less than 10 minutes to get back to where they were before the databases were dumped. Larger channels might take more time as they have access to provide back to the channel and any modes that need to be set.


Top
 Profile  
 
PostPosted: Tue Jul 21, 2009 1:19 am 
Offline
Intern
Intern
User avatar

Joined: Sat Dec 11, 2004 4:13 pm
Posts: 1139
Location: Ground floor, first room on the right.
Dump 'em. Just give a few days' notice before you do, if that's possible.


Top
 Profile  
 
PostPosted: Tue Jul 21, 2009 7:42 am 
I agree, a clean slate on the database would likely be better for the network, even if it means a moment of discomfort to get nicks and channels reregged.


Top
  
 
PostPosted: Tue Jul 21, 2009 9:25 am 
Offline
Concession Worker
Concession Worker
User avatar

Joined: Tue Jul 01, 2003 5:26 pm
Posts: 1479
Location: R'lyeh
Nuke it from orbit.


Top
 Profile  
 
PostPosted: Fri Jul 24, 2009 5:55 pm 
Hmmm. Maybe you could just have something akin to a "click here from the channel/nick to prove it's still active"? That way it'd save some of the people using it headache from having to go back and re-adjust everything, especially if they were new when they set everything up.


Top
  
 
PostPosted: Fri Jul 24, 2009 8:50 pm 
Offline
Energizer Bunny
User avatar

Joined: Wed May 22, 2002 12:24 am
Posts: 1634
Given a little time alone with the system I could probably pull decent amounts of the data through the IRC services interface. I'd likely do that sort of thing on request as opposed to a big fancy automated deathmachine, though.

Automatically rebuilding the service database for the nicer new system is very difficult if not impossible, which is why we describe it as dropping the old database. For this reason even "confirm!" doesn't really work.

Vorn
Services Op


Top
 Profile  
 
PostPosted: Sat Jul 25, 2009 5:04 pm 
I d'know... I don't mind reestablishing the settings and access lists for my own channels, but I'm not looking forward to having all /my/ permissions in other's channels being reset. Not everyone's likely to be as on-the-ball about resetting things, or even recording what they were before they're lost.


Top
  
 
PostPosted: Sat Jul 25, 2009 6:15 pm 
Offline
Developer
Developer
User avatar

Joined: Sat May 11, 2002 3:28 pm
Posts: 526
Location: Shangri-La
macdjord wrote:
I d'know... I don't mind reestablishing the settings and access lists for my own channels, but I'm not looking forward to having all /my/ permissions in other's channels being reset. Not everyone's likely to be as on-the-ball about resetting things, or even recording what they were before they're lost.


That is precisely the reason why we will give at least 2 weeks notice before the switch happens. If we were to wait until the last moment to do the switch then yes people would be upset and scrambling to get things setup properly.

_________________
Network Administrator
Nightstar IRC Network


Top
 Profile  
 
PostPosted: Wed Jul 29, 2009 10:42 pm 
If the current database is in a standard format and has a record of the "last access time" for each nick/channel, why not just drop "old" channels/nicks, and then create a separate script that ports the whole database into the new services format, if necessary? At the very least, dropping unused nicknames and channels could help out quite a bit in making the database considerably smaller (and thus easier to transfer to a new format, if desired).

If the current database is not in a standard format, then I'd vote for nuking it (although I just barely got here, so my say doesn't really have any bearing at all -- just trying to be helpful :P).


Top
  
 
PostPosted: Thu Jul 30, 2009 10:20 am 
Offline
Developer
Developer
User avatar

Joined: Sat May 11, 2002 3:28 pm
Posts: 526
Location: Shangri-La
Tianon wrote:
If the current database is in a standard format and has a record of the "last access time" for each nick/channel, why not just drop "old" channels/nicks, and then create a separate script that ports the whole database into the new services format, if necessary? At the very least, dropping unused nicknames and channels could help out quite a bit in making the database considerably smaller (and thus easier to transfer to a new format, if desired).


The thing is we already do this via its built in cleaning out of old channels and nicks. There are no records that are stale or stagnant.

The major issue here is that the services package we currently use is old and outdated (read: unsupported for 2+ years). Some things will not import without some severe hacking. We've made several hacks to the database alone to make it work like we want it and porting from one format to another format is a huge time sink. We're looking at making a lot of changes that not only effect Services, but the IRCd. Honestly, there are only so many of us to do this and to spend 2+ weeks tweaking it so the data imports correctly isn't exactly what I would call "time efficient." Not only would this let us start with a clean database, it would also let the channel owners clean out people on their access lists.

_________________
Network Administrator
Nightstar IRC Network


Top
 Profile  
 
PostPosted: Thu Jul 30, 2009 3:50 pm 
Ah, ok. Makes sense :) Thanks for the detailed description :)


Top
  
 
PostPosted: Mon Aug 03, 2009 12:03 pm 
Personally we'd go with dump the database. Won't take long for us to register our channels and whatever again and there're new features and stuff. Go for it.


Top
  
 
PostPosted: Mon Aug 03, 2009 4:00 pm 
I vote for nuking.


Top
  
 
PostPosted: Tue Aug 04, 2009 3:10 pm 
Offline
Developer
Developer
User avatar

Joined: Sat May 11, 2002 3:28 pm
Posts: 526
Location: Shangri-La
Thank you everyone for your votes and input.

In light with your votes on this poll we will be going with Option 2 (Dumping the databases).

So this is your first notice that the databases will be dumped on, or the day before, September 12, 2009. We will be maintaining a list of all nick/channel registrations for a limited time afterwards as to deal with problems and other issues that might occur.

We will be sending out notices on the network 2 weeks before the event and another a few days before the event.

There will be plenty more than just new services on Nightstar. But we'll leave it at that for now...

_________________
Network Administrator
Nightstar IRC Network


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 18 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group