Gammon Software Solutions forum

Gammon Software Solutions forum

See www.mushclient.com/spam for dealing with forum spam. Please read the MUSHclient FAQ!

Entire forum
MUSHclient
Lua
Mapper! (Hehehehe.)

Home \| Users \| Search \| FAQ
Username:	Register forum user name
Password:	Forgotten password?

(New message)

Subject:	Mapper! (Hehehehe.)
Name:	Your forum user name. Register forum user name
Password:	Your forum password. Forgotten password?
Message:	[quote=David Haley] ODBC is a driver for accessing databases, a sort of interface that lets you run SQL queries if you will. Generally it's a PITA to program a driver much less a DBMS (underneath the driver), which is why people very rarely write their own database interfaces. Generally, the drivers work just fine... The problem is of course making sure that the database you're accessing has an intelligent design to it geared towards whatever purpose you're trying to accomplish. [/quote] Message to be posted (in English, please).
Forum codes:	Check this if your message uses 'forum codes' or templates (auto-detected for new posts). Forum codes Templates

Save this message ...

Subject review (reverse sequence)

Pages: 1 2 3 4 5

Posted by

Lisev Poland (8 posts)

Date

Sun 13 Mar 2005 03:42 PM (UTC) [ quote ]

Message

Hello

I see that you stopped posting on forum about progress on your mapper project. I bet you are either finished or just left it as it is ;)

I both cases, would you share with what you have done?
I would be thankful if you mail me the source code. (as I couln't find your email anywhere on forum and your web page)

Lisev

Posted by

Faux United Kingdom (77 posts)

Date

Sun 06 Feb 2005 03:17 AM (UTC) [ quote ]

Amended on Sun 06 Feb 2005 05:48 AM (UTC) by Faux

Message

Progress report!

Apart from being busy, I've been working on the speed.

I've re-written the way it reads the exits. For normal-ish sized maps, this has decreased the load time by a factor of about 2 -> 4, getting close to un-noticable now.

For this reason (and the fact that I can't get it to create multiple-dimension tables) I've abandoned the luadb extension, until it's necessary.

For the Big Area that I was talking about before (took, say, 60 seconds to load), the load now fails. This is possibly because of the 37,199 character sql query it tries to run. It passes actually calling the query, but the loop to read the data appears to be too mcuh for it. Just for a laugh I put the query into mysql, and that hung too, so.. I'm not aiming to fix it.

Next on the to-do list is re-building wxlua with a more up-to-date compiler and fix it a bit, allowing me to actually kill the window (and wx). Now that'd be a luxury.

Edit:
And more progress! I've managed to get wxLua to build too. New verions of compilers have given it xp skin support, and I'm now getting some very strange problems when you try to destroy the windows (as apposed to nothing happening). This may actually be a Mush thing. More after sleep.

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

Lisev Poland (8 posts)

Date

Sat 29 Jan 2005 10:23 AM (UTC) [ quote ]

Message

So how goes Faux with you mapper project? :) Finished/gave up/still working? :)

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Sun 23 Jan 2005 04:55 AM (UTC) [ quote ]

Message

Quote:
just trying to work out how to return a table :)

http://www.lua.org/pil/25.1.html - this explains both how to retrieve and return a table from/to Lua.

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Sun 23 Jan 2005 12:17 AM (UTC) [ quote ]

Message

Status report:

Gaaah.

Trying to find any kind of documentation on something that can be loaded with loadlib (not loadmodule) was fun.

I have a loadbale extension.. just trying to work out how to return a table :)

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Sat 22 Jan 2005 06:31 PM (UTC) [ quote ]

Message

Ah, yes, PostgreSQL, one mustn't forget it. :-)

Quote:
If it works, too, that's a plus. :)

Yes, except when it doesn't. :P

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Sat 22 Jan 2005 05:09 AM (UTC) [ quote ]

Message

Quote:
So you'd learn how to do it, but how do you know you're doing it the right way? :-P

..right? :p

Nah, what I meant was I learn by leeching other people's code and beating it senseless (like, stripping it from c++ to c), then duct-taping it on to my project. Normally ends up with me having a pretty good knowledge of what's going on by the end of it..
If it works, too, that's a plus. :)

Quote:
The major SQL flavors are..

And Postgres, just so you don't get eaten by trolls. :p

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Sat 22 Jan 2005 02:48 AM (UTC) [ quote ]

Message

Well, different implementations do sometimes have ever so slightly different syntax. The major SQL flavors are MySQL, Oracle and ODBC. Oracle has its own quirks as well; but generally it's not too hard to get queries working for one or the other.

Quote:
In case you hadn't guessed yet, I learn by the "duct tape" method. :p

So you'd learn how to do it, but how do you know you're doing it the right way? :-P

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Sat 22 Jan 2005 02:42 AM (UTC) [ quote ]

Message

I had a query that I was running on the MDB that was ran and returned correct results, but wasn't valid as what I'd call SQL (having used it through php/mysql), and didn't execute on my MySQL server (with an identical copy of the db). Some kind of syntax error, I don't remmeber.

I've deleted the code witht he query in, so I can't paste it to you :/

In case you hadn't guessed yet, I learn by the "duct tape" method. :p

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Fri 21 Jan 2005 10:46 PM (UTC) [ quote ]

Message

Quote:
And the SQL language that it uses ishorrid. :p

There is only one "SQL language" (modulo different standard versions); in fact, SQL stands for "Simple Query Language". There are of course various implementations of SQL that implement the standard slightly differently. Did you mean that its implementation was bad? What were you referring to?

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Fri 21 Jan 2005 07:39 PM (UTC) [ quote ]

Message

*nods, pretending to understand*

And the SQL language that it uses ishorrid. :p

--- Faus thge possibly very silightly intoxicated :P

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Fri 21 Jan 2005 03:38 PM (UTC) [ quote ]

Amended on Fri 21 Jan 2005 03:40 PM (UTC) by David Haley

Message

ODBC is a driver for accessing databases, a sort of interface that lets you run SQL queries if you will. Generally it's a PITA to program a driver much less a DBMS (underneath the driver), which is why people very rarely write their own database interfaces. Generally, the drivers work just fine... The problem is of course making sure that the database you're accessing has an intelligent design to it geared towards whatever purpose you're trying to accomplish.

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Fri 21 Jan 2005 03:32 PM (UTC) [ quote ]

Amended on Fri 21 Jan 2005 03:34 PM (UTC) by Faux

Message

Okay, if you want to be technically accurate it's from the MDAC SDK. :p

But yeah, I'm using code from there, because I had (and still have) absolutely no idea what ODBC is ;p

Quote:
And are you sure the leak is there to begin with?

If it is, it's not my problem ;p

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

Posted by

David Haley USA (3,881 posts)

bio Moderator

Date

Fri 21 Jan 2005 02:42 PM (UTC) [ quote ]

Message

Quote:
Theoretically the "copy from the samples directory then build it yourself" ones should build without error or leak :)

I disagree. I don't think samples are meant to be full & complete, production-ready programs. Rather, I think they're meant to show the overall guidelines, how to get something running conceptually. In fact, I tend to expect the bare minimum in terms of leaks etc. from a sample, unless it explicitly claims to be a full, complete & production-ready piece of code. But I suppose that's just a personal opinion...

But why are you taking code from the MSDN anyhow? Are you using ODBC stuff from there? And are you sure the leak is there to begin with? :)

David Haley aka Ksilyan
Head Programmer,
Legends of the Darkstone

http://david.the-haleys.org

Posted by

Faux United Kingdom (77 posts)

Date

Fri 21 Jan 2005 02:10 PM (UTC) [ quote ]

Message

Quote:
It might be faster to have an interface that returned a Lua array of results...

Already planned. =)

Quote:
I don't think that's cheating...

First build is going to do all of the array processing in the dll, which defeats the point of using Lua.. but I intend to generalise it at some point ;p

Quote:
They just show the concepts, so...

Theoretically the "copy from the samples directory then build it yourself" ones should build without error or leak :)

Faux, from Discworld. Feel free to come talk to me =)

http://faux.servebeer.com/

The dates and times for posts above are shown in Universal Co-ordinated Time (UTC).

To show them in your local time you can join the forum, and then set the 'time correction' field in your profile to the number of hours difference between your location and UTC time.

15,762 views.

This is page 3, subject is 5 pages long: 1 2 3 4 5

Reply to this subject Start a new subject Refresh page

Go to topic: Search the forum

Comments to: Gammon Software support
Forum RSS feed ( http://www.gammon.com.au/rss/forum.xml )