44 results found
-
Support open source free embedded database DuckDB
DuckDB is an open source free and very good embedded database, is it possible to fully embed DuckDB into delphi programs like SQLite, without external DLL files?
12 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 -
VirtualDAC Debug info shown in DBMonitor
Unlike other product such as ODAC, for virtualDAC, as now I am using VirutalQuery, if debug is set to true, it seems that dialog will be shown at each step, which make the debug in thread/service very difficult.
Is it possible, like TOraMonitor of ODAC, we have have sort of TVirtualDACMonitor for VirtualDAC, to push the debug information to dbmonitor, the same behavior as of other product family?
1 vote -
Add DBMonitor support for notifications
For debugging purposes we often add
raise notice '%', some_variable
which is handy because can give us back information without stopping the app like 'warning' or 'exception' would.It would be great if DBmonitor could catch such notice and show somehow.
1 vote -
pass fetch duration to DB Monitor
db Monitor has fetch checkbox that is useless at the moment.
It would be nice if the fetch time would be sent to the db monitor1 vote -
dbMonitor needs an upgrade, adding some basic common sense functionality
It's about time dbMonitor had a long awaited upgrade with some really basic common sense pieces of functionality added.
1) Add buttons to clear terminated processes and all processes. Come on guys, having to select each process one by one to clear it is, quite frankly, ridiculous and poor UI design.
2) Parameters should be formatted according to the DB you're connected to.
E.g. for Oracle
Like this...
:SrcSchema VARCHAR2(13) :='MY_SCHEMA' ;rather than this
:SrcSchema(VARCHAR[13])='MY_SCHEMA'
Why? Well it allows us developers to set up anonymous blocks quickly to test the same call, if say an error occurs. Currently I…1 vote -
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 -
Adding 'Persistent Indexes' to the TVirtualTable
Could you consider to add the 'Persistent Indexes' to the TVirtualTable ?
In this case the table could be have a few indexes. Inserting/deleting records will modify all indexes. The searching data will use existing indexes without recreating them. Something like in DBF files with several *.ndx files. Before searching the presistent index will be chose by index name and searching will use this index.
At this moment it is possible to use only one index by setting the VirtualTable.IndexFieldNames property. Changing this property recreates the index, and for large table (>3000) takes time.
The 'Persistent Indexes' are used in…
7 votes -
CodeTyphon compatability.
Would love to see the DevArt components have compatibility for CodeTyphon (FPC/Lazarus fork) as well as instructions for installing/compiling.
12 votes -
Internal Calc fields
Support for InternalCalc fields. This is really usefull feature. And is supported by FireDac and ClientDataset.
5 votes -
Fix TMyDump
TMyDump.Backup() writes all Views in alphabetical order. However, if there are inter-joins among Views the database may not be restored, as the Views must be restored according to their dependencies.
I strongly suggest fixing TMyDump.Backup. The algorithm should analyze the dependencies among Views and account for the correct order of joins.
1 vote -
sql monitor: support query execution
It would be helpful in the SQL Monitor to execute the query I'm seeing to see the result set my app receives.
Sometimes I have to check something where the client is and I place the sql monitor to see, what SQL my app is sending and have to enter with a db explorer to check the sql with the parameters sent, what the result is. It would be cool, if the dbmon could have that built in, because the dbmon already has the sql and the params right there.This would often make my work much easier
1 vote -
SqlMonitor : No "...monitoring is started/finished" event
When I create a SqlMonitor but with Active := False the component or unit is sending a string to the monitor to say, that it has started, although it's inactive.
Now imagine that with some 50 or 100 clients and you want to check the SQL of 1 certain workstation.Couldn't that be turned off ?
1 vote -
13 votes
-
Green tick mark for answered queries?
Perhaps it's an idea to have an indicator on each specific post to show whether a topic has been answered?
This could be as simple as a check box indicating the post has been answered - filled in by the original requester when the requester is happy with the response(s).
Once the tick box is completed the post could be flagged with an icon - e.g. a green tick mark - and thus considered 'closed'.
Would help responders to skip those posts already answered and those wishing to find answers to skip those posts that have not yet been answered.…1 vote -
unidump
When using mySQL as the provider it is possible to add drop and create table statements to the "backuptofile"-file. This option is not possible when using the Microsoft SQL server provider. Could you please add this option ? :-)
12 votes -
Make CachedUpdates work on master-detail datasets without requiring LocalMasterDetail
Scenario: 100K customer (master rows) with an average of 10 contact (detail) rows each... totaling about 1M detail rows.
Without CachedUpdates I set LocalMasterDetail to false, and each time I scroll on the master dataset UniDAC fetches the 10 or so detail rows from the database. I can insert, modify and delete rows and all is saved immediately (on Delete or Post).
With CachedUpdates I have to set LocalMasterDetail to true. This means UniDAC will fetch 1M detail rows and filter them out locally. With large networked databases this is really not feasible as it generates too much network traffic…
3 votes -
dbMonitor -- update/insert/delete statements should be reflected in UpdateTransaction
if you apply two different transaction in TIBCQuery.Transaction and TIBCQuery.UpdateTransaction property, then dbMonitor will show update/insert/delete statements in TIBCQuery.Transaction branch.
Actually it should be shown in TIBCQuery.UpdateTransaction branch
RUS
Если вы применяете две различных транзакции в свойствах TBCQuery.Transaction и TIBCQuery.UpdateTransaction то dbMonitor показывает выражения update/insert/delete в ветке транзакции TBCQuery.Transaction.
Однако хотелось бы видеть в ветке TIBCQuery.UpdateTransaction3 votes -
More Features in TCRBatchmove - Events on errorr
Add Events in TCRBatchmove to react if an error occurs.
2 votes -
Add properties KeepAlive + KeepAliveInterval (maintain the connection)
The component should TUniConnection every 3000 ms (for example) to send to the server any single request (for example, "select 1 from dual"), to the gateway and the server is "seen" that the connection is active and the client is connected.
RUS:
Компонента TUniConnection должна, каждые 3000 мс (к примеру) отправлять на сервер какой-нибудь холостой запрос (к примеру, "select 1 from dual"), чтобы шлюз и сервер "видел", что соединение активно и клиент подключен.Сообщение на форуме: http://www.devart.com/ru/forums/viewtopic.php?p=2081#2081
69 votes
- Don't see your idea?