- libzdb-general - tildeslash.com

[Announce] libzdb 3.5.0
by Jan-Henrik Haukeland 17 Dec '25

17 Dec '25

Version 3.5.0 of libzdb is available: Download: https://www.tildeslash.com/libzdb/dist/libzdb-3.5.0.tar.gz SHA256 checksum: 90c79bf23b0c8fcb6543634844d17c094a24a360c9d63ddf6efc3741ebec32c5 Please see the release notes at https://tildeslash.com/libzdb/#release_notes Notably, this release introduces Exception_frame.errorCode, which provides the numeric error code from the underlying database when available. This allows for more robust error handling. Thanks to Till for suggesting this feature. Example: TRY Connection_execute(c, sql); ELSE if (Exception_frame.errorCode == ER_LOCK_DEADLOCK) { // MySQL error code 1213 // Handle deadlock - consider retry } else { printf("Database error (%d): %s\n", Exception_frame.errorCode, Exception_frame.message); } END_TRY; Exception.h has been updated with detailed information on how to use the new errorCode for all databases. See https://tildeslash.com/libzdb/api-docs/Exception_8h.html

1 0

انضم لحساب Canva Pro مجانًا الآن
by jib l3azz 02 Oct '25

02 Oct '25

انضم الآن إلى حساب Canva Pro مجانًا عبر رابط الدعوة المخصص للمعلمين والطلاب في 2025، واستفد من جميع المزايا المدفوعة دون أي تكلفة. في هذا المقال نوضح لك كيفية الحصول على دعوة مجانية لحساب Canva Pro Edu، وما الذي يميزه عن الحسابات الأخرى، والخطوات العملية للتسجيل. https://www.targir.com/2025/02/canva-pro.html ما هو Canva Pro؟ Canva منصة تصميم مشهورة عالميًا تتيح إنشاء عروض تقديمية، ملصقات، منشورات اجتماعية، فيديوهات وغير ذلك بسهولة. الحساب المجاني يوفر أدوات وقوالب محدودة، بينما يقدم Canva Pro مكتبة ضخمة من الصور والفيديوهات، أدوات احترافية مثل إزالة الخلفية، وتخزين سحابي بسعة كبيرة. أنواع الحسابات الحساب المجاني: يتيح الوصول لآلاف القوالب وصور ورسومات محدودة، مع 5 جيجا تخزين. مناسب للمبتدئين. Canva Pro: مدفوع يوفر أكثر من 100 مليون صورة، قوالب متميزة، 1 تيرابايت تخزين، وأدوات مثل تغيير مقاسات التصميم. Canva Teams: مصمم للمؤسسات، مع مزايا تعاون فوري وتخصيص العلامة التجارية. Canva Pro Edu: مجاني للمعلمين والطلاب، يحتوي على جميع ميزات Canva Pro بالإضافة إلى أدوات تعليمية. كيف تحصل على Canva Pro Edu مجانًا؟ – التسجيل عبر رابط دعوة رسمي خاص بالتعليم. – إنشاء حساب جديد أو استخدام بريدك التعليمي إن توفر. – بعد قبول الدعوة، يتحول حسابك تلقائيًا إلى Canva Pro Edu مجاني بكامل المزايا. ماذا تحتاج للتسجيل؟ – أن تكون معلمًا أو طالبًا بمؤسسة تعليمية. – بريد إلكتروني مرتبط بالتعليم (مثل edu). – الانضمام عبر رابط دعوة نشط. هل يمكن الحصول على Canva Pro بطرق أخرى؟ نعم، هناك نسخة تجريبية مجانية لمدة 30 يومًا متاحة للجميع عبر الموقع الرسمي. خلال هذه الفترة تستمتع بجميع المزايا، ويمكنك إلغاء الاشتراك قبل انتهائها لتجنب الرسوم. أما الحصول على Canva Pro شخصي دائمًا بشكل مجاني فغير ممكن إلا عبر الدعوة التعليمية. أهم المزايا التي يقدمها Canva Pro Edu مجانًا – مكتبة تضم أكثر من 100 مليون صورة ورسوم وفيديوهات. – أكثر من 600 ألف قالب احترافي. – أدوات متقدمة مثل إزالة الخلفية وتغيير مقاسات التصاميم. – تخزين سحابي 1 تيرابايت. – إمكانية العمل الجماعي مع الطلاب والزملاء على مشاريع مشتركة. لماذا تختار Canva Pro Edu؟ هذا الحساب يمنحك جميع أدوات Canva Pro دون تكلفة، وهو مثالي للمدرسين لإعداد دروس تفاعلية، وللطلاب لإنشاء مشاريع وعروض احترافية. يساعدك على رفع جودة أعمالك ويوفر موارد ضخمة جاهزة للاستخدام. خاتمة إذا كنت طالبًا أو معلمًا، فإن أفضل طريقة للحصول على Canva Pro مجانًا هي عبر رابط الدعوة إلى Canva Pro Edu. بهذه الخطوة ستفتح لك جميع الأدوات المميزة دون أي رسوم. سجّل الآن واستفد من فرصة مذهلة تتيح لك تطوير تصاميمك التعليمية والشخصية، والوصول إلى مستوى احترافي باستخدام Canva Pro Edu في 2025.

1 0

شهادة الأبوة في المغرب
by jib l3azz 02 Oct '25

02 Oct '25

كل ما تحتاج معرفته حول شهادة الأبوة بالمغرب يمكنك تحميل الطلب من خلال الرابط المباشر https://www.targir.com/2025/04/blog-post_14.html معلومات شاملة لاستخراج شهادة الأبوة والإجراءات القانونية المرتبطة بها ما هي شهادة الأبوة في المغرب؟ شهادة الأبوة وثيقة قانونية تصدر بناءً على حكم قضائي، وتُثبت العلاقة البنوية بين الطفل ووالده البيولوجي، في حال عدم وجود عقد زواج رسمي أو تسجيل سابق. تُعَد هذه الشهادة جزءًا من الإجراءات القضائية التي تدخل ضمن قضايا الحالة المدنية. الحالات التي تستوجب استخراج شهادة الأبوة 1. الأطفال غير المسجلين في الحالة المدنية عندما يولد طفل خارج إطار الزواج أو لم يُسجَّل بصفة قانونية في دفتر الحالة المدنية، يحتاج الأب إلى رفع دعوى للحصول على شهادة الأبوة. 2. إثبات النسب في غياب عقد زواج في حالات عدم توفر وثيقة الزواج بين الأبوين، يُلجأ إلى المحكمة لتقديم التصريح بالأبوة. إجراءات الحصول على شهادة الأبوة أولا: رفع دعوى أمام المحكمة يتوجب على الأب أو ولي أمر الطفل تقديم طلب إلى المحكمة الابتدائية التي يقع فيها مقر سكن الطفل أو الأب، وذلك من أجل إصدار حكم قضائي بإثبات الأبوة. ثانياً: الوثائق المطلوبة نسخة من بطاقة التعريف الوطنية عقد الازدياد الخاص بالطفل (إن وُجد) شهادة طبية للولادة شهادة السكنى وثائق أو إثباتات تدعم علاقة الأب بالطفل نموذج شهادة الأبوة pdf تتيح بعض المواقع الإلكترونية تحميل نموذج شهادة الأبوة PDF قابل للطباعة، غير أن إصدارها الرسمي لا يتم إلا بعد حكم قضائي، ويتم توجيهها لمصلحة الحالة المدنية لتسجيل الطفل. الأسئلة الشائعة حول شهادة الأبوة هل يمكن تقديم طلب شهادة الأبوة إلكترونياً؟ لا، المسطرة تظل قضائية وتتطلب الحضور أمام المحكمة. ما هي مدة الحصول على شهادة الأبوة؟ قد تختلف المدة حسب عدد الجلسات، ولكن عادة ما تستغرق بين شهر إلى ثلاثة أشهر، حسب تعقيد الملف. صلة بين شهادة الأبوة وبعض التصاريح القانونية الأخرى تم الربط ضمن هذا الدليل بين شهادة الأبوة وبعض المفاهيم القانونية الأخرى التي يبحث عنها الكثير، مثل: 1. التصريح الأمني وتصريح السفر غالباً ما يُطلب في بعض الحالات القانونية توفير تصريح أمني عند استخراج أوراق ثبوتية، كما هو الحال في: الأوراق المطلوبة لاستخراج تصريح السفر من منطقة التجنيد تصريح أمني مستعجل التصريح الأمني الإلكتروني 2. استبدال التصريح برخصة قيادة في حالات مثل شروط إصدار رخصة قيادة بعد التصريح أو تجديد التصريح إلى رخصة، من المهم التأكد من إثبات الهوية القانونية، وهو ما يجعل شهادة الأبوة ضرورية في بعض الحالات القانونية الخاصة. شهادة الأبوة الغاية من هذه الوثيقة هي إثبات علاقة الأبوة بالابن سواء كان راشدا أم قاصرا وغالبا ما تطلب في بعض المساطر الإدارية. صاحب الطلب المغربي المقيم بالخارج الوثائق المطلوبة بالنسبة للراشد : · بطاقة التسجيل ؛ · الدفتر العائلي بالنسبة للقاصر : · بطاقة تسجيل الأب ؛ · الدفتر العائلي . المصلحة المكلفة باستلام الوثائق المطلوبة المصالح القنصلية التابعة لمحل إقامة صاحب الطلب المصلحة المكلفة بتقديم الخدمة المصالح القنصلية التابعة لمحل إقامة صاحب الطلب في حالة تعذر الحصول على الخدمة مؤسسة الوسيط لأجل الاتصال وزارة الشؤون الخارجية والتعاون مصدر المعلومات (الإدارة المعنية) وزارة الشؤون الخارجية والتعاون_أرشيف يمكنك تحميل الطلب من خلال الرابط المباشر نموذج شهادة الأبوة بالمغرب محكمة الأسرة بـ: [اسم المدينة] رقم الملف: [يُترك للمحكمة] رقم القضية: [يُترك للمحكمة] بيان تصريح بالأبوة أنا الموقع أسفله: الاسم الكامل: [الاسم الكامل للأب] رقم بطاقة التعريف الوطنية: [رقم CIN] تاريخ ومكان الازدياد: [تاريخ ومكان ولادة الأب] العنوان الكامل: [عنوان الإقامة] المهنة: [المهنة الحالية] أُصرّح بموجب هذا، وبكامل قواي العقلية والقانونية، بما يلي: أن الطفل (ة) المسمى (ة): [اسم الطفل/ة] المولود (ة) بتاريخ: [تاريخ الولادة] بـ: [مكان الولادة] هو(هي) ابني/ابنتي البيولوجي(ة)، وقد وُلد(ت) نتيجة علاقة أبوية قائمة بيني وبين السيدة: [اسم الأم]، المولودة بتاريخ: [تاريخ ميلاد الأم]، والحاملة لرقم بطاقة التعريف الوطنية: [رقم CIN الأم]. وأتحمل كامل المسؤولية القانونية والأبوية تجاه هذا الطفل/ة، وأطلب من المحكمة الموقرة إصدار حكم قضائي يثبت نسب الطفل لي، وتمكينه من التسجيل في الحالة المدنية. الإمضاء الإسم الكامل: _____________________ التوقيع: ___________________________ التاريخ: ____ / ____ / ________ ملاحظات : يُرفق هذا النموذج بالوثائق الداعمة كـ: نسخة البطاقة الوطنية، شهادة السكنى، شهادة الولادة، وغيرها. يُودَع لدى كتابة ضبط المحكمة الابتدائية (قسم قضاء الأسرة) التي يقع ضمن اختصاصها محل ولادة الطفل أو محل سكن الأب.

1 0

شهادة الأبوة في المغرب
by jibl3azzmenusa＠gmail.com 02 Oct '25

02 Oct '25

شهادة الأبوة في المغرب

1 0

Feature Request: Exception_frame.err
by g4-lisz＠tonarchiv.ch 24 Jul '25

24 Jul '25

Hi there, In some situations it would come in handy if there was also a numeric error code from the DB layer. What I mean is an additional property of Exception_frame like .err, .errno or alike, which receives the numeric error code from the driver API in case of an exception. For example a in my code I'm using: // If there are many asynchronous inserts, we might hit a deadlock if (retries < 2 && strncmp(Exception_frame.message, "Deadlock found when trying to get lock; try restarting transaction", 67) == 0) { retries++; _usleep(100000); goto redo; } This is kind of ugly... It would be better to do something like if (retries < 2 && Exception_frame.errno == ER_LOCK_DEADLOCK) { ... } Cheers, Till

2 2

Register Abort Handler
by g4-lisz＠tonarchiv.ch 28 Jun '25

28 Jun '25

Hi there I want to avoid that my application gets terminated on uncaught exceptions. I couldn't find any documentation about how to set the abort handler. So it seems that I'm doing this wrong: In my main C file: #include ... #include <zdb.h> void(*AbortHandler)(const char *error); void myhandler(const char *error) { fprintf(stdout, "...%sn", error); } main () { AbortHandler = myhandler; } But the handler is not used and the program ends: SQLException: mysql_stmt_fetch -- Incorrect number of arguments for FUNCTION cpr_db.consolidate_occupancy; expected 2, got 1 raised in _next at src/db/mysql/MysqlResultSet.c:209 What's the correct way to set the external AbortHandler in main()? Cheers Till

2 2

Libzdb not working with ProxySQL
by g4-lisz＠tonarchiv.ch 24 Jun '25

24 Jun '25

Hi there, I wrote an application using libzdb, which works fine when I connect directly to a MySQL server. But when I connect to ProxySQL I get this error when doing a Connection_executeQuery(): SQLException: Commands out of sync; you can't run this command now raised in Connection_executeQuery at src/db/Connection.c:335 It's a very basic select: "SELECT * FROM instance". When I do the same with libmysql (acutally it's libmariadb), there's no issue. This is the test code: #include <stdio.h> #include <zdb.h> main() { URL_T url = URL_new("mysql://sbuser:sbpass@127.0.0.1:6033/cpr_db"); ConnectionPool_T pool = ConnectionPool_new(url); ConnectionPool_start(pool); Connection_T con = ConnectionPool_getConnection(pool); ResultSet_T result = Connection_executeQuery(con, "SELECT * FROM instance"); while (ResultSet_next(result)) { int id = ResultSet_getInt(result, 1); printf("%dn", id); } Connection_close(con); ConnectionPool_free(&pool); URL_free(&url); } Any idea what is the issue here? Cheers Till

2 4

Question about Exceptions
by g4-lisz＠tonarchiv.ch 24 Jun '25

24 Jun '25

Hi there, To me it's a bit unclear in which case I should use Connection_getLastError(). And, when using Exception_frame.message, if it makes sense to catch a specific exception. What I mean is: TRY { Connection_executeQuery(...); } CATCH (SQLException) { printf("SQLException -- %sn", Connection_getLastError(c)); } versus TRY { Connection_executeQuery(...); } CATCH (SQLException) { printf("SQLException -- %sn", Exception_frame.message); } versus TRY { Connection_executeQuery(...); } ELSE { printf("Exception -- %sn", Exception_frame.message); } Ok, I understand that ELSE { } will catch every exception, so I can't safely use Connection_getLastError() there. But with CATCH(SQLException), is there a situation where Connection_getLastError() is preferred over Exception_frame.message? Cheers, Till

2 2

Feature Request: ResultSet_isnullByName
by g4-lisz＠tonarchiv.ch 06 Jun '25

06 Jun '25

Hello everyone! This is my first post to this list... I just started using libzdb. It's exactly what I was looking for. I realized that I have to use ResultSet_isnull() to differentiate between NULL and 0 on integers... I started to use the ...ByName functions because it makes my code more readable and also more robust. Now I was wondering why there's no ResultSet_isnullByName() function. Maybe there's a good reason for it? I just added the missing code and I can't see any issue with using it... Cheers Till

2 5

[Announce] libzdb 3.4.1
by Jan-Henrik Haukeland 03 Jun '25

03 Jun '25

Version 3.4.1 of libzdb is available: Download: https://www.tildeslash.com/libzdb/dist/libzdb-3.4.1.tar.gz SHA256 checksum: 5b4633fc2a16880f776197f4045f62ef8db5062f63030fa221011d4b85d736cb Please see the release notes at https://tildeslash.com/libzdb/#release_notes Notably, this version reintroduces shared cache support for SQLite. To enable this, set the ‘shared-cache=true’ parameter in the SQLite connection URL. Although shared cache has been deprecated by SQLite, it remains crucial in multi-threaded scenarios where each thread establishes a connection and writes to the database. By combining shared cache support with the SQLite unlock notify API, we observe a significant reduction in database lock errors and improved concurrency.

1 0

[Announce] libzdb 3.4.0
by Jan-Henrik Haukeland 01 Aug '24

01 Aug '24

Version 3.4.0 of libzdb is available: Download: https://www.tildeslash.com/libzdb/dist/libzdb-3.4.0.tar.gz SHA256 checksum: abd675719bcbdde430aa4ee13975b980d55d2abcb5cc228082a30320a6bb9f0f Please see the full release notes at https://tildeslash.com/libzdb/#release_notes Hot on the heels of the previous release, here's a new one. I wanted this out to complement the previous release. Of note in this release are: • Support for specifying the transaction isolation level using Connection_beginTransactionType(). Or Connection::beginTransaction in C++. • Activation of multi-thread mode with SQLite, which should be very useful and improve concurrency for multi-threaded applications. Also, some clean up and removal of support for the deprecated shared cache mode. Add serialized=true to the URL if you instead want to use SQLite in serialized mode. SQLite has a page describing threading modes in more detail, https://www.sqlite.org/threadsafe.html • Plus some C++ fixes. • Finally, we introduce a useful little macro, 'valueOr', inspired by C++'s std::optional's value_or() function. This macro is defined in zdb.h and can be used with pointer and numeric types to set a default value if a function or expression returns NULL, 0, or a negative value. It should be quite useful with e.g. ResultSet. Example: const char* host = valueOr(ResultSet_getStringByName(r, "host"), "localhost”);

1 0

[Announce] libzdb 3.3.0
by Jan-Henrik Haukeland 23 Jul '24

23 Jul '24

Version 3.3.0 of libzdb is now available: Download: https://www.tildeslash.com/libzdb/dist/libzdb-3.2.3.tar.gz SHA256 checksum: b1f979f48f4c52f71821f4b2983ef26cf08fc58337effe5651155cfaa96ce95d Please see the release notes at https://tildeslash.com/libzdb/#release_notes The Connection Pool has a better locking strategy and should be much more responsive when multiple threads request connections simultaneously.

1 0

[Announce] libzdb 3.2.3
by Jan-Henrik Haukeland 18 Oct '22

18 Oct '22

Version 3.2.3 of libzdb is now available: Download: https://tildeslash.com/libzdb/dist/libzdb-3.2.3.tar.gz MD5 checksum: bbde5515b5d2508b80cf18c03c8c6a82 Please see the release notes at https://tildeslash.com/libzdb/#release_notes

1 0

Re: SWIG support
by Liviu ANDRON 19 Jul '22

19 Jul '22

Hello, Both PreparedStatement::setString and PreparedStatement::setBlob require > the parameter value to be passed by reference. The reason, especially for > setBlob, is that the size might be in many megabytes and we want to avoid > copy to be faster. Client code need to have a reference to the buffer in > any case and holding on to it until calling PreparedStatement.execute seems > reasonable. Hopefully this might be possible to do in the SWIG code also? I understand that for an PreparedStatement object the arguments must be kept until execute, but for setString has to convert the string into a temporary variable that will be destroyed after the call. I am not aware of a possibility to take ownership of that object. There's a define, SWIG_PYTHON_STRICT_BYTE_CHAR, but that means that all strings have to be transferred now as bytes (b"mysql://localhost:3306/test?user=root&password=root" instead of just "mysql://localhost:3306/test?user=root&password=root") which is confusing for new code and not easily compatible with old code. Knowing that in Python it is easier to assembly strings, I preferred, for the moment, to "remove" PreparedStatement: %ignore PreparedStatement; and use Connection::execute / Connection::executeQyery (the simple versions ...) I though that almost all scripting languages and higher level languages > already have a plethora of Database Connection and ORM offerings. I > appreciate that you want to bring libzdb to Python, but suspect it will be > fringe there. I?m not sure we will be able to maintain a SWIG > implementation as we don?t use and we don?t know anything about SWIG. > Now that you say it, I see them :)): https://docs.sqlalchemy.org/en/14/core/pooling.html. But I don't think I can dump all the work already done and put all my hope in something else. I took over some first try of SQL connection pooling using an already altered libzdb version, with Python wrappers around. This seems like a nightmare for maintenance. I prefer SWIG and some light changes in libzdb. Good joke and speed might be the answer of my boss in libzdb vs sqlalchemy (although it shouldn't matter for the needed work) Thank you, Liviu On Mon, Jul 18, 2022 at 7:19 PM <libzdb-general-request(a)tildeslash.com> wrote: > Send libzdb-general mailing list submissions to > libzdb-general(a)tildeslash.com > > To subscribe or unsubscribe via the World Wide Web, visit > http://www.tildeslash.com/mailman/listinfo/libzdb-general > or, via email, send a message with subject or body 'help' to > libzdb-general-request(a)tildeslash.com > > You can reach the person managing the list at > libzdb-general-owner(a)tildeslash.com > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of libzdb-general digest..." > > > Today's Topics: > > 1. Re: SWIG support (Jan-Henrik Haukeland) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 18 Jul 2022 19:19:18 +0200 > From: Jan-Henrik Haukeland <hauk(a)tildeslash.com> > To: This is the libzdb general mailing list > <libzdb-general(a)tildeslash.com> > Subject: Re: SWIG support > Message-ID: <CE8F59E5-9D72-436C-8AC0-983E261ADCB9(a)tildeslash.com> > Content-Type: text/plain; charset="utf-8" > > > > > On 18 Jul 2022, at 11:11, Liviu Andron <liviu.andron(a)bjtmail.com> wrote: > > > > Hello, > > > > I needed Python 3 support so I started working with SWIG, by making an i > file around zdbpp.h. Unfortunately, some changes are needed and some > interfaces seem hard to support. PreparedStatement::setString is > particularly hard as SWIG temporarily converts the Python's Unicode string > to UTF8, so the PreparedStatement object should copy the resulting string > instead of just keeping it. By example, in MySQL, _setString from > MysqlPreparedStatement.c keeps the pointer: P->bind[i].buffer = (char*)x; . > That pointer won't be valid when the execute() is finally called. > > Both PreparedStatement::setString and PreparedStatement::setBlob require > the parameter value to be passed by reference. The reason, especially for > setBlob, is that the size might be in many megabytes and we want to avoid > copy to be faster. Client code need to have a reference to the buffer in > any case and holding on to it until calling PreparedStatement.execute seems > reasonable. Hopefully this might be possible to do in the SWIG code also? > > > Is SWIG support something interesting for you? By no means I am not a > SWIG expert, but could I propagate these changes in a separate branch or > something ? How can I avoid starting just another lonely private fork ? > > I though that almost all scripting languages and higher level languages > already have a plethora of Database Connection and ORM offerings. I > appreciate that you want to bring libzdb to Python, but suspect it will be > fringe there. I?m not sure we will be able to maintain a SWIG > implementation as we don?t use and we don?t know anything about SWIG. > > As a side-note, just saw this on reddit today:-) > > > > > > I appreciate this project for its code rigor and up-to-date maintenance. > > Thank you! > > >

1 0

SWIG support
by Liviu Andron 18 Jul '22

18 Jul '22

Hello, I needed Python 3 support so I started working with SWIG, by making an i file around zdbpp.h. Unfortunately, some changes are needed and some interfaces seem hard to support. PreparedStatement::setString is particularly hard as SWIG temporarily converts the Python's Unicode string to UTF8, so the PreparedStatement object should copy the resulting string instead of just keeping it. By example, in MySQL, _setString from MysqlPreparedStatement.c keeps the pointer: P->bind[i].buffer = (char*)x; . That pointer won't be valid when the execute() is finally called. Is SWIG support something interesting for you? By no means I am not a SWIG expert, but could I propagate these changes in a separate branch or something ? How can I avoid starting just another lonely private fork ? I appreciate this project for its code rigor and up-to-date maintenance. Thank you, Liviu

2 1

Read-Only Transaction
by nBeta Github 23 Nov '20

23 Nov '20

Dear libzdb maintainers, There is possibility to start read-only transactions? If not there are plans to support such a feature? I have seen in the source code that it will be fairly simple to add, I can take it over my self such an endeavor but I need to know it is in the best interest and conforms with your own rules and future development. Thanks, Cosmin Cioranu

1 0

install problem
by 颜培震 13 Jul '20

13 Jul '20

Dear, I install the libzdb,but failed err msg is "in function _Atomic expected declaration specifiers before 'KstatementID' ". if I want install the version 3.3.3 ,which gcc version is better ?could you help me ? thanks ! C++ install dir

2 1

How to get MYSQL_RES in libzdb
by 范学冬 27 May '20

27 May '20

Hi guys, I‘m trying to rewrite my project with Libzdb, however, my origin project was used to MYSQL official style, now I’m facing problem with the result of mysql. If I want to get MYSQL_RES in Libzdb, what should I do?

1 0

[Announce] libzdb 3.2.2
by Jan-Henrik Haukeland 31 Mar '20

31 Mar '20

Version 3.2.2 of libzdb is now available: Download: https://tildeslash.com/libzdb/dist/libzdb-3.2.2.tar.gz MD5 checksum: ca533f8f5b649d758e1bbb53a11e414e Please see the release notes at https://tildeslash.com/libzdb/#release_notes

1 0

[Announce] libzdb 3.2.1
by Jan-Henrik Haukeland 06 Mar '20

06 Mar '20

Version 3.2.1 of libzdb is now available: Download: https://tildeslash.com/libzdb/dist/libzdb-3.2.1.tar.gz MD5 checksum: 6962274d9cead88c2322a5687485d9b9 Please see the release notes at https://tildeslash.com/libzdb/#release_notes

1 0

Compile issue on opensuse 15.1
by Admin Beckspaced 19 Feb '20

19 Feb '20

Dear libzdb users ;) trying to compile libzdb 3.2 on an opensuse 15.1 box via ./configure --prefix=/usr --libdir=/usr/lib64 --without-postgresql --without-sqlite make then throws an error, see below ... how can I fix this? thanks & greetings Becki cx20:~/software/libzdb/libzdb-3.2 # make make all-recursive make[1]: Entering directory '/root/software/libzdb/libzdb-3.2' Making all in . make[2]: Entering directory '/root/software/libzdb/libzdb-3.2' make[2]: Nothing to be done for 'all-am'. make[2]: Leaving directory '/root/software/libzdb/libzdb-3.2' Making all in test make[2]: Entering directory '/root/software/libzdb/libzdb-3.2/test' g++ -DHAVE_CONFIG_H -I/usr/include/mysql -I/usr/include/mysql/mariadb -I../zdb -std=c++17 -g -O2 -c -o zdbpp-zdbpp.o `test -f 'zdbpp.cpp' || echo './'`zdbpp.cpp zdbpp.cpp: In function ‘void testQuery(zdb::ConnectionPool&)’: zdbpp.cpp:60:9: error: ‘assert’ was not declared in this scope assert(result.columnCount() == 4); ^~~~~~ zdbpp.cpp:60:9: note: suggested alternative: ‘qsort’ assert(result.columnCount() == 4); ^~~~~~ qsort make[2]: *** [Makefile:445: zdbpp-zdbpp.o] Error 1 make[2]: Leaving directory '/root/software/libzdb/libzdb-3.2/test' make[1]: *** [Makefile:758: all-recursive] Error 1 make[1]: Leaving directory '/root/software/libzdb/libzdb-3.2' make: *** [Makefile:503: all] Error 2

2 2

[Announce] libzdb 3.2
by Jan-Henrik Haukeland 04 Apr '19

04 Apr '19

Version 3.2 of libzdb is now available: Download: https://tildeslash.com/libzdb/dist/libzdb-3.2.tar.gz MD5 checksum: 12bf0460bf5aa9102b4b3b18f5874143 Please see the release notes at https://tildeslash.com/libzdb/#release_notes

1 0

Help with testing new version
by Jan-Henrik Haukeland 01 Apr '19

01 Apr '19

Hi If you use libzdb, I would very much appreciate if you could take 5 min and checkout the new version from master here https://bitbucket.org/tildeslash/libzdb/overview and give it a try and report back any problems you might find. The change log is here https://bitbucket.org/tildeslash/libzdb/src/a3c9fe3329707067f71cfaab6378735… Best regards

1 0

Run libzdb on windows 7
by Amira Rashed 24 May '18

24 May '18

Hello My operating system is windows 7 , is it possible to run libzdb on windows 7 ? Best Regards

1 0

Re: Using libzdb compiler support Oracle DB in Ubuntu system
by Jan-Henrik Haukeland 28 Oct '16

28 Oct '16

Try this ./configure --with-oci-include=/usr/include/oracle/11.2/client/ --with-oci-lib=/usr/lib/oracle/11.2/client/lib/ > On 27 Oct 2016, at 15:03, 方彪 <fangbiao2008(a)foxmail.com> wrote: > > Hello： > I am a software engineer in hangzhou ,Zhejiang province, because of job requirements，I need to use the Ubuntu system based on libzdb development support Oracle Database，According to the following website description,(https://segmentfault.com/a/1190000003739454),I successfully installed client x86 for Oracle and has been connected to the remote Oracle database server，but when I configure the libzdb programe ,print result not support Oracle(Oracle: DISABLED ). Print the following information: > > ...... > checking for oracle... checking for Oracle OCI headers in /usr/include/oracle/11.2/client/... yes > checking for Oracle OCI libraries in /usr/lib/oracle/11.2/client/lib/... not found > checking if Oracle support is enabled... no > ...... > > But Oracle OCI libraries in /usr/lib/oracle/11.2/client/lib/ already exist,Can you help me and explain why? > Thank you very much!

1 0

Installing libzdb3.1 on HP_UX
by 李青朝 29 Sep '16

29 Sep '16

HI! The official documents say that libzdb can install on Linux. So it can be installed on Unix? I got a problem when installing libzdb3.1 on HP_UX. Is there anyone succeed to install libzdb on native HP_UX? Beside configure && make && make install， what else shoul I do before Installing ? I need help!!! Lee --------------------------------------------------------------------------------------------------- Confidentiality Notice: The information contained in this e-mail and any accompanying attachment(s) is intended only for the use of the intended recipient and may be confidential and/or privileged of Neusoft Corporation, its subsidiaries and/or its affiliates. If any reader of this communication is not the intended recipient, unauthorized use, forwarding, printing, storing, disclosure or copying is strictly prohibited, and may be unlawful.If you have received this communication in error,please immediately notify the sender by return e-mail, and delete the original message and all copies from your system. Thank you. ---------------------------------------------------------------------------------------------------

1 0

a poor design about ConnectionPool_getConnection
by dec wu 19 Aug '16

19 Aug '16

*hi* this function *ConnectionPool_getConnection* is designed badly。 between code *LOCK(P->mutex)* and *END_LOCK*, *Connection_ping* and *Connection_new* may block long time (reconnect/connect to sql server),so other threads will wait long time. * should't block when locked!!!!* see below code for detail: *Connection_T ConnectionPool_getConnection(T P) {* * Connection_T con = NULL;* * assert(P);* * LOCK(P->mutex) * * {* * int size = Vector_size(P->pool);* * for (int i = 0; i < size; i++) {* * con = Vector_get(P->pool, i);* * if (Connection_isAvailable(con) && Connection_ping(con)) {* * Connection_setAvailable(con, false);* * goto done;* * } * * }* * con = NULL;* * if (size < P->maxConnections) {* * con = Connection_new(P, &P->error);* * if (con) {* * Connection_setAvailable(con, false);* * Vector_push(P->pool, con);* * } else {* * DEBUG("Failed to create connection -- %s\n", P->error);* * FREE(P->error);* * }* * }* * }* *done: * * END_LOCK;* * return con;* *}*

1 0

Connecting connection pool using certificate
by Vicki Ma 09 Apr '16

09 Apr '16

Hi, I plan to use libzdb for connection pooling, but I am not sure if I can connect to the connection pool using user certificate. In the document, it specifies how to connect to Postgresql database. postgresql://localhost:5432/test?user=root&password=swordfish Can I pass the following: postgresql://user:secret@localhost I did not see the options mentioning connecting database using certificates. http://tildeslash.com/libzdb/api-docs/postgresoptions.html Thanks very much, Vicki Ma

4 9

Retrieving pqxx::result
by Ma, Vicki 09 Apr '16

09 Apr '16

Hi, I have a question, say, I connect to libzdb connection pool (connecting to a Postgresql database), and execute a query, do I have a way to retreive the native result, ie. pqxx::result from libzdb ResultSet? Thanks in advance, Vicki >

1 0

access Archives of this mailing list
by Ma, Vicki 07 Apr '16

07 Apr '16

Hi, I am new to the mailing list, I want to take a look at archieve, so I don’t ask questions answered before, but I was not able to access the Archives. http://www.tildeslash.com/mailman/listinfo/libzdb-general http://www.tildeslash.com/pipermail/libzdb-general/ Does anyone know how? Thanks Vicki Ma

1 0

access archieve
by Ma, Vicki 07 Apr '16

07 Apr '16

Hi, I am new to the mailling list, I want to take a look at archieve, so I don’t ask questions answered before, but I was not able to access the Archives. http://www.tildeslash.com/mailman/listinfo/libzdb-general http://www.tildeslash.com/pipermail/libzdb-general/ Does anyone know how? Thanks Vicki Ma -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

1 0

AssertException in OraclePreparedStatement_getLastError()
by Pavlo Lavrenenko 15 Mar '16

15 Mar '16

Hello. I have dbmail-imapd crashed with: > Jan 20 04:25:17 um1 dbmail/imap4d[24111]: EMERGENCY:[libzdb] TabortHandler(+43): AssertException: 0x0x3db0e15950 > raised in OraclePreparedStatement_getLastError at src/db/oracle/OraclePreparedStatement.c:257 Which seems to be triggered by assert() in OraclePreparedStatement_getLastError(): > 251 /* This is a general error function also used in OracleResultSet */ > 252 const char *OraclePreparedStatement_getLastError(int err, OCIError *errhp) { > 253 sb4 errcode; > 254 char* erb; > 255 pthread_once(&error_msg_key_once, error_msg_key_alloc); > 256 erb = get_err_buffer(); > 257 assert(erb); I do not have any steps to reproduce the issue unfortunately, but maybe you can give me a nudge into a right investigation direction (I am investigating why get_err_buffer() returned NULL). I would also be nice to have another thread safe way to store the error message or even to print it (providing the issue is reproducible at all). -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., Junior Software Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624 PortaOne - VoIP Solutions Company Visit our Website: http://www.portaone.com

3 3

How to directly get the record number from the query results?
by Chengyu Fan 20 Jan '16

20 Jan '16

Hi, Does anyone know how to get the record number from the query results using libzdb? I did not find such API in the manual. Thanks, Chengyu

2 2

libzdb-3.2 release plan
by Pavlo Lavrenenko 06 Oct '15

06 Oct '15

Hello. Just for my information guys, are there any release plans for libzdb-3.2? -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., Junior Software Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624 PortaOne - VoIP Solutions Company Visit our Website: http://www.portaone.com

2 1

Sorry to bother you
by Ethan Chen 21 Sep '15

21 Sep '15

Dear sir: So sorry to bother you. I am working in a techology company now, and i am in a project which needs to be connected with serveal database. The work have been done well by using the libzdb. But i meet a question when i try to call a function(or store procedure) defiend by myself, which i mean i'd like to find a function like SetProcSQL() in the OCCI that connect ORACLE. Although I have read the documentation, i did not find the examples how to implement it . So can you tell me does any function which can implement it? Thank you for youtr time, maybe i didn't make myself clear for my poor English.I looking for your repley. Best wish. Ethan Chen

1 0

libzdb : Missing 64-bit support Error
by Mahajan, Anand 31 Aug '15

31 Aug '15

Hi there, We are using Libzdb database library version 2.8.1 in our iOS application; now we are trying to upload the application using App Loader to iTunes store; we have got following error; 'Missing 64-bit support - Beginning on February 1, 2015 new iOS apps submitted to the App Store must include 64-bit support and be built with the iOS 8 SDK. Beginning June 1, 2015 app updates will also need to follow the same requirements. To enable 64-bit in your project, we recommend using the default Xcode build setting of "Standard architectures" to build a single binary with both 32-bit and 64-bit code' Following are our project settings; The error message suggested to add 'standard Architecture' to enable 64-bit support in application; upon setting 'arm64' value for 'valid architecture' in project setting; application is displaying following error Undefined symbols for architecture arm64: "_ResultSet_getDouble", referenced from: _getInvProductsFromDB in .o" ld: symbol(s) not found for architecture arm64 clang: error: linker command failed with exit code 1 (use -v to see invocation) We are getting undefined symbol error for every API call of libzdb library; Could you please guide us to build the library for default Xcode setting of standard architecture(arm64, arm7,armv7s)? Appreciate your quick response; Thank you! Anand Mahajan =============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ===============================================================================

2 1

[Announce] libzdb 3.1
by Jan-Henrik Haukeland 31 Aug '15

31 Aug '15

Version 3.1 of libzdb is now available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.1.tar.gz MD5 checksum: 01d8519a596d62f6b43559cc29ecd36d Release notes at http://www.tildeslash.com/libzdb/#release_notes

1 0

SQL query timeout for OracleConnection
by Pavlo Lavrenenko 31 Aug '15

31 Aug '15

Hello. I've noticed query timeout for Oracle connections is a stub, seems like OCI API does not provide a way to limit query execution out-of-box. Yet I am trying to workaround the blocked (server-side) connections issue with DBMail and setQueryTimeout() seems to be a good tool for that. So far I came up with a thread-based solution: 1. a dedicated thread is created for every db connection; 2. thread acts like a watchdog: for every started query it counts down from TIMEOUT value to zero; 3. if query execution is finished the counter is reset and thread idles; 4. if counter reaches 0 the thread calls OCIBreak(). I'd like to know your vision on the solution and reasons why query timeouts are not implemented for Oracle backend before I start the development and publish the patch. TIA. -- Best regards, Pavlo Lavrenenko, PortaOne, Inc., Software Developer Tel: +1-866-SIP VOIP (+1 866 747 8647) ext. 7624 PortaOne - VoIP Solutions Company Visit our Website: http://www.portaone.com

2 2

Multiple database connection pool problem
by patel ravi 12 Aug '15

12 Aug '15

Hello, I am using libzdb for database connection pool from a C++ program . Till now I was making only one database connection pool through libzdb and was working perfect . Now I need to make multiple database connection pools , I tried making this , but it consider only one connection pool and fetch the data from only one database . I found that Multiple database connection is possible through libzdb , somehow I am not able to do that . Any help will be appriciated. Thank You,Ravi

2 1

Undefined reference errors
by Srinivasa Rao Battula 04 May '15

04 May '15

Hello, I am trying to link libzdb on Ubuntu with Code Blocks v13. I am facing following errors: obj/Release/SERVER/DBConnection/zdb_connection/cstzdbresultset.o: In function `CSTZDBResultSet::is_null(unsigned int) const': /home/bsr/work/Development/source_cs_server/SOURCE/SERVER/DBConnection/zdb_connection/cstzdbresultset.cpp:15: undefined reference to `ResultSet_isnull(ResultSet_S*, int)' /home/bsr/work/Development/source_cs_server/SOURCE/SERVER/DBConnection/zdb_connection/cstzdbresultset.cpp:18: undefined reference to `Exception_throw(Exception_T const*, char const*, char const*, int, char const*, ...)' Same problem is seen with all the symbols in the ResultSet.c. I have followed the instructions to build the library and is installed in /usr/local/lib. However, I am not seeing the same with Connection class and some of the exception macros. Please suggest me how to fix this problem. Thanks & Regards BSR Systems Manager M: +91 7032643557 E: bsr(a)srithripurasoft.com <https://3c-bs.gmx.com/mail/client/mail/mailto;jsessionid=35544C236AFAABFE0F…> ------------------------------ <https://3c-bs.gmx.com/mail/client/dereferrer?redirectUrl=http%3A%2F%2Fwww.n…> [image: Inline image 1] #205, Nilgiri Block Aditya Enclave, Ameerpet Hyderabad,Telangana Inda PIN:500016 W: http://www.srithripurasoft.com

1 0

CLOB-columns in Oracle DBs always return 'null'.
by Mats Christensen 04 May '15

04 May '15

Hi, It seems like libzdb (probaly) won't handle CLOBs in Oracle DBs very well. When selecting a CLOB directly nothing but the value 'null' is returned, when typecasting the CLOB to ex. VARCHAR2 it works perfectly. The same problem occurs when inserting data to a CLOB. Tests for Oracle also fails because of this. I've tried libzdb 2.8, 2.12 and 3.0, the same problem occurs in all three. This happens with Oracle Instant Client 11,1 11,2 and 12,1. Has anyone else encountered this? Is it a bug in libzdb or Instant Client? Thank you very much! Regards, Mats Christensen

5 9

Hallo
by Alessandro Vesely 22 Oct '14

22 Oct '14

I was trying to figure out differences between zdb and opendbx. The most relevant one is suspecting that opendbx is not being actively maintained. Opendbx supports Sybase. Libzdb looks very anonymous. Even this list's archives are not accessible. (http://www.tildeslash.com/pipermail/libzdb-general/) So I thought I'd just say hallo :-) Ale

1 0

about libzDB
by Mohamed abdElkhalek 03 Apr '14

03 Apr '14

i want to ask about if i can enable auto re-connection property with MYSQL in libzDB.

2 1

Unisgned integers
by Laxman Prabhu 03 Apr '14

03 Apr '14

Does LibZdb support unsigned int in the prepare statements ? I went through the Prepare statements source code and could only find long, int, long long, string. Is there any way to do a unsigned int operation ? Regards Laxman

2 1

Re: CLOB-columns in Oracle DBs always return 'null'.
by Volodymyr Tarasenko 03 Feb '14

03 Feb '14

Thanks for the code, I'm checking this case. Looks like blob was not read correctly. Let you know as soon as I get new results. Good luck, Volodymyr! On Saturday, February 1, 2014 3:44 PM, Volodymyr Tarasenko <tvntsr(a)yahoo.com> wrote: Hi, Mats, thanks for the code, I'm going to check it. Good luck, Volodymyr! On Saturday, February 1, 2014 2:52 PM, Mats Christensen <matschristensen(a)gmail.com> wrote: I missed the clob data on the earlier sql, this is correct. On Sat, Feb 1, 2014 at 1:44 PM, Mats Christensen <matschristensen(a)gmail.com> wrote: See the attachment select.c and clob_test.sql > > >Libzdb 3.0 and Oracle Instant Client 12.1 >This setup returns the following for me: > > >mats@x220 ~/libzdb/libzdb-3.0/test $ ./select >This is getString: >this is a varchar (null) >this is another var (null) >This is getBlob: >this is a varchar this is a clob >this is another var this is another clob > > > > >Can you see if it works for you? The problem might be my setup although I've tried two completely different linux setups. > > >Thanks! > > >Regards, >Mats Christensen > > > > > >On Sat, Feb 1, 2014 at 1:12 AM, Jan-Henrik Haukeland <hauk(a)tildeslash.com> wrote: > >ResultSet_getBlob or ResultSet_getString should be interchangeable on a blob or text column. Though of course, if the blob column contains binary data only ResultSet_getBlob should be used to get the correct value. >> >>I should say that a problem with using ResultSet_getString on a blob column was just fixed in Oracle and confirmed fixed in version 3.0. So with one datapoint, the above seems to work. If you want us to investigate, we are also more inclined to do so if you can provide a small test program demonstrating the problem. Or argue in detail why the problem must be in libzdb. >> >>Best regards >>-- >>Jan-Henrik Haukeland >> >> >>On 31 Jan 2014, at 13:36, Mats Christensen <matschristensen(a)gmail.com> wrote: >> >>> >>> I'm not very familiar with Oracle either but it seems like CLOB is for Oracle what TEXT is for Postgres and MySQL. >>> >>> There is a function in the dbmail-code called 'db_result_get_blob', it is used for several things, >>> like '_fetch_headers'. HEADERVALUE is a CLOB.on Oracle and TEXT on Postgres. >>> >>> Perhaps this function should have been used on '_fetch_envelope' too? >>> >>> It will probably be easiest for me to just use getBlob instead, as for upstream, perhaps it's a good idea to use >>> 'db_result_get_blob' for all TEXT/CLOB-fields if it works? >>> >>> Thank you very much for the help! >>> >>> Regards, >>> Mats Christensen >>> >> >>-- >>To unsubscribe: >>http://www.tildeslash.com/mailman/listinfo/libzdb-general >> > -- To unsubscribe: http://www.tildeslash.com/mailman/listinfo/libzdb-general

1 0

Announce] libzdb 3.0
by Jan-Henrik Haukeland 06 Jan '14

06 Jan '14

Version 3.0 of libzdb is now available: Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.0.tar.gz MD5 checksum: 3bb9efff10a1f3ebc5b76c1055c48635 Please see the release notes at http://www.tildeslash.com/libzdb/#release_notes

1 0

Libzdb 3.0 beta
by Jan-Henrik Haukeland 05 Jan '14

05 Jan '14

Happy new year! We been working on a new libzdb 3.0 release which include some new useful features. Most notable support for Date, Time and timestamp. This release includes a lot of changes so we wanted to release this as a beta version/release candidate first. If you can, please help us test. If you find a problem, please use the issue tracker at https://github.com/tildeslash/libzdb/issues Download: http://www.tildeslash.com/libzdb/dist/libzdb-3.0b.tar.gz MD5 checksum: 6c0334d8132723d8a58414d4b208690e Developer version: https://github.com/tildeslash/libzdb/releases Changes in this release: ------------------------ * New: Methods for retrieving Date, Time, DateTime and TimeStamp column values from a ResultSet. PreparedStatement_setTimestamp for setting Unix timestamp. * New: ResultSet_isnull, can be used to explicit test if a column value in a Result Set is SQL null. A Result Set already returns the NULL pointer for string and blob types and 0 for primitive data types, but to differ between SQL null and the value NULL or 0, this method can be used. * New: PreparedStatement_getParameterCount, Returns the number of parameters in a prepared statement * New: It is now a checked runtime error for the url parameter given in ConnectionPool_new() to be NULL. * New: No longer require flex installed as the generated file is part of the dist. * Fixes: Oracle: Fixed a memory corruption in OracleResultSet https://github.com/tildeslash/libzdb/issues/4 Best regards -- Jan-Henrik Haukeland

2 1

libzdb
by edavanzo＠vodafone.it 30 Nov '13

30 Nov '13

Hi, I have a request for a bit particular: Can I have libzdb.dylib already compiled for use in a xcode project (iphone or iPad prj) to connect to an Oracle DB and then execute a Select command. Sorry for the strange request but I have no familiarity with compilers. Thanks for everything. (If needed I can pay the bother) Or can you tell me where and how I can buy it. Best Regards.

2 1

MSSQL and Sybase with libzdb
by Abhay Gupta 27 Nov '13

27 Nov '13

Hi, I was wondering as to why the support for MSSQL and Sybase is not added via a freetds library ? This will make libzdb complete pool library with mostly used databases being supported . Thanks, Abhay

2 1

MySQL Cluster with dbmail, Possible?
by Matt . 05 Nov '13

05 Nov '13

Hi All, I'm new to dbamil with libzdb but it works great in the first setup. Is it possible with libzdb to connect to a pool of MySQL servers which are all master using an array in some config anywhere ? I hope someone can help out. Thanks! Cheers, Matt

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

libzdb-general