243 results found
-
New component "Dump"
It would be great to have the existing component "TDADump" in UniDac for IBDac
but with more functionality that would be "Update or Insert"
this component could do export and import SQL data from one table to another table.3 votes -
New MasterConnection that uses master and slave connections
A new component (MasterConnection) that uses master connection for read and write changes to DB , while uses slave connections to write and update only for online backup and fail safe recovery point.
use case:
An application can use local SQLite server for all operation (read and write) due the performance performance advantage ,while a remote MySQL server along with a Cloud SQL provider receive all and only all (write operations -insert/update/delete)3 votes -
SDAC Data Encryption
Encryption parameters in SDAC Data
It would be very very usefull to use Parameters on Insert and Update Queries3 votes -
Allow more than 150 procedure parameters.
Change TOCICommand.InitProcParams7 MaxParams constant to 250
3 votes -
dbmonitor
dbMonitor - Define in the application for each TUniConnection if it sends messages to dbMonitor or not.
3 votes -
Add "Inverse Null Sort" (f.e.: "IN") function to IndexFieldNames
As the "coInvertNullOrder" flag -for client side sorting the dataset- is already imlpemented for some of the providers, it would be nice to be able to control the default method how NULL values are sorted (comes as first or comes as last).
The best approach would be to be able to control this over f.e. with an "IN" postfix in the IndexFieldNames, per field.
Like: "SomeField DESC IN;OtherField ASC"
Thx.
3 votes -
Support TDataset.FieldOptions (AutoCreateMode) in Unidac
Please implement the support of AutoCreateMode in your components.
Further description:
http://docwiki.embarcadero.com/Libraries/Rio/en/Data.DB.TFieldOptions.AutoCreateModeWith this option it's possible to create calculated fields in design time and all other fields will be added automaticly on runtime.
3 votes -
They should have a component that imports data from excel, csv, or text into a table and that supports large files.
They should have a component that easily imports data from excel, csv or text into a table and that supports large files.
3 votes -
Support inherited tables on the TPgDump component of PgDAC
Actually (v6.2.4), the PgDac TPgDump component does not generate appropriate code for inherited tables, making it useless when inherited tables are used, and we need to get the SQL script to generate the given schema.
TPgDump should support tables inheritance and:
- create base tables before inherited tables
- use the inherits clause within the table creation sql statement
- do not generate insert statements for base tables data, only for inherited tablesThanks,
3 votes -
proper support for connections in threads so transactions can be used
Connection Pooling should work in multi threaded environments with transactions.
I think the current design may be flawed. I think there should be a special connectionpool with which connections can be linked. in a multi-threaded environment, you want the thread to grab a connection, use it, and release it. at the moment, if you want to start a transaction, with connection pooling enabled, the current connection is basically blocked as it does not do anything smart in tracking the underlying connection to a thread. I currenltly get an error - cannot start transaction when one is already active... so I…6 votes -
Allow us to copy parameters in dbMonitor
In dbMonitor on the parameters screen it would be wonderful to be able to right click and copy the parameter value. We use lots of GUIDs and that would make life so much better when debugging.
Or can I download the source code for dbMonitor and edit it myself?
thanks,
Jon.
3 votes -
DetailDelay - DetailLoaded - status in Detail table
I am using DetaiDelay for all my tables (big database with lot of Master/Detail/SubDetail tables). After change of position of Master table I want check if data in Detail/Subdetail table was loaded/refreshed already.
Can you please add here any function, which can check it ?3 votes -
Extension of PostGreSQL to support multiple hosts
With PostGreSQL it is possible to specify multiple host components, each with an optional port component, in a single URI. A URI of the form
postgresql://host1:port1,host2:port2,host3:port3/is equivalent to a connection string of the form
host=host1,host2,host3 port=port1,port2,port3.Each host will be tried in turn until a connection is successfully established.
I'd like UniDAC to support this approach.
3 votes -
batchUpdates: get a RowsAffected array
When using batchUpdate, we have a total RowsAffected, but cannot know how many rows were affected by each individual parameter array item.
So if you take different actions according to return value of RowsAffected, batchUpdates cannot be used.
It would be nice to have a RowsAffectedArray (DynamicArray<__int64>, size = params.ValueCount) holding this value.3 votes -
Limit of records as it exists in FireDAC
I would like it to have a record limit setting that is the same or similar to what exists in FireDAC.
This configuration and the behavior of FireDAC with this configuration would be nice to have in the Devart ODAC component.Here is an example of what exists in FireDAC:
TFDQuery.FetchOptions.RecsMax := 100;3 votes -
Direct Json result from Db driver (no Dataset)
For remote server with REST we need a FAST Json result from Db driver, direct, avoiding dataset marshalling.
3 votes -
TfrxUniDACComponents Suport For Lazarus
Looking in the "UniDAC\Demos\ThirdParty\FastReport\" folder, I found a component: "TfrxUniDACComponents", which integrates Unidac with FastReport for Delphi, but I didn't find it for Lazarus. I'm using Lazarus 2.2.6 and would like to know if it's possible to develop this component for Lazarus as well.
3 votes -
Support GENERATED ALWAYS AS XXX STORED-Columns
In Postgres it's possible to create an readonly column,
See
https://www.postgresql.org/docs/current/sql-createtable.htmlGENERATED ALWAYS AS ( generation_expr ) STORED
This clause creates the column as a generated column. The column cannot be written to, and when read the result of the specified expression will be returned.Automatic generated SQL for INSERT OR UPDATE don't handle the column as readonly. If you set UpdateAllFields to true an exception is raised. Also an exception occurs when you change the value of this field an call Post.
The column should be set to readonly an the corresponding field should be excluded from INSERT andUPDATE.
3 votes -
Export SQL from Query component with values of the parameters
When you need to debug some SQL, you can save the SQL query to a file and then run it outside of your application to check for any issues with the query. However, you cannot do the same when using parameters. When you try to save SQL.Text to a file, you will get the query with parameter names, such as SELECT * FROM A WHERE Id = :paramname. To debug effectively, I need to see the values of the parameters. Ideally, I want to save the query with the actual parameter values, like SELECT * FROM A WHERE ID =…
3 votes -
Implementing OpenDatasets in Direct mode
Procedure TCustomMSConnection.OpenDatasets doesn't work with Direct mode (MSConnection.Options.Provider := prDirect) but works with ODBC or SQL Native Client provider. I suggest implementing it in Direct mode.
3 votes
- Don't see your idea?