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

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
PRESENTATIONS FROM FIREBIRD TOUR 2017: FIREBIRD PERFORMANCE AND TUNING LINUX AND WINDOWS

We start to publish presentations from Firebird Tour 2017. Please find the first 2 presentations below:
“, by Vlad Khorsun, Firebird Project
” by Alex Kovyazin, IBSurgeon.
More presentations will be published later – stay tuned!



 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language


December 05, 2017

More presentations from Firebird Tour 2017: Performance:
  1. , by Dmitry Kuzmenko, IBSurgeon
  2. , by Vlad Horsun, Firebird Project
Stay tuned for more interesting materials



 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
Apple Xcode 9.2 Build 9C40b Stable MacOS
1gb each part

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Express Pro Edition v5.2.2.283 x64/x32


Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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, 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 .


.... read more in:







by on March 1st, 2016





Windows 10 Creators uninstall program automatically and block install

 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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:
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Expert Pro v5.2.2.285 x64/x86

Скрытое содержимое доступно для зарегистрированных пользователей!
 

gigo

New member
Регистрация
04.05.2010
Сообщения
5
Реакции
5
Баллы
3
Synopse mORMot framework

D7 to Tokyo 10.2.2
Win32,Win64, Linux (via FPC)

SQLite Engine
Switch to SQL/NoSQL in few lines of code

ORM, Web MVC, JSON, REST, WebSockets.
Fast and scalable, generates small executables ready to deploy (no dependancies).



Home page :
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Expert Pro v5.2.2.287 x64/x86

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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
 
Последнее редактирование:

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Expert Pro v5.2.2.291 x64/x86

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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

 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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 . 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 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 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 as well.



 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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 . 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 for yourself to see the rest of the REST API end points. I grabbed the and used those two endpoints in the 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 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



 

orfey

New member
Регистрация
30.11.2008
Сообщения
16
Реакции
3
Баллы
3
Native language | Родной язык
Русский
MIDA Converter Basic patched for RAD Studio 10.1.2 Berlin

пароль: qnsw
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Expert Pro v5.2.2.293 x64/x86

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
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:


02.Product_01_Premium_Windows_01_Mainscreen.png


Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
RAD DevOpt - Tools of Automation video by Embarcadero by Craig Chapman



Learn how to automate your build process with Delphi, CBuilder or RAD Studio using VisualSVN Server and TortoiseSVN



Your development never will be the same later this video
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
... not only for Delphi...

Aqua Data Studio v18.5.0.5


screenshot_query_analysis_tool-large.png



more info

Database Administration Tools

Administration tools for , , , , , , , , , , , , , , , and 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

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
SQLite Expert Pro v5.2.2.297 x64/x86

Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
DbSchema v7.6.5 build 4906 x64/x86

more info

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.


Скрытое содержимое доступно для зарегистрированных пользователей!
 

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language

ermax

Well-known member
Команда форума
Moderator
Premium
Регистрация
05.05.2008
Сообщения
2 485
Реакции
2 188
Баллы
113
Местоположение
here and there
Native language | Родной язык
Other language
198 237Темы
635 209Сообщения
3 618 425Пользователи
Pandar96Новый пользователь
Верх