Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Author: Ivan Revelli

Digital solution partner

SSL Certificate – Extract crt and key from pfx cert file

How to Convert a PFX Certificate to PEM and Extract the CRT File In this article, I will show you how to convert a PFX certificate to PEM format and extract the CRT file using OpenSSL. Follow these simple steps to complete the operation. 1. Extract the Private Key from the PFX File First, we…
Read more

smartFB v. 2.2.0.185 is available for download!

smartFB v. 2.2.0.185 is available for download at the link: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe What’s New: New form to test API connections, styled like Postman ( Tools –> Network Utility –> API Tester ) Direct display of stored procedure parameters on the main db tree  Improved syntax highlighting and parenthesis management in the editor Introduced field-level dependency analysis…
Read more

Enable Office365 basic auth for specific domains

BasicAuth for Microsoft Office365 is deprecated. But if you have a WebDav share in your lan that use the user/password auth method you can add your domain to a “BasicAllowList” on your Office settings. To add your domain in your Office365 you need to edit your Windows Registy via regEdit. Suppose you have Xtumble as…
Read more

Firebird SQL “REPLACE” tips

Managing the “&” character with Firebird’s string manipulation functions sometimes may not yield the expected results. The documentation for Firebird’s official “REPLACE” function: https://firebirdsql.org/refdocs/langrefupd25-intfunc-replace.html For example, if we were to make the classic replacement “>” with “>” with an update, it would be normal to write: UPDATE “YOUR_TB_NAME” SET “YOUR_TB_NAME”.”TEXT_FIELD” = REPLACE(“YOUR_TB_NAME”.”TEXT_FIELD”,’>’,’>’) If this syntax…
Read more

smartFB v. 2.2.0.185 released

smartFB v. 2.2.0.185 is available at: https://api.xtumble.com/downloadattachmentpub?cid=05830520960&fname=/applications/public/SetupSmartFB.exe Whats new:  Firebird 5.0 support “Internal Function” manager  For any questions or feedback, please do not hesitate to contact us. Your opinion is crucial to us! Thank you for your support and trust in smartFB. Good luck with your Firebird databases!

Install Firebird 5.0 over Ubuntu 22.04

Firebird 5.0 brings with it a remarkable series of improvements from many points of view, from performance to security to the management of parallel backups and restores. You can find these well described at the following link: https://ib-aid.com/en/articles/detailed-new-features-of-firebird-5-part-1-improvements-in-optimizer. So, let’s get down to business, let’s install Firebird 5.0 on a nice Ubuntu 22.04 machine in…
Read more