Tools/Utilities Утилиты для delphi / utilities for delphi

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
Firebird and Windows 10 Fall Creators Update

By IBPhoenix


Windows 10 is well known for encouraging a love/hate relationship with its users. From the beginning Microsoft implemented a policy of uninstalling users' software without their consent during installation or update of Windows 10. Many articles on the net discuss this, for example however, until now, Firebird seemed to be unaffected.


Not any more. Windows 10 Creators Edition (Build 1709), released in September 2017 seems to have added Firebird to its hit list of dangerous applications. This problem was first reported here.


.... read more in:


https://www.ibphoenix.com/resources/documents/general/doc_476


Windows 10 May Delete Your Programs Without Asking

by Chris Hoffman on March 1st, 2016


https://www.howtogeek.com/243581/windows-10-may-delete-your-programs-without-asking/


Windows 10 Creators uninstall program automatically and block install

https://www.tenforums.com/software-...tall-program-automatically-block-install.html
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
How to make Firebird work 20% faster on Windows Server 2016 in less than 1 minute by IBSurgeon

More and more users upgrade to Windows Server 2016 from old versions, and some of them have noticed that Windows Server 2016 works slower than previous versions, even on the same hardware with the same database.

We have made several tests on Windows Server 2016 and Firebird, and found, among other things, the option, which dramatically influences the performance of the Windows Server 2016: the power plan.

By default, Windows 2016 has «Balanced» power plan, which automatically balances performance with energy consumption on capable hardware. Well, sounds not dangerous, but in fact, Balanced power plan at Windows Server 2016 greatly suppresses CPU performance and decrease the overall performance of the server.

It is possible to switch Power plan on the fly, no need to reboot. See the effect of enabling «High Performance» power plan on the server with Firebird database, which serves 70 connections:

CPU_on_Windows_Server_2016_with_enabled_high_performance.png


more info: https://ib-aid.com/en/articles/how-...at-windows-server-2016-in-less-than-1-minute/
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
DMSoft DBConvert for ‌Access and ‌Firebird
DMSoft DBConvert for Access and FoxPro
DMSoft DBConvert for Access and MSSQL
DMSoft DBConvert for Access and MySQL
DMSoft DBConvert for Access and PostgreSQL
DMSoft DBConvert for Access and SQLite
DMSoft DBConvert for Firebird and MSSQL
DMSoft DBConvert for Firebird and MySQL
DMSoft DBConvert for FoxPro and MSSQL
DMSoft DBConvert for FoxPro and MySQL
DMSoft DBConvert for FoxPro and SQLite
DMSoft DBConvert for MSSQL and DB2
DMSoft DBConvert for MSSQL and MySQL
DMSoft DBConvert for MSSQL and PostgreSQL
DMSoft DBConvert for MySQL and DB2
DMSoft DBConvert for MySQL and PostgreSQL
DMSoft DBConvert for Oracle and Access
DMSoft DBConvert for Oracle and MSSQL
DMSoft DBConvert for Oracle and MySQL
DMSoft DBConvert for Oracle and PostgreSQL
DMSoft DBConvert for Oracle and SQLite
DMSoft DBConvert for SQLite and MSSQL
DMSoft DBConvert for SQLite and MySQL
DMSoft DBSync for Access and Firebird
DMSoft DBSync for Access and FoxPro
DMSoft DBSync for Access and MSSQL
DMSoft DBSync for Access and MySQL
DMSoft DBSync for Access and PostgreSQL
DMSoft DBSync for Access and SQLite
DMSoft DBSync for Firebird and MSSQL
DMSoft DBSync for Firebird and MySQL
DMSoft DBSync for FoxPro and MSSQL
DMSoft DBSync for FoxPro and MySQL
DMSoft DBSync for FoxPro and SQLite
DMSoft DBSync for MSSQL and DB2
DMSoft DBSync for MSSQL and MySQL
DMSoft DBSync for MSSQL and PostgreSQL
DMSoft DBSync for MySQL and DB2
DMSoft DBSync for MySQL and PostgreSQL
DMSoft DBSync for Oracle and Access
DMSoft DBSync for Oracle and MSSQL
DMSoft DBSync for Oracle and MySQL
DMSoft DBSync for Oracle and PostgreSQL
DMSoft DBSync for Oracle and SQLite
DMSoft DBSync for SQLite and MSSQL
DMSoft DBSync for SQLite and MySQL
[SHOWTOGROUPS=4,20]
http://dl.downloadly.ir/Files/Softw...d_MS_SQL_2.1.2_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...nd_MySQL_4.7.2_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...nd_MSSQL_2.1.4_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...nd_MSSQL_1.5.0_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...nd_MySQL_6.8.1_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw..._and_DB2_1.2.4_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...nd_MSSQL_4.6.3_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw..._and_DB2_2.0.9_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBConvert_for_Access_MSSQL_6.1.0_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBConvert_for_MSSQL_PostgreSQL_3.6.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...stgreSQL_2.9.2_Multilingual_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBSync_for_Oracle_and_MySQL_1.7.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBSync_for_SQLite_and_MySQL_1.5.6_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...Oracle_and_PostgreSQL_1.1.9_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBSync_for_Access_and_MSSQL_4.1.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/DMSoft.DBSync.for.Oracle.and.MSSQL.v1.4.0_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...for.Access.and.MySQL.v8.3.4_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...for.Oracle.and.MySQL.v2.2.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw....Access.and.Firebird.v1.2.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or.Access.and.FoxPro.v3.4.5_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...ccess.and.PostgreSQL.v4.3.6_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or.Access.and.SQLite.v1.0.9_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or_Firebird_and_MSSQL_2.1.5_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or_Firebird_and_MySQL_1.5.7_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...for.FoxPro.and.MSSQL.v4.6.7_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...for.FoxPro.and.MySQL.v4.6.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or.FoxPro.and.SQLite.v1.1.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw....for.MSSQL.and.MySQL.v4.2.6_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBConvert.for.MySQL.and.DB2.v1.2.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...MySQL.and.PostgreSQL.v4.3.3_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or.Oracle.and.Access.v1.1.8_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...racle.and.PostgreSQL.v1.1.7_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...or.Oracle.and.SQLite.v1.2.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw..._for_SQLite_and_MSSQL_1.6.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw..._for_SQLite_and_MySQL_1.8.4_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft_DBSync_for_Access_and_Firebird_1.1.8_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.Access.and.FoxPro.v3.4.5_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...ccess.and.PostgreSQL.v4.2.0_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.Access.and.SQLite.v1.0.8_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.Firebird.and.MySQL.v1.6.0_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.FoxPro.and.SQLite.v1.1.1_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.MSSQL.and.DB2.v2.0.3_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/DMSoft.DBSync.for.MSSQL.and.MySQL.v5.4.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...MySQL.and.PostgreSQL.v3.8.2_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.Oracle.and.Access.v1.1.9_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software/DMSoft.DBSync.for.Oracle.and.SQLite.v1.2.3_Downloadly.ir.rar


pass www.downloadly.ir
[/SHOWTOGROUPS]
 
Last edited:

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
Keep Controls Visible When Virtual Keyboard Pops Up In Delphi 10.2 Tokyo On Android And IOS

Summary:
// Include System.Messaging in the uses clause

type

TForm1 = class(TForm)
private
procedure VirtualKeyboardRectChangeMessageHandler(const Sender: TObject; const M: TMessage);

public
constructor Create(AOwner: TComponent); override;

destructor Destroy; override;
end;

...

uses
DW.Messaging, DW.VirtualKeyboard.Helpers;

constructor TForm1.Create(AOwner: TComponent);
begin
inherited;

TMessageManager.DefaultManager.SubscribeToMessage(TVirtualKeyboardRectChangeMessage,
VirtualKeyboardRectChangeMessageHandler);
end;

destructor TForm1.Destroy;
begin
TMessageManager.DefaultManager.Unsubscribe(TVirtualKeyboardRectChangeMessage,
VirtualKeyboardRectChangeMessageHandler);
inherited;
end;

procedure TForm1.VirtualKeyboardRectChangeMessageHandler(const Sender: TObject; const M: TMessage);
var
LRect: TRect;
begin
LRect := TVirtualKeyboardRectChangeMessage(M).Value;
// LRect now contains the actual rect of the VK
end;

Complete thread in Embarcadero Forum

https://forums.embarcadero.com/thread.jspa?messageID=902344
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
Easily Build A Bitcoin Cryptocurrency Profit And Loss Tracker In Delphi 10.2 Tokyo For Android And IOS (on December 29, 2017)

Keeping track of your cryptocurrency across multiple exchanges can be a chore. I built this simple cryptocurrency profit and loss tracker for your bitcoin and altcoin holdings. Basically the tracker ties into the CoinMarketCap.com REST API for getting currency quotes and allows you to store your current holdings in an FDMemTable. Once you add all of the cryptocurrencies that you hold into the TStringGrid you can add the price that you paid for them and the amount that you have. The app does the needed calculations automatically using the quote data that it pulls down from CoinMarketCap when you press the Refresh button in the app.

I built the app interface mainly for Windows but it should also work well on OSX plus Android and IOS tablet devices. It does use a TMultiView to hold the list of 1300+ cryptocurrencies (double click to add) but some of the controls could be re-arranged for a better layout on phone size devices (by using a TTabControl). There are two TFDMemTables within the app. The first one is tied to the TRESTClient controls which I created using the REST Debugger. The REST Debugger basically has a cheat button which will create all of the needed controls to access a REST API and pull the data into a TFDMemTable with no code. In any event the TFDMemTable tied to the REST client holds the quote data that you request from the CoinMarketCap API. The other TFDMemTable holds the list of your cryptocurrency holdings. Both TFDMemTables are LiveBinded to their own TStringGrids. When you select one of your cryptocurrency holding records in the second TFDMemTable you can also edit the data in the edit fields on the right side of the app. They also use LiveBindings for updating the data in the holdings TFDMemTable. I also used the Vapor premium style to get the look and feel of the app.

I have published the full source code for the app over on GitHub. According to the Delphi IDE stats it took around 21 minutes to build this app. Be sure to check out the other blog post about integrating Delphi with the GDAX cryptocurrency trading API as well.



https://github.com/FMXExpress/CryptoCoinProfitTracker/
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
Quickly Integrate With A Bitcoin Cryptocurrency Exchange API With Delphi 10.2.2 For Android And IOS (on December 22, 2017)

Integrating with Bitcoin Cryptocurrency exchange APIs can sound like a daunting task but it was relatively easy to do with Delphi and FireMonkey. Unless you have been living under a rock you probably know that Bitcoin and other cryptocurrency have really seen a surge in value throughout 2017. If you HAVE been living under a rock you can check out this newbies guide to bitcoin and cryptocurrency. GDAX is an exchange owned by the popular Coinbase company. I literally built a REST client that talks to the GDAX API in 5 minutes and was able to start downloading the list of currencies on the exchange and getting price quotes for a currency. This is the first step to building an automated trading client, bot, or AI for cryptocurrencies. In addition to that because I used FireMonkey that same app client will deploy to Android, IOS, Mac, and Windows with a single code base and single UI.

You can check out the documentation for GDAX for yourself to see the rest of the REST API end points. I grabbed the products endpoint and the products book endpoint and used those two endpoints in the REST Debugger to quickly and easily download the data and LiveBind it to controls in my Delphi client. The first /products/ API I used directly because it doesn’t have any parameters. Once you select one of the cryptocurrency pairs at runtime it will use that for the next request to the /products/{currency}/book endpoint. The variable there can be set using code like the below and then it will automatically be filled in when the RESTRequest is executed (it is of type pkURLSEGMENT). The “/products/{currency}/book” string goes in the Resource property of the TRESTRequest component. I ended up only writing three lines of code for the whole app.

Delphi/Pascal

procedure TForm1.Button1Click(Sender: TObject);
begin
RESTRequest1.Execute;
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
RESTRequest2.Params.ParameterByName('currency').Value := Edit1.Text;
RESTRequest2.Execute;
end;

I also applied the Jet premium style (which gives the dark look to the client). As you can see in the screenshot I am also running the new dark theme in Delphi 10.2.2. It is really easy to get started using Delphi as a platform for creating your own bitcoin cryptocurrency AI bot GUI apps. You could also use Python on the back and just have Delphi execute your various Python commands if you already have a command line based Python cryptocurrency trading bot.




gdax.jpg



http://www.fmxexpress.com/wp-content/uploads/2017/12/GDAXQuotes.zip
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
Navicat Premium
v12.0.21 x64/x86 Windows
v12.0.18 MacOS
v11.2.16 x64/x86 Linux


Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases.


more info: https://www.navicat.com/en/


02.Product_01_Premium_Windows_01_Mainscreen.png


[HIDE="5"]
http://dl.downloadly.ir/Files/Software2/PremiumSoft_Navicat_Premium_12.0.21_x64_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/PremiumSoft_Navicat_Premium_12.0.21_x86_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/Navicat_Premium_12.0.18_macOS_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...emium_Edition_11.2.16_LINUX_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Softw...m_Edition_11.2.16_LINUX_x64_Downloadly.ir.rar

pass www.downloadly.ir
[/HIDE]
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
... not only for Delphi...

Aqua Data Studio v18.5.0.5


screenshot_query_analysis_tool-large.png



more info http://www.aquafold.com/aquadatastudio

Database Administration Tools

Administration tools for Amazon Redshift, DB2 LUW, Greenplum, Informix, MS SQL Server, MySQL, Netezza, Oracle, ParAccel, PostgreSQL, Sybase Anywhere, Sybase ASE, Sybase IQ, Teradata Aster, Teradata, and Vertica allow you to manage core aspects of your servers. For most of these databases, there are Instance, Storage, Security, and Session Managers. For Oracle, there's also a Rollback, Log, and SGA Manager. For MS SQL Server, there's an additional Agent Manager. For Amazon Redshift, Netezza and Vertica, there's a Query History view as well.

~600mbytes

[HIDE="5"]http://dl.downloadly.ir/Files/Software2/Aqua_Data_Studio_18.5.0.5_x64_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/Aqua_Data_Studio_18.5.0.5_x86_Downloadly.ir.rar

pass www.downloadly.ir [/HIDE]
 

emailx45

Premium
Joined
May 5, 2008
Messages
2,478
Reaction score
2,223
Location
here and there
DbSchema v7.6.5 build 4906 x64/x86

more info https://www.dbschema.com/index.html

Databases & Drivers

DbSchema can connect to any relational database plus few NoSql databases. New databases can be added directly in DbSchema, required is the proper JDBC driver. All database properties including SQL syntax are configurable in DbSchema Edit / Database Settings. Please write us about any issues or features.

https://www.dbschema.com/drivers.html
[HIDE="5"]
http://dl.downloadly.ir/Files/Software2/DbSchema_7.6.5_Build_4906_x64_Downloadly.ir.rar

http://dl.downloadly.ir/Files/Software2/DbSchema_7.6.5_Build_4906_x86_Downloadly.ir.rar

pass www.downloadly.ir
[/HIDE]
 
Top