-
Sep 26th, 2022, 11:05 AM
#1
Thread Starter
Hyperactive Member
adtg ado database
recently seen a post that used an adtg ado database and looked interesting.
then i tried to find an app that i could use to view or edit these files but only found a mention to Visual Studio Code? Anyone know if any free specfic app that can edit these files.
i usually use mdb files so store data , but would using adtg file use less resources, is quicker etc.
i am looking to store a few fields ie Filename, DirFolder , Hash , DateTaken so nothing complex.
Is there any benefit to using adtg rather than mdb
tks
-
Sep 26th, 2022, 11:11 AM
#2
Re: adtg ado database
VSCode is free... don't confuse it with Visual Studio... they are not the same thing. Download and install VSCode, find and install an appropriate extension, and you should be good to go from there.
-tg
-
Sep 26th, 2022, 11:25 AM
#3
Thread Starter
Hyperactive Member
Re: adtg ado database
Originally Posted by techgnome
VSCode is free... don't confuse it with Visual Studio... they are not the same thing. Download and install VSCode, find and install an appropriate extension, and you should be good to go from there.
-tg
unfortunatley i dont see an extension that i could use.
on the url https://filenp.com/extension/adtg it just says Microsoft Visual Studio. i must have put code at the end by mistake.
I dont really want to install Microsoft Visual Studio. Is there anything else that can edit these files.
tks
-
Sep 26th, 2022, 12:36 PM
#4
Re: adtg ado database
ADTG is a persistence format supported by ADO Recordsets. You can also use the bulkier plain-text XML format that it has as an alternative.
Since many Providers don't support persisted Recordsets you might have to use the Cursor Service (client-side cursor, adUseClient) instead of an actual database connection (adUseServer). For fabricated Recordsets with no active Connection at all you of course have to use the Cursor Service.
See the ADO documentation. There is information under the Recordset's Save and Open methods as well as elsewhere there.
At least that's what I think you may mean by "adtg ado" above.
This might be more compact than MDB files for simple stuff but it has limitations. No SQL query support, no constraints or indexes or defaults or expressions or grouping or aggregations or relations (and on and on). There are also techniques you need to apply after updates to apply pending changes that involve Update and UpdateBatch calls.
After opening a saved Recordset you can also use Field objects' "Optimize" dynamic property (in its Properties collection) to establish a temporary index to make Filter, Find, Sort quicker for large Recordsets.
Most of the best information isn't hosted by Microsoft any more. A lot of it is included in the October 2001 MSDN CD documentation. There also used to be a series of books and powerpoints by Rob MacDonald of Microsoft back 20+ years ago. His "Disconnecting ADO or ADO Unplugged" was a quick overview of some of the features available.
-
Sep 26th, 2022, 12:37 PM
#5
Re: adtg ado database
What VSCode might have to do with this escapes me completely.
-
Sep 26th, 2022, 01:37 PM
#6
Re: adtg ado database
Originally Posted by k_zeon
... found a mention to Visual Studio Code? Anyone know if any free specfic app that can edit these files....
Originally Posted by dilettante
What VSCode might have to do with this escapes me completely.
the original post mentioned Visual Studio Code - VSCode ... so I thought he had found something that said it could be done but was resisting to do so. Sounds like it was a case of miscommunication.
-tg
-
Sep 26th, 2022, 03:00 PM
#7
Re: adtg ado database
Or maybe my wild guess was way off.
-
Sep 27th, 2022, 01:41 AM
#8
Thread Starter
Hyperactive Member
Re: adtg ado database
Originally Posted by dilettante
ADTG is a persistence format supported by ADO Recordsets. You can also use the bulkier plain-text XML format that it has as an alternative.
Since many Providers don't support persisted Recordsets you might have to use the Cursor Service (client-side cursor, adUseClient) instead of an actual database connection (adUseServer). For fabricated Recordsets with no active Connection at all you of course have to use the Cursor Service.
See the ADO documentation. There is information under the Recordset's Save and Open methods as well as elsewhere there.
At least that's what I think you may mean by "adtg ado" above.
This might be more compact than MDB files for simple stuff but it has limitations. No SQL query support, no constraints or indexes or defaults or expressions or grouping or aggregations or relations (and on and on). There are also techniques you need to apply after updates to apply pending changes that involve Update and UpdateBatch calls.
After opening a saved Recordset you can also use Field objects' "Optimize" dynamic property (in its Properties collection) to establish a temporary index to make Filter, Find, Sort quicker for large Recordsets.
Most of the best information isn't hosted by Microsoft any more. A lot of it is included in the October 2001 MSDN CD documentation. There also used to be a series of books and powerpoints by Rob MacDonald of Microsoft back 20+ years ago. His "Disconnecting ADO or ADO Unplugged" was a quick overview of some of the features available.
OK, tk for the info. as i mentioned in previous post, i did say Visual Studio Code, but that was a mistake, it should have read Visual Studio.
think i may just stick with access db
-
Sep 27th, 2022, 02:05 AM
#9
New Member
Re: adtg ado database
I think adtg will be benefited.
-
Sep 27th, 2022, 07:53 AM
#10
Thread Starter
Hyperactive Member
Re: adtg ado database
Originally Posted by Mst Rima Khatun
I think adtg will be benefited.
if only there was an app that i could edit these files with like access then i probably would for simple 1 table records.
-
Sep 27th, 2022, 08:24 AM
#11
Re: adtg ado database
What do you mean with 1 table records?
And what is your goal?
-
Sep 27th, 2022, 09:21 AM
#12
Thread Starter
Hyperactive Member
Re: adtg ado database
Originally Posted by Arnoutdv
What do you mean with 1 table records?
And what is your goal?
so i have made an app to backup image files based on metadata. I have thousands.
I want to create create a record of all the images that i have copied to a new location based on the metadata
and still keep the origonals.
Next time i run a scan on a folder, i want the ones in the database to either not show in the list or show them as marked as processed.
At the moment, i am still getting the info from each origonal image and extracting the meta data and then comparing the filename with the new location
I am also looking at hashing the image and also storeing this info.
that way i can check by a filename or Hash against a file that potentially already exists.
I think comparing a filename with a database entry will be quicker that extracting said meta data and comparing the final filename
something like
C:\Origonal Images\pic12345.jpg to D:\Image Library\2022\1.January\pic12345 (22-01-2022 14-22-13).jpg
once i have run a scan to detect new or unprocessed images , will copy the unprocessed images to the Image Library.
hope it makes sense
-
Sep 27th, 2022, 09:35 AM
#13
Re: adtg ado database
The why not just use an MDB file (aka an MS Access file)?
-
Sep 27th, 2022, 11:24 AM
#14
Thread Starter
Hyperactive Member
Re: adtg ado database
Originally Posted by Arnoutdv
The why not just use an MDB file (aka an MS Access file)?
that was one of my initial questions.
What would be better to use. adtg or mdb and why?
Which would be more efficient and use less resources.
Would i need any drivers pre installed to use adtg or it just works.
with MSAccess , it would need office installed to work.
these were some of the questions.
but i will use MDB as my app is possibly only for me to use. tks
-
Sep 27th, 2022, 12:13 PM
#15
Re: adtg ado database
For MDB files you only need a reference to ADO, Access is not needed at all
-
Sep 27th, 2022, 01:45 PM
#16
Re: adtg ado database
Well, you need ADO or DAO. But you also need the database engine and its satellite IISAMs and other bits and bobs. However the Jet 4.0 pieces, just like ADO, have been part of Windows for a very long time.
ACE is another story. The MS Office johnnies created that as a private label extended version of Jet. No version of the ACE bits come preinstalled in any version of Windows.
Jet itself is independent of MS Access, and indeed letting Access touch a clean Jet MDB causes useless private crud to be inserted that you don't want or need.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|