241 results found
-
dbmonitor
dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.
3 votes -
Add ability TMSDump to dump all of database (not only data) to sql script. i.e schema - create statement, sp,triggers, etc.
The same functionality which has dbforge studio or ssms.
1 vote -
Add beta support for FB 4.0 or at least new data types.
Please add support for FB 4.0 while it is still in beta or at least add support for the new FB data types so that developers could start using them in new applications.
12 votes -
Support for OpenSSL 1.1
UniDAC currently only supports OpenSSL 1.0.2. This version won't be supported past 2019-Dec-31.
To avoid problems UniDAC should support OpenSSL 1.1
4 votes -
Add support for Direct Mode SQLite with FTS5 enabled.
Include SQLite extensions like enable FTS5 in direct mode connection in UniDac.
5 votes -
Add futures for autostart transactions
Add futures (properties) AutostartTransacttion to UniQuery, UniSQL, UniStoredProc
1 vote -
Add delta support like Firedac for cachedupdates, better yet as a Tunidatasetoption
Your implemantation of cached updates with Updatebatchsize is super fast in comparison to firedac. But sometimes we need to see query delta to apply changes to other datasets without using stored procedures.
1 vote -
Implementation of the new authenticatthod of newer Microsoft SSMS.
Implementation of the new authentication method of newer Microsoft SSMS:
* Active Directory – Universal with MFA support
* Active Directory - Password
* Active Directory - Integrated48 votes -
Direct mode OraQueue AsyncNotification support
Add Async notifications support to OraQueue in Direct mode.
4 votes -
Allow more than 150 procedure parameters.
Change TOCICommand.InitProcParams7 MaxParams constant to 250
3 votes -
Add Support For SQL Server "Always Encrypted"
SQL Server now has a new security feature called "Always Encrypted". This is a recognised Microsoft solution for encrypting certain sensitive database columns to meet European Union GDPR regulations. Please add "Always Encrypted" support into Devart SQL Server data access components. This is a recognised approved solution to SQL Server DBA's.
1 vote -
Автозагрузка свойств поля TField
У компонентов FIBPlus есть замечательная фича.
Когда в базе (Firebird) меняешь размер поля, то не нужно корректировать этот размер у DataSet компоненты. Компонента (TpFibDataSet) сама подтянет новый размер поля в дизайнтайме.
Было бы здорово, чтобы компонента TUniQuery тоже такое умела.
Вообще, желательно, чтобы подгружался не только размер поля, а и другие параметры и не только текстового.
Я работаю с UniDAC примерно с 2012 г и удивлён, что этой фичи ещё нет.
У FIBPlus много вкусного, жаль, что они больше не развиваются.Под словом "подтягивать" я имел ввиду брать из базы, из системных таблиц читать разные параметры поля и применять их…
1 vote -
Автогенерация InsertSQL, UpdateSQL
Я знаю, что у TUniQuery есть возможность сгенерировать доп. запрос на основе SelectSQL.
Но это неочевидно, в справке нет. Нет готовых методов.
Приходится открывать предварительно сам запрос, что есть не совсем правильно.[code] UniQuery1.Open;
UniQuery1.SQLUpdate.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stUpdate, true);
UniQuery1.SQLRefresh.Text := TDBAccessUtils.SQLGenerator(UniQuery1).GenerateSQL(TDAParamsInfo.Create(TDAParamInfo) , _stRefresh, true);
[/code]
да и без UniQuery1.Open вываливается AV :(Было бы здорово, если бы было что-то вроде:
UniQuery1.GelerateAllSQLs.
UniQuery1.GelerateInsertSQL;
UniQuery1.GelerateUpdateSQL;
UniQuery1.GelerateDeleteSQL;
и т.д.
и без обязательного открытия набора данных.1 vote -
CockroachDB support
"CockroachDB is a cloud-native SQL database for building global, scalable cloud services that survive disasters."
16 votes -
4 votes
-
Cloned Cursors
Today i'm more and more using TClientDataset because of the cloned cursor and Unidac just for for synchronize and transport between the back end database and the TClientDataset. With a cloned cursor multiple components can share the same data-space and the speed and memory gains are huge, but i would preferer to do this in the unidac and not have another extra layer of technology.
A tQuery with all the functionality of tClientDataSet would be very nice and Firedac is moving that way.
15 votes -
Support for the TDataset.FieldOptions property in IBDAC
Support for the TDataset.FieldOptions property in IBDAC, specialy the AutoCreateMode so the TIBCQuery can add missing TFields automaticlly
19 votes -
Unified SQL: add function "dayoftheyear"
Please add the function dayoftheyear to the list of unified sql functions
3 votes -
Support Postgres Advanced Server
Postgres Advanced Server (PAS) is an extended version of PostgreSQL, it supports Stored Procedures, Packages and Aliasses. Currently, PgDAC does not support executing several of the commands available in PAS.
6 votes -
TMSQuery.SaveToStream/LoadFromStream the entire data set
An optimized version of this (maybe without the need to go to/from dataset to make it go faster)
var
query: TMSQuery;
VirtualTable: TVirtualTable;
begin
query := db.CreateMSQuery( ); //returns TMSQuery
query.SQL.Text := 'select * from [table]';
query.open;
result := binary.create;
VirtualTable := TVirtualTable.Create(nil);
VirtualTable.Assign(query);
VirtualTable.saveToStream( result );
VirtualTable.free;
query.free;
end;4 votes
- Don't see your idea?