For SQLite, there is a magic key (actual value: SQLite format 3\\000), but in other dbs ?
BTW: is it possible (like with SQLite) to create local DB files with PostGreSQL and other Xojo built-in Data Bases ? (if so, I can explore closely their files) ?
@Emile Schwarz Well only SQLite databases have a single file for the whole database. Other databases can be spread over several locations (foldersà and you should not attempt to access them!
[quote=453241:@Emile Schwarz] or How do I get the data base kind from the file (name, something else) ?
I can deduce that information from the SQLite file extension (if set to .sqlite, otherwise I do not know).
[/quote]
None of my sqlite databases has any extension at all.
There are even people who change the file extentions claiming they change the kind of file (from avi to moov; do not laugh, I heard it !).
That said, I created my file extension for sqlite db data file 6,5 years ago (bad idea).
My Lenovo (bouhhhhh) laptop never display any file extension in 4 years (then gone to repair and comes back (from factory plant) with broken Touch Screen: I will never brought anything from them anymore !