[Plugin] MySQL & PostgreSQL Plugin
#17

Quote:
Originally Posted by BlueG
View Post
Ok, seems like I have to tell you that this is somehow pissing me off. I have nothing against any plugin release, even if it is MySQL, but the way you have been handling this situation is quite annoying.

In January I decided to stop working on my plugin and you did ask me to continue it at some point. After some small fixes, additions and some code design changes ("java style", as you told me), you seemed to have lost interest. Now out of sudden you release your own plugin without any notice to me, which is the reason why I'm angry.
I've lost interest because the code was ugly and I felt bad to "correct" your code. I can give you examples of ugly code (it's about 90% of that plugin) if you want.

Quote:
Originally Posted by BlueG
View Post
This seems to be some kind of joke to me, because you are still using snippets of my plugin. The only difference (in the way how the plugin handles the MySQL stuff) I can see so far is, that you decided to use std::maps<> instead of vectors/queues, but I don't want to get into a further investigation.
Actual, the only SIMILARITY is the fact that I'm using your Mutex object and threads design. Everything else was written entirely by me (there might be some more similarities as I've seen your code and you inspired me, but I didn't intend to copy). CRY ME A RIVER, KID!

Quote:
Originally Posted by Y_Less
View Post
1) This has nearly half the number of functions of BlueG's - how are there more features?

2) You say you intend for this to be faster - have you got ANY plans on how to do this? Don't forget that the vast majority of the (lack of) speed in any MySQL plugin comes from MySQL itself. Even if your section of the code is 10x faster than BlueG's - if 99% of the code is internal MySQL stuff common to both then you have only improved the total execution time by 0.9%

3) If you thought the existing code was ugly, why not just clean it up a bit? That's got to be faster than developing (and testing) a whole new one, then getting people to convert.

4) There isn't really such a thing as a "quick" query - even just a "SELECT * WHERE" still has to compile the query and search the entire database. There was a reason non-threaded queries were removed, do you have any numbers, of ways of assessing what is "quick" and not "server hanging".

5) In what world is "mysql_connect" similar to "db_open"? Or the other functions - renaming everything is not my definition of an easy conversion!

6) You also mentioned improved stability - how are you going to assess and prove that too?
1. mysql_get_charset, mysql_set_charset, mysql_reconnect, mysql_reload, mysql_retrieve_row, mysql_stat - these are all the functions this plugin doesn't have. I've never used half of them so they weren't a priority for me. (Firstly, I wrote this plugin for MY server, before started working at BlueG's plugin)
However, my plugin still has multiple result sets and non-threaded queries (even if you don't like them, I find them useful).

2. It's clear that I can't optimize MySQL's api, but I'll try to optimise my code as much as possible. The difference would be narrow, but it would still be there.

3. I felt bad editing his code. I thought it was disrespectful of me.

4. It's quick because it doesn't have to be passed to another thread, execute it and call the callback. It's again, a narrow difference, but it does exists. I'm using non-threaded queries in OnGameModeInit and OnGameModeExit to load and save everything. They look better and I don't care if the server hangs as long as my data is loaded. I had a lazy MySQL server which loaded data from the server AFTER players connected.

5. Not all of them are alike, but most of them: db_close, db_free_result, db_num_rows, db_num_fields, db_field_name, db_query, ~db_get_field (has one extra parameter, `row`), ~db_get_field_assoc (same with `db_get_field`)

6. I'll run some 'hardcore' tests? I've succeeded in crashing BlueG's plugin sending a huge amount of data. I'll try the same with my plugin.

Quote:
Originally Posted by Kar
View Post
It used to crash my server 5-8+ times per day for months but I still continued to use it and still will up to this day. :P
That's what made me write another plugin.

--

You guys feed with hate. That's what I was afraid when I released this plugin.
Reply


Messages In This Thread
MySQL & PostgreSQL Plugin - by Dan.. - 09.04.2013, 19:38
Re: MySQL Plugin v0.1 BETA - by Djole1337 - 09.04.2013, 19:39
Re: MySQL Plugin v0.1 BETA - by Maxips2 - 09.04.2013, 19:54
Re: MySQL Plugin v0.1 BETA - by Djole1337 - 09.04.2013, 19:56
Re: MySQL Plugin v0.1 BETA - by steki. - 09.04.2013, 20:01
Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 20:07
Re: MySQL Plugin v0.1 BETA - by Maxips2 - 09.04.2013, 20:15
Re: MySQL Plugin v0.1 BETA - by Scenario - 09.04.2013, 20:21
Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 20:39
Re: MySQL Plugin v0.1 BETA - by Kar - 09.04.2013, 21:03
Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 21:17
Re: MySQL Plugin v0.1 BETA - by Scenario - 09.04.2013, 21:27
Re: MySQL Plugin v0.1 BETA - by Dan.. - 09.04.2013, 21:30
Re: MySQL Plugin v0.1 BETA - by RedCrossER - 09.04.2013, 21:37
Re: MySQL Plugin v0.1 BETA - by BlueG - 09.04.2013, 22:03
Re: MySQL Plugin v0.1 BETA - by Kar - 10.04.2013, 00:06
Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 07:52
Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 12:34
Re: MySQL Plugin v0.1 BETA - by Ernis456 - 10.04.2013, 13:08
Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 15:06
Re: MySQL Plugin v0.1 BETA - by Edvin - 10.04.2013, 16:13
Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 16:18
Re: MySQL Plugin v0.1 BETA - by Dan.. - 10.04.2013, 16:48
Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 16:52
Re: MySQL Plugin v0.1 BETA - by Jay_ - 10.04.2013, 17:43
Re: MySQL Plugin v0.1 BETA - by Kar - 10.04.2013, 18:16
Re: MySQL Plugin v0.1 BETA - by TheArcher - 10.04.2013, 18:25
Re: MySQL Plugin v0.1 BETA - by Maxips2 - 10.04.2013, 18:28
Re: MySQL Plugin v0.1 BETA - by AndreT - 10.04.2013, 18:34
Re: MySQL Plugin v0.1 BETA - by Jay_ - 10.04.2013, 18:42
Re: MySQL Plugin v0.1 BETA - by TheSka - 11.04.2013, 08:06
Re: MySQL Plugin v0.1 BETA - by Dan.. - 11.04.2013, 08:24
Re: MySQL Plugin v0.1 BETA - by TheSka - 11.04.2013, 08:46
Re: MySQL Plugin v0.1 BETA - by RajatPawar - 11.04.2013, 08:53
Re: MySQL Plugin v0.1 BETA - by MP2 - 11.04.2013, 09:27
Re: MySQL Plugin v0.1 BETA - by Dan.. - 11.04.2013, 10:43
Re: MySQL Plugin - by dnee - 12.04.2013, 01:05
Re: MySQL Plugin - by Dan.. - 12.04.2013, 11:59
Re: MySQL Plugin - by dnee - 12.04.2013, 15:02
Re: MySQL Plugin - by dnee - 12.04.2013, 15:08
Re: MySQL Plugin - by Dan.. - 12.04.2013, 16:44
Re: MySQL Plugin - by dnee - 12.04.2013, 16:57
Re: MySQL Plugin - by BrandyPenguin - 12.04.2013, 17:03
Re: MySQL Plugin - by dnee - 12.04.2013, 17:06
Re: MySQL Plugin - by BrandyPenguin - 12.04.2013, 17:13
Re: MySQL Plugin - by Dan.. - 12.04.2013, 18:13
Re: MySQL Plugin - by Dzines4SAMP - 20.04.2013, 03:21
Re: MySQL Plugin - by Dan.. - 23.04.2013, 15:10
Re: MySQL Plugin - by Gigi-The-Beast - 23.04.2013, 17:58
Re: MySQL Plugin - by Dan.. - 23.04.2013, 18:09
Re: MySQL Plugin - by Richard_Gere - 24.04.2013, 12:45
Re: MySQL Plugin - by Dan.. - 25.04.2013, 12:01
Re: MySQL Plugin - by Yiin - 07.05.2013, 11:12
Re: MySQL Plugin - by Dan.. - 07.05.2013, 11:52
Re: MySQL Plugin - by Richard_Gere - 07.05.2013, 12:13
Re: MySQL Plugin - by Ricop522 - 07.05.2013, 22:30
Re: MySQL Plugin - by Ryan_Obeles - 08.05.2013, 02:11
Re: MySQL Plugin - by Dan.. - 10.05.2013, 06:47
Re: MySQL Plugin - by Ryan_Obeles - 10.05.2013, 16:10
Re: MySQL Plugin - by Dan.. - 10.05.2013, 21:15
Re: MySQL Plugin - by Dan.. - 12.05.2013, 19:08
Re: MySQL Plugin - by Dan.. - 13.05.2013, 12:32
Re: MySQL Plugin - by Dan.. - 13.05.2013, 15:47
Re: MySQL Plugin - by Dan.. - 13.05.2013, 16:43
Re: MySQL Plugin v1.0 STABLE - by jordy.kiesebrink - 13.05.2013, 19:00
AW: MySQL Plugin - by AlexLS95 - 13.05.2013, 19:30
Re: AW: MySQL Plugin - by jordy.kiesebrink - 13.05.2013, 20:09
Re: MySQL Plugin - by Dan.. - 14.05.2013, 19:30
Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:37
Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:43
Re: MySQL Plugin - by Dan.. - 14.05.2013, 19:46
Re: MySQL Plugin - by Gamer_Z - 14.05.2013, 19:49
Re: MySQL Plugin - by jordy.kiesebrink - 14.05.2013, 20:20
Re: MySQL Plugin - by Dan.. - 15.05.2013, 10:23
Re: MySQL Plugin - by Edvin - 16.05.2013, 13:00
Re: MySQL Plugin - by InfiniTy. - 16.05.2013, 13:06
Re: MySQL Plugin - by Dan.. - 16.05.2013, 13:08
Re: MySQL Plugin - by fordawinzz - 18.05.2013, 13:23
Re: MySQL Plugin - by Dan.. - 18.05.2013, 14:06
Re: MySQL Plugin - by fordawinzz - 18.05.2013, 14:14
Re: MySQL Plugin - by Dan.. - 18.05.2013, 14:18
Re: MySQL Plugin - by fordawinzz - 18.05.2013, 14:35
AW: Re: MySQL Plugin - by maddinat0r - 22.05.2013, 16:31
Re: MySQL Plugin - by Dan.. - 22.05.2013, 16:38
Re: MySQL Plugin - by Dan.. - 02.06.2013, 12:51
Re: MySQL Plugin - by Kar - 02.06.2013, 14:44
Re: MySQL Plugin - by Kyle - 02.06.2013, 14:45
Re: MySQL Plugin - by Dan.. - 02.06.2013, 14:52
Re: MySQL Plugin - by Kar - 02.06.2013, 14:53
Re: MySQL Plugin - by Schocc - 02.06.2013, 17:16
Re: MySQL Plugin - by Richie© - 02.06.2013, 18:24
Re: MySQL Plugin - by TheArcher - 02.06.2013, 19:33
Re: MySQL Plugin - by AndreT - 02.06.2013, 20:32
Re: MySQL Plugin - by Baboon - 02.06.2013, 20:54
Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 08:38
AW: MySQL & PostgreSQL Plugin - by maddinat0r - 27.06.2013, 08:40
Re: MySQL & PostgreSQL Plugin - by Slice - 27.06.2013, 09:01
Re: MySQL & PostgreSQL Plugin - by AndreT - 27.06.2013, 12:05
Re: MySQL & PostgreSQL Plugin - by yanir3 - 27.06.2013, 12:47
Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 12:57
Re: MySQL & PostgreSQL Plugin - by AndreT - 27.06.2013, 13:24
Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.06.2013, 14:36
Re: MySQL & PostgreSQL Plugin - by CKA3KuH - 28.06.2013, 13:56
Re: MySQL & PostgreSQL Plugin - by Dan.. - 28.06.2013, 14:03
Respuesta: MySQL & PostgreSQL Plugin - by [DOG]irinel1996 - 28.06.2013, 15:08
Re: MySQL & PostgreSQL Plugin - by AndreT - 28.06.2013, 20:40
Re: MySQL & PostgreSQL Plugin - by Richard_Gere - 29.06.2013, 07:00
Re: MySQL & PostgreSQL Plugin - by Dan.. - 29.06.2013, 19:58
Re: MySQL & PostgreSQL Plugin - by Richard_Gere - 30.06.2013, 04:09
Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.06.2013, 10:22
Re: MySQL & PostgreSQL Plugin - by Ryan_Bowe - 30.06.2013, 23:46
Re: MySQL & PostgreSQL Plugin - by gilpenner - 01.07.2013, 05:57
Re: MySQL & PostgreSQL Plugin - by Jessyy - 02.07.2013, 21:51
Re: MySQL & PostgreSQL Plugin - by Pooh7 - 03.07.2013, 17:09
AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 17:06
Re: MySQL & PostgreSQL Plugin - by Kar - 22.07.2013, 17:21
AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 17:32
Re: AW: MySQL & PostgreSQL Plugin - by BlackBank - 22.07.2013, 18:24
AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 18:51
Re: MySQL & PostgreSQL Plugin - by RaZVaN ^ xD - 22.07.2013, 21:45
AW: MySQL & PostgreSQL Plugin - by Nanory - 22.07.2013, 23:55
Re: AW: MySQL & PostgreSQL Plugin - by Maxips2 - 24.07.2013, 19:45
Re: MySQL & PostgreSQL Plugin - by Djole1337 - 24.07.2013, 19:55
Re: MySQL & PostgreSQL Plugin - by BlackBank - 26.07.2013, 13:31
Re: MySQL & PostgreSQL Plugin - by Dan.. - 27.07.2013, 07:59
AW: MySQL & PostgreSQL Plugin - by maddinat0r - 27.07.2013, 11:29
Re: MySQL & PostgreSQL Plugin - by BlackBank - 27.07.2013, 13:01
AW: MySQL & PostgreSQL Plugin - by AlexLS95 - 27.07.2013, 13:08
Re: AW: MySQL & PostgreSQL Plugin - by BlackBank - 27.07.2013, 13:15
AW: MySQL & PostgreSQL Plugin - by AlexLS95 - 27.07.2013, 19:49
Re : MySQL & PostgreSQL Plugin - by HitnKill - 28.07.2013, 13:56
Re: Re : MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 16:36
Re: MySQL & PostgreSQL Plugin - by Maxips2 - 30.07.2013, 17:28
Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 17:41
Re: MySQL & PostgreSQL Plugin - by Gigi-The-Beast - 30.07.2013, 17:41
Re: MySQL & PostgreSQL Plugin - by Maxips2 - 30.07.2013, 17:42
Re: MySQL & PostgreSQL Plugin - by Dan.. - 30.07.2013, 17:48
Re: MySQL & PostgreSQL Plugin - by Kar - 30.07.2013, 20:18
Re: MySQL & PostgreSQL Plugin - by BlackBank - 30.07.2013, 22:53
Re: MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 05:03
Re: MySQL & PostgreSQL Plugin - by fordawinzz - 31.07.2013, 08:37
Re: MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 09:58
AW: Re: Re : MySQL & PostgreSQL Plugin - by maddinat0r - 31.07.2013, 11:02
Re: AW: Re: Re : MySQL & PostgreSQL Plugin - by Dan.. - 31.07.2013, 11:29
Re: MySQL & PostgreSQL Plugin - by d711728 - 07.02.2014, 22:45
Re: MySQL & PostgreSQL Plugin - by RoW001 - 12.02.2014, 10:24
AW: MySQL & PostgreSQL Plugin - by Mellnik - 12.02.2014, 13:01
Re: MySQL & PostgreSQL Plugin - by RoW001 - 13.02.2014, 09:45
Re: MySQL & PostgreSQL Plugin - by iZN - 13.02.2014, 10:52
Re: MySQL & PostgreSQL Plugin - by kristo - 16.02.2014, 11:04
Re: AW: MySQL & PostgreSQL Plugin - by AndreT - 16.02.2014, 13:09
Re: MySQL & PostgreSQL Plugin - by vent - 20.02.2014, 14:24
Re: MySQL & PostgreSQL Plugin - by OnPlayerText - 26.02.2014, 05:20
Re: MySQL & PostgreSQL Plugin - by Sagna - 27.02.2014, 16:19
Re: MySQL & PostgreSQL Plugin - by Quis - 07.03.2014, 20:22
Re : MySQL & PostgreSQL Plugin - by khimera - 09.09.2014, 01:41
Re: Re : MySQL & PostgreSQL Plugin - by Djole1337 - 29.09.2014, 12:43
Re: MySQL & PostgreSQL Plugin - by Ochenta - 10.10.2014, 17:24
Re: MySQL & PostgreSQL Plugin - by bogushas - 13.12.2014, 08:11
Re: MySQL & PostgreSQL Plugin - by CachorroDoDavyJones - 03.01.2015, 21:24
Re: MySQL & PostgreSQL Plugin - by Abagail - 03.01.2015, 21:32
Re: MySQL & PostgreSQL Plugin - by TheCartman - 20.01.2015, 08:55
Re: MySQL & PostgreSQL Plugin - by Djole1337 - 20.01.2015, 08:59
Re: MySQL & PostgreSQL Plugin - by TheCartman - 20.01.2015, 20:32
Re: MySQL & PostgreSQL Plugin - by Djole1337 - 21.01.2015, 00:55
Re: MySQL & PostgreSQL Plugin - by TheCartman - 21.01.2015, 18:45
Re: MySQL & PostgreSQL Plugin - by Anarkien - 28.01.2015, 17:30
Re: MySQL & PostgreSQL Plugin - by Blacklite - 08.05.2015, 09:46
AW: MySQL & PostgreSQL Plugin - by Akmet - 09.05.2015, 12:51
Re: MySQL & PostgreSQL Plugin - by Blacklite - 15.05.2015, 02:55
Re: MySQL & PostgreSQL Plugin - by Patrick - 03.08.2015, 10:21
Re: MySQL & PostgreSQL Plugin - by BlackBank - 03.08.2015, 17:03
Re: MySQL & PostgreSQL Plugin - by Djole1337 - 20.02.2017, 20:45
Re: MySQL & PostgreSQL Plugin - by Scriptery - 16.07.2017, 23:14
Re: MySQL & PostgreSQL Plugin - by Barnwell - 26.08.2017, 06:38

Forum Jump:


Users browsing this thread: 18 Guest(s)