Server Help

Cyan~Fire · Posted: Tue Jan 25, 2005 3:56 pm Post subject:

If I had time, I'd offer to continue development on MERV myself. But I don't.
_________________
This help is informational only. No representation is made or warranty given as to its content. User assumes all risk of use. Cyan~Fire assumes no responsibility for any loss or delay resulting from such use.
Wise men STILL seek Him.

Mr Ekted · Movie Geek Gender: Joined: Feb 09 2004 Posts: 1379 Offline

I looked at adding Postgres support to PowerBot, but their file management is crap. Too many inter-dependencies. Trying to get it to build on my own (without using their make files) was a nightmare. I didn't want to take existing binaries because it wasn't clear what kind of compiler switches were used. This can be critical with single/multi-threading and various run-time switches.
_________________
4,691 irradiated haggis!

CypherJF · Posted: Tue Jan 25, 2005 5:05 pm Post subject:

*topic split requested.

*
_________________
Performance is often the art of cheating carefully. - James Gosling

D1st0rt · Posted: Tue Jan 25, 2005 10:55 pm Post subject:

How do you pronounce "Postgre"?
_________________

Underlord · Novice Gender: Joined: Feb 17 2004 Posts: 55 Offline

CypherJF · Posted: Wed Jan 26, 2005 1:20 pm Post subject:

Was going to say, I used the backbone Underlord had on that site ^--- for a few of my projects. The only issue I had was when the bot got disconnected and attempted to re-connect; it'd stall merv and eat up memory. :/ I forget the exact details of why; and I don't think I ever fixed it lol... but that plugin is no longer in devel anywho... lol...

Mr Ekted · Movie Geek Gender: Joined: Feb 09 2004 Posts: 1379 Offline

DB access needs to be built into the core AND run in a separate thread because:

- DB calls will not block bots
- DB connections can be shared
- modules do not have to know anything about DB implementation (ie include mysql.h)

The typical cavalier attitude that MERV coders tend to have is to embed mysql calls into all modules that need them, trigger off some event (eg game end), and do all DB access in-thread waiting for server responses. This is wrong in so many ways, and one of the reasons PowerBot coders secretly (or even openly) hate MERV coders. It's not really their fault mostly; they have all learned by taking code samples they didn't understand and tweaked them until they compiled and did approximately what was needed, regardless of how efficient.

Solo Ace · Posted: Wed Jan 26, 2005 6:17 pm Post subject:

Wow are there two completely different "coder" cultures in this "bot world" already?
That's uhm, pathetic?

Everyone has to start somewhere, and we all (well, there are exceptions) learn from our mistakes.

D1st0rt · Posted: Wed Jan 26, 2005 10:41 pm Post subject:

What about coders who take code samples, learn them, and then apply?