Received: from server.amazonline.com.br (server.amazonline.com.br [200.242.255.1]) by hub.org (8.8.8/8.7.5) with ESMTP id BAA02325 for ; Fri, 15 May 1998 01:26:05 -0400 (EDT) Received: from zero (s113.amazon.com.br [200.242.245.81]) by server.amazonline.com.br (8.8.7/8.6.9) with SMTP id CAA11469 for ; Fri, 15 May 1998 02:23:38 -0300 Date: Fri, 15 May 1998 02:32:24 -0400 (WST) From: "Aldrin L." X-Sender: aldrin@zero To: pgsql-interfaces@postgresql.org Subject: mSQL Compatibility Library (fwd) Message-ID: MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; BOUNDARY="8323328-1195504642-895213428=:2538" Content-ID: This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. Send mail to mime@docserver.cac.washington.edu for more info. --8323328-1195504642-895213428=:2538 Content-Type: TEXT/PLAIN; CHARSET=US-ASCII Content-ID: Hello! :) (Sorry for my english. But if i wrote in portuguese, you wouldn't understand nothing. :]) I found it's the right place to post this. I'm a newcomer in these lists. I hope i did it right. :] When i started using SQL, i started with mSQL. I developed a lot of useful apps for me and my job with C, mainly because i loved it's elegant, simple api. But for a large project i'm doing in these days, i thought is was not enough, because it felt a lot of features i started to need, like security and subselects. (and it's not free :)) So after looking at the options, choose to start again with postgres. It offered everything that i needed, and the documentation is really good (remember me to thank the one who wrote'em). But for my little apps, i needed to start porting them to libpq. After looking at pq's syntax, i found it was better to write a bridge between the mSQL api and libpq. I found that rewriting the libmsql.a routines that calls libpq would made things much easier. I guess the results are quite good right now. Ok. Lets' summarize it: mpgsql.c is the bridge. Acting as a wrapper, it's really good, since i could run mSQL. But it's not accurate. Some highlights: CONS: * It's not well documented (this post is it's first documentation attempt, in fact); * It doesn't handle field types correctly. I plan to fix it, if people start doing feedbacks; * It's limited to 10 simultaneous connections. I plan to enhance this, i'm just figuring out; * I'd like to make it reentrant/thread safe, although i don't think this could be done without changing the API structure; * Error Management should be better. This is my first priority now; * Some calls are just empty implementations. PROS: * the mSQL Monitor runs Okay. :] * It's really cool. :) * Make mSQL-made applications compatible with postgresql just by changing link options. * Uses postgreSQL. :] * the mSQL API it's far easier to use and understand than libpq. Consider this example: #include "msql.h" void main(int argc, char **argv, char **envp) { int sid; sid = msqlConnect(NULL); /* Connects via unix socket */ if (sid >= 0) { m_result *rlt; m_row *row; msqlSelectDB(sid, "hosts"); if (msqlQuery(sid, "select host_id from hosts")) { rlt = msqlStoreResult(); while (row = (m_row*)msqlFetchRow(rlt)) printf("hostid: %s\n", row[0]); msqlFreeResult(rlt); } msqlClose(sid); } } I enclose mpgsql.c inside. I'd like to maintain it, and (maybe, am i dreaming) make it as part of the pgsql distribution. I guess it doesn't depends on me, but mainly on it's acceptance by its users. Hm... i forgot: you'll need a msql.h copy, since it's copyrighted by Hughes Technologies Pty Ltd. If you haven't it yes, fetch one from www.hughes.com.au. I would like to catch users ideas. My next goal is to add better error handling, and to make it better documented, and try to let relshow run through it. :) done. Aldrin Leal --8323328-1195504642-895213428=:2538 Content-Type: TEXT/PLAIN; NAME="mpgsql.c" Content-Transfer-Encoding: BASE64 Content-ID: Content-Description: mpgsql draft 0 I2luY2x1ZGUgPHRpbWUuaD4NCiNpbmNsdWRlIDxzdHJpbmcuaD4NCiNpbmNs dWRlIDxzdGRsaWIuaD4NCiNpbmNsdWRlICJtc3FsLmgiDQojaW5jbHVkZSAi bGlicHEtZmUuaCINCg0KI2RlZmluZSBITkRNQVggMTANCg0KUEdjb25uICpQ R2hbSE5ETUFYXSA9IHsNCiAgIE5VTEwsIE5VTEwsIE5VTEwsIE5VTEwsIE5V TEwsDQogICBOVUxMLCBOVUxMLCBOVUxMLCBOVUxMLCBOVUxMDQp9Ow0KDQoj ZGVmaW5lIEVfTk9IQU5ETEVSUyAwDQoNCmNoYXIgKm1zcWxFcnJvcnNbXSA9 IHsNCiAgICJPdXQgb2YgZGF0YWJhc2UgaGFuZGxlcnMuIg0KfTsNCg0KY2hh ciBtc3FsRXJyTXNnW0JVRlNJWl0sICp0ZnJvbSA9ICJkdW5ubyI7DQpQR3Jl c3VsdCAqcXVlcnlyZXMgPSBOVUxMOw0KDQppbnQgbXNxbENvbm5lY3QgKGNo YXIgKmhvc3QpIHsNCiAgIGludCBjb3VudDsNCiAgIA0KICAgZm9yIChjb3Vu dCA9IDA7IGNvdW50IDwgSE5ETUFYOyBjb3VudCsrKSANCiAgICAgIGlmIChQ R2hbY291bnRdID09IE5VTEwpIGJyZWFrOw0KICAgICAgDQogICBpZiAoY291 bnQgPT0gSE5ETUFYKSB7DQogICAgICBzdHJuY3B5KG1zcWxFcnJNc2csIG1z cWxFcnJvcnNbRV9OT0hBTkRMRVJTXSwgQlVGU0laKTsNCiAgICAgIHJldHVy biAtMTsNCiAgIH0NCg0KICAgUEdoW2NvdW50XSA9IG1hbGxvYyhzaXplb2Yg KFBHY29ubikpOw0KICAgUEdoW2NvdW50XS0+cGdob3N0ID0gaG9zdCA/IHN0 cmR1cChob3N0KSA6IE5VTEw7DQogICByZXR1cm4gY291bnQ7DQp9DQoNCmlu dCBtc3FsU2VsZWN0REIoaW50IGhhbmRsZSwgY2hhciAqZGJuYW1lKSB7DQog ICBjaGFyICpvcHRpb25zID0gY2FsbG9jKDEsIEJVRlNJWik7DQogICBjaGFy ICplID0gZ2V0ZW52KCJQR19PUFRJT05TIik7DQogICANCiAgIGlmIChlID09 IE5VTEwpIA0KICAgICAgZSA9ICIiOw0KICAgDQogICBpZiAoUEdoW2hhbmRs ZV0tPnBnaG9zdCkgew0KICAgICAgc3RyY2F0KG9wdGlvbnMsICJob3N0PSIp Ow0KICAgICAgc3RybmNhdChvcHRpb25zLCBQR2hbaGFuZGxlXS0+cGdob3N0 LCBCVUZTSVopOw0KICAgICAgc3RybmNhdChvcHRpb25zLCAiICIsIEJVRlNJ Wik7DQogICAgICBmcmVlKFBHaFtoYW5kbGVdLT5wZ2hvc3QpOw0KICAgICAg UEdoW2hhbmRsZV0tPnBnaG9zdCA9IE5VTEw7DQogICB9DQogICBzdHJuY2F0 KG9wdGlvbnMsICJkYm5hbWU9IiwgQlVGU0laKTsNCiAgIHN0cm5jYXQob3B0 aW9ucywgZGJuYW1lLCBCVUZTSVopOw0KICAgc3RybmNhdChvcHRpb25zLCAi ICIsIEJVRlNJWik7DQogICBzdHJuY2F0KG9wdGlvbnMsIGUsIEJVRlNJWik7 DQogICBmcmVlKFBHaFtoYW5kbGVdKTsNCiAgIFBHaFtoYW5kbGVdID0gUFFj b25uZWN0ZGIob3B0aW9ucyk7DQogICBmcmVlKG9wdGlvbnMpOw0KICAgc3Ry bmNweShtc3FsRXJyTXNnLCBQUWVycm9yTWVzc2FnZShQR2hbaGFuZGxlXSks IEJVRlNJWik7DQogICByZXR1cm4gKFBRc3RhdHVzKFBHaFtoYW5kbGVdKSA9 PSBDT05ORUNUSU9OX0JBRCA/IC0xIDogMCk7DQp9DQoNCmludCBtc3FsUXVl cnkoaW50IGhhbmRsZSwgY2hhciAqcXVlcnkpIHsNCiAgIGNoYXIgKnRxID0g c3RyZHVwKHF1ZXJ5KTsNCiAgIGNoYXIgKnAgPSB0cTsNCiAgIFBHcmVzdWx0 ICpyZXM7DQogICBQR2Nvbm4gKmNvbm4gPSBQR2hbaGFuZGxlXTsNCiAgIEV4 ZWNTdGF0dXNUeXBlIHJjb2RlOw0KICAgDQogICByZXMgPSBQUWV4ZWMoY29u biwgcCk7DQoNCiAgIHJjb2RlID0gUFFyZXN1bHRTdGF0dXMocmVzKTsNCiAg ICANCiAgIGlmIChyY29kZSA9PSBQR1JFU19UVVBMRVNfT0spIHsNCiAgICAg IHF1ZXJ5cmVzID0gcmVzOw0KICAgICAgcmV0dXJuIFBRbnR1cGxlcyhyZXMp Ow0KICAgfSBlbHNlIGlmIChyY29kZSA9PSBQR1JFU19GQVRBTF9FUlJPUiB8 fCByY29kZSA9PSBQR1JFU19OT05GQVRBTF9FUlJPUikgew0KICAgICAgUFFj bGVhcihyZXMpOw0KICAgICAgcXVlcnlyZXMgPSBOVUxMOw0KICAgICAgcmV0 dXJuIC0xOw0KICAgfSBlbHNlIHsNCiAgICAgIFBRY2xlYXIocmVzKTsNCiAg ICAgIHF1ZXJ5cmVzID0gTlVMTDsNCiAgICAgIHJldHVybiAwOw0KICAgfQ0K fQ0KDQppbnQgbXNxbENyZWF0ZURCIChpbnQgYSwgY2hhcipiKSB7DQogICBj aGFyIHRidWZbQlVGU0laXTsNCiAgIHNwcmludGYodGJ1ZiwgImNyZWF0ZSBk YXRhYmFzZSAlcyIsIGIpOw0KICAgcmV0dXJuIG1zcWxRdWVyeShhLCB0YnVm KSA+PSAwID8gMCA6IC0xOw0KfQ0KDQppbnQgbXNxbERyb3BEQiAoaW50IGEs IGNoYXIqIGIpIHsNCiAgIGNoYXIgdGJ1ZltCVUZTSVpdOw0KICAgc3ByaW50 Zih0YnVmLCAiZHJvcCBkYXRhYmFzZSAlcyIsIGIpOw0KICAgcmV0dXJuIG1z cWxRdWVyeShhLCB0YnVmKSA+PSAwID8gMCA6IC0xOw0KfQ0KDQppbnQgbXNx bFNodXRkb3duKGludCBhKSB7DQp9DQoNCmludCBtc3FsR2V0UHJvdG9JbmZv KHZvaWQpIHsNCn0NCg0KaW50IG1zcWxSZWxvYWRBY2xzKGludCBhKSB7DQp9 DQoNCmNoYXIgKm1zcWxHZXRTZXJ2ZXJJbmZvKHZvaWQpIHsNCn0NCg0KY2hh ciAqbXNxbEdldEhvc3RJbmZvKHZvaWQpIHsNCn0NCg0KY2hhciAqbXNxbFVu aXhUaW1lVG9EYXRlKHRpbWVfdCBkYXRlKSB7DQp9DQoNCmNoYXIgKm1zcWxV bml4VGltZVRvVGltZSh0aW1lX3QgdGltZSkgew0KfQ0KDQp2b2lkIG1zcWxD bG9zZShpbnQgYSkgew0KICAgIFBRZmluaXNoKFBHaFthXSk7DQogICAgUEdo W2FdID0gTlVMTDsNCiAgICBpZiAocXVlcnlyZXMpIHsNCiAgICAgICBmcmVl KHF1ZXJ5cmVzKTsNCiAgICAgICBxdWVyeXJlcyA9IE5VTEw7DQogICAgfQ0K fQ0KDQp2b2lkIG1zcWxEYXRhU2VlayhtX3Jlc3VsdCAqcmVzdWx0LCBpbnQg Y291bnQpIHsNCiAgIGludCBjOw0KICAgcmVzdWx0LT5jdXJzb3IgPSByZXN1 bHQtPnF1ZXJ5RGF0YTsNCiAgIGZvciAoYyA9IDE7IGMgPCBjb3VudDsgYysr KQ0KICAgICAgaWYgKHJlc3VsdC0+Y3Vyc29yLT5uZXh0KQ0KICAgICAgICAg cmVzdWx0LT5jdXJzb3IgPSByZXN1bHQtPmN1cnNvci0+bmV4dDsNCn0NCg0K dm9pZCBtc3FsRmllbGRTZWVrKG1fcmVzdWx0ICpyZXN1bHQsIGludCBjb3Vu dCkgew0KICAgaW50IGM7DQogICByZXN1bHQtPmZpZWxkQ3Vyc29yID0gcmVz dWx0LT5maWVsZERhdGE7DQogICBmb3IgKGMgPSAxOyBjIDwgY291bnQ7IGMr KykNCiAgICAgIGlmIChyZXN1bHQtPmZpZWxkQ3Vyc29yLT5uZXh0KQ0KICAg ICAgICAgcmVzdWx0LT5maWVsZEN1cnNvciA9IHJlc3VsdC0+ZmllbGRDdXJz b3ItPm5leHQ7DQp9DQoNCnZvaWQgbXNxbEZyZWVSZXN1bHQobV9yZXN1bHQg KnJlc3VsdCkgew0KICAgaWYgKHJlc3VsdCkgew0KICAgICAgLyogQ2xlYXJz IGZpZWxkcyAqLw0KICAgICAgZnJlZShyZXN1bHQtPmZpZWxkRGF0YSk7DQog ICAgICByZXN1bHQtPmN1cnNvciA9IHJlc3VsdC0+cXVlcnlEYXRhOw0KICAg ICAgd2hpbGUgKHJlc3VsdC0+Y3Vyc29yKSB7DQogICAgICAgICBpbnQgYzsN CiAgICAgICAgIG1fcm93IG0gPSByZXN1bHQtPmN1cnNvci0+ZGF0YTsNCiAg ICAgICAgIA0KICAgICAgICAgZm9yIChjID0gMDsgbVtjXTsgYysrKQ0KICAg ICAgICAgICAgZnJlZShtW2NdKTsNCg0KICAgICAgICAgcmVzdWx0LT5jdXJz b3IgPSByZXN1bHQtPmN1cnNvci0+bmV4dDsNCiAgICAgIH0gDQogICAgICBm cmVlKHJlc3VsdC0+cXVlcnlEYXRhKTsNCiAgICAgIGZyZWUocmVzdWx0KTsN CiAgIH0gIA0KfQ0KDQptX3JvdyBtc3FsRmV0Y2hSb3cobV9yZXN1bHQgKnJv dykgew0KICAgbV9kYXRhICpyID0gcm93LT5jdXJzb3I7DQogICBpZiAocikg ew0KICAgICAgcm93LT5jdXJzb3IgPSByb3ctPmN1cnNvci0+bmV4dDsNCiAg ICAgIHJldHVybiAobV9yb3cpci0+ZGF0YTsNCiAgIH0NCiAgIHJldHVybiAo bV9yb3cpTlVMTDsNCn0NCg0KbV9zZXEgKm1zcWxHZXRTZXF1ZW5jZUluZm8o aW50IGEsIGNoYXIgKmIpIHsNCn0NCg0KbV9maWVsZCAqbXNxbEZldGNoRmll bGQgKG1fcmVzdWx0ICptcikgew0KICAgbV9maWVsZCAqbSA9IChtX2ZpZWxk Kiltci0+ZmllbGRDdXJzb3I7DQogICBpZiAobSkgew0KICAgICAgbXItPmZp ZWxkQ3Vyc29yID0gbXItPmZpZWxkQ3Vyc29yLT5uZXh0Ow0KICAgICAgcmV0 dXJuIG07DQogICB9DQogICByZXR1cm4gTlVMTDsNCn0NCg0KbV9yZXN1bHQg Km1zcWxMaXN0REJzKGludCBhKSB7DQogICBtX3Jlc3VsdCAqbTsNCiAgIGlm IChtc3FsUXVlcnkoYSwgInNlbGVjdCBkYXRuYW1lIGZyb20gcGdfZGF0YWJh c2UiKSA+IDApIHsNCiAgICAgIG0gPSBtc3FsU3RvcmVSZXN1bHQoKTsNCiAg ICAgIHJldHVybiBtOw0KICAgfSBlbHNlIHJldHVybiBOVUxMOw0KfQ0KDQpt X3Jlc3VsdCAqbXNxbExpc3RUYWJsZXMoaW50IGEpIHsNCiAgIG1fcmVzdWx0 ICptOw0KICAgY2hhciB0YnVmW0JVRlNJWl07DQogICANCiAgIHNwcmludGYo dGJ1ZiwgInNlbGVjdCByZWxuYW1lIGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVs a2luZD0ncicgYW5kIHJlbG93bmVyPSVkIiwgZ2V0dWlkKCkpOw0KICAgaWYg KG1zcWxRdWVyeShhLCB0YnVmKSA+IDApIHsNCiAgICAgIG0gPSBtc3FsU3Rv cmVSZXN1bHQoKTsNCiAgICAgIHJldHVybiBtOw0KICAgfSBlbHNlIHJldHVy biBOVUxMOw0KfQ0KDQptX3Jlc3VsdCAqbXNxbExpc3RGaWVsZHMoaW50IGEs IGNoYXIgKmIpIHsNCiAgIA0KfQ0KDQptX3Jlc3VsdCAqbXNxbExpc3RJbmRl eChpbnQgYSwgY2hhciAqYiwgY2hhciAqYykgew0KICAgbV9yZXN1bHQgKm07 DQogICBjaGFyIHRidWZbQlVGU0laXTsNCiAgIA0KICAgc3ByaW50Zih0YnVm LCAic2VsZWN0IHJlbG5hbWUgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxraW5k PSdpJyBhbmQgcmVsb3duZXI9JWQiLCBnZXR1aWQoKSk7DQogICBpZiAobXNx bFF1ZXJ5KGEsIHRidWYpID4gMCkgew0KICAgICAgbSA9IG1zcWxTdG9yZVJl c3VsdCgpOw0KICAgICAgcmV0dXJuIG07DQogICB9IGVsc2UgcmV0dXJuIE5V TEw7DQp9DQoNCm1fcmVzdWx0ICptc3FsU3RvcmVSZXN1bHQodm9pZCkgew0K ICAgaWYgKHF1ZXJ5cmVzKSB7DQogICAgICBtX3Jlc3VsdCAqbXIgPSBtYWxs b2Moc2l6ZW9mKG1fcmVzdWx0KSk7DQogICAgICBtX2ZkYXRhICptZjsNCiAg ICAgIG1fZGF0YSAqbWQ7DQogICAgICBpbnQgY291bnQ7DQogICAgICBtci0+ cXVlcnlEYXRhID0gbXItPmN1cnNvciA9IE5VTEw7DQogICAgICBtci0+bnVt Um93cyA9IFBRbnR1cGxlcyhxdWVyeXJlcyk7ICANCiAgICAgIG1yLT5udW1G aWVsZHMgPSBQUW5maWVsZHMocXVlcnlyZXMpOw0KICAgICAgDQogICAgICBt ZiA9IGNhbGxvYyhQUW5maWVsZHMocXVlcnlyZXMpLCBzaXplb2YobV9mZGF0 YSkpOyAgICAgIA0KICAgICAgZm9yIChjb3VudCA9IDA7IGNvdW50IDwgUFFu ZmllbGRzKHF1ZXJ5cmVzKTsgY291bnQrKykgew0KICAgICAgICAgKG1fZmRh dGEqKShtZitjb3VudCktPmZpZWxkLm5hbWUgPSBzdHJkdXAoUFFmbmFtZShx dWVyeXJlcywgY291bnQpKTsgDQogICAgICAgICAobV9mZGF0YSopKG1mK2Nv dW50KS0+ZmllbGQudGFibGUgPSB0ZnJvbTsgDQogICAgICAgICAobV9mZGF0 YSopKG1mK2NvdW50KS0+ZmllbGQudHlwZSA9IENIQVJfVFlQRTsNCiAgICAg ICAgIChtX2ZkYXRhKikobWYrY291bnQpLT5maWVsZC5sZW5ndGggPSBQUWZz aXplKHF1ZXJ5cmVzLCBjb3VudCk7DQogICAgICAgICAobV9mZGF0YSopKG1m K2NvdW50KS0+bmV4dCA9IChtX2ZkYXRhKikobWYrY291bnQrMSk7DQogICAg ICB9DQogICAgICAobV9mZGF0YSopKG1mK2NvdW50LTEpLT5uZXh0ID0gTlVM TDsNCiAgICAgIA0KICAgICAgbWQgPSBjYWxsb2MoUFFudHVwbGVzKHF1ZXJ5 cmVzKSwgc2l6ZW9mKG1fZGF0YSkpOw0KICAgICAgZm9yIChjb3VudCA9IDA7 IGNvdW50IDwgUFFudHVwbGVzKHF1ZXJ5cmVzKTsgY291bnQrKykgew0KICAg ICAgICAgbV9yb3cgcm93cyA9IGNhbGxvYyhQUW5maWVsZHMocXVlcnlyZXMp KnNpemVvZihtX3JvdykrMSwgMSk7DQogICAgICAgICBpbnQgYzsNCiAgICAg ICAgIA0KICAgICAgICAgZm9yIChjID0gMDsgYyA8IFBRbmZpZWxkcyhxdWVy eXJlcyk7IGMrKykgew0KICAgICAgICAgICAgcm93c1tjXSA9IHN0cmR1cChQ UWdldHZhbHVlKHF1ZXJ5cmVzLCBjb3VudCwgYykpOw0KICAgICAgICAgfQ0K ICAgICAgICAgKG1fZGF0YSopKG1kK2NvdW50KS0+ZGF0YSA9IHJvd3M7DQog ICAgICAgICANCiAgICAgICAgIChtX2RhdGEqKShtZCtjb3VudCktPndpZHRo ID0gUFFuZmllbGRzKHF1ZXJ5cmVzKTsNCiAgICAgICAgIChtX2RhdGEqKSht ZCtjb3VudCktPm5leHQgPSAobV9kYXRhKikobWQrY291bnQrMSk7DQogICAg ICB9DQogICAgICAobV9kYXRhKikobWQrY291bnQtMSktPm5leHQgPSBOVUxM Ow0KICAgICAgDQogICAgICBtci0+cXVlcnlEYXRhID0gbXItPmN1cnNvciA9 IG1kOw0KICAgICAgbXItPmZpZWxkQ3Vyc29yID0gbXItPmZpZWxkRGF0YSA9 IG1mOw0KDQogICAgICByZXR1cm4gbXI7DQogICB9IGVsc2UgcmV0dXJuIE5V TEw7DQp9DQoNCnRpbWVfdCBtc3FsRGF0ZVRvVW5peFRpbWUoY2hhciAqYSkg ew0KfQ0KDQp0aW1lX3QgbXNxbFRpbWVUb1VuaXhUaW1lKGNoYXIgKmIpIHsN Cn0NCg0KY2hhciAqbXNxbF90bXBuYW0odm9pZCkgew0KICAgcmV0dXJuIHRt cG5hbSgiL3RtcC9tc3FsLlhYWFhYWCIpOw0KfQ0KDQppbnQgbXNxbExvYWRD b25maWdGaWxlKGNoYXIgKmEpIHsNCn0NCg0K --8323328-1195504642-895213428=:2538--