Recent

Author Topic: What is a .DB file (SOLVED)  (Read 8554 times)

1HuntnMan

  • Sr. Member
  • ****
  • Posts: 278
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
What is a .DB file (SOLVED)
« on: September 25, 2023, 03:36:53 pm »
Hi all!
Hoping someone may have an answer to this. I was a programmer back in the 1980's & early 1990's developing database software for the personnel placement industry. I wrote software first in Clipper then migrated to Delphi 5 and the Delphi 7.
I'm old so can't remember well but converting a system I wrote in Delphi 7 to a Photo Mgt. Tracking System. My issue is that I would like to convert some of the data files from back then to TDBF or SQL-Lite.  The database files have extensions of .DB, .PX, .XG0, .XG1, .YG0, YG1 and .MB.  Would anyone know how to access these types of files? I assume the .DB files is the database file and the others (.XG0, YG1, etc.) are index definitions.
I'm only interested in the data structures not the data...
Tks anyone!
Donald
« Last Edit: November 29, 2023, 11:09:51 pm by 1HuntnMan »

Zvoni

  • Hero Member
  • *****
  • Posts: 2744
Re: What is a .DB file
« Reply #1 on: September 25, 2023, 03:42:30 pm »
I'd first try to open those files with a DBF-FileViewer-Tool (whichever one). --> https://dbeaver.io/about/
Just to make sure, that it is a valid DBF
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

alpine

  • Hero Member
  • *****
  • Posts: 1302
Re: What is a .DB file
« Reply #2 on: September 25, 2023, 03:43:03 pm »
Paradox DB?
"I'm sorry Dave, I'm afraid I can't do that."
—HAL 9000

Zvoni

  • Hero Member
  • *****
  • Posts: 2744
Re: What is a .DB file
« Reply #3 on: September 25, 2023, 03:55:49 pm »
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

dseligo

  • Hero Member
  • *****
  • Posts: 1412
Re: What is a .DB file
« Reply #4 on: September 25, 2023, 03:58:23 pm »
Paradox DB?

I also think it is Paradox.
Delphi included Database Desktop application for managing tables and data. There was also BDE Admin tool.

OP is correct about extensions: In .db files was data, .px was primary index, and if I recall correctly in .mb files was BLOB's and large texts.

alpine

  • Hero Member
  • *****
  • Posts: 1302
Re: What is a .DB file
« Reply #5 on: September 25, 2023, 04:06:16 pm »
Paradox DB?

I also think it is Paradox.
Delphi included Database Desktop application for managing tables and data. There was also BDE Admin tool.

OP is correct about extensions: In .db files was data, .px was primary index, and if I recall correctly in .mb files was BLOB's and large texts.
Then maybe DBeaver https://github.com/dbeaver/dbeaver/wiki/Database-drivers combined with a jdbc driver https://github.com/leonhad/paradoxdriver ?
"I'm sorry Dave, I'm afraid I can't do that."
—HAL 9000

Zvoni

  • Hero Member
  • *****
  • Posts: 2744
Re: What is a .DB file
« Reply #6 on: September 25, 2023, 04:08:31 pm »
Paradox DB?
Isn't Paradox a SubSet of DBase?
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

alpine

  • Hero Member
  • *****
  • Posts: 1302
Re: What is a .DB file
« Reply #7 on: September 25, 2023, 05:05:04 pm »
Paradox DB?
Isn't Paradox a SubSet of DBase?
Nope. They were competing products, Borland acquired them both circa 1992.
"I'm sorry Dave, I'm afraid I can't do that."
—HAL 9000

1HuntnMan

  • Sr. Member
  • ****
  • Posts: 278
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
Re: What is a .DB file
« Reply #8 on: September 25, 2023, 05:06:16 pm »
I guess that they are Paradox.  I've tried opening a few of the .DB files with Access, Excel, DBF Manager, Note++, etc.  None will open them except NotePad++.  But, I designed these systems with Delphi 7 and can't remember what tool I used to create the data files. It wasn't Paradox, I have never used Paradox and never had it on any of my computers back then.
I'm giving up on this, not that important.  I was just interested in the data structures, not the data.  I'm just going to design this system with dbase or SQLite.  This app isn't meant to be a multi-user system for a company or lots of users. I'm just building this little app for a friend who is a fellow photographer for use by him and other photographers who may want to use it to track their photography endeavors whether they photograph weddings, landscapes, street scenes, etc., etc.
Tks all for sharing and have great week, life is good if you make it so...
Donald aka 1HuntnMan
PS: I attempted to attach a small Contacts.DB file and Lazarus doesn't allow, Hello, LOL!

marcov

  • Administrator
  • Hero Member
  • *
  • Posts: 11944
  • FPC developer.
Re: What is a .DB file
« Reply #9 on: September 25, 2023, 05:13:08 pm »
Copy it onto a Linux system and use the "file" command on it.

alpine

  • Hero Member
  • *****
  • Posts: 1302
Re: What is a .DB file
« Reply #10 on: September 25, 2023, 05:39:21 pm »
I'm just going to design this system with dbase or SQLite.
SQLite strongly recommended.

Besides, it will be quite easy I guess for somebody with DataDesktop installed to dump for you the db schema of the files. IMO a lot of people keep the Delphi7 at hand.
"I'm sorry Dave, I'm afraid I can't do that."
—HAL 9000

wp

  • Hero Member
  • *****
  • Posts: 12464
Re: What is a .DB file
« Reply #11 on: September 25, 2023, 06:54:56 pm »
On my github you can find a "ParadoxViewer" which uses the TParadoxDataset from the Lazarus Code and Component Repository (the needed unit is included in the Paradoxviewer - no need to install anything). Besides viewing Paradox files you can also export them to sqlite3. (But note that the program is not heavily tested, I considered it mainly as a test bed for TParadoxDataset)
« Last Edit: September 25, 2023, 06:59:49 pm by wp »

1HuntnMan

  • Sr. Member
  • ****
  • Posts: 278
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
Re: What is a .DB file
« Reply #12 on: September 25, 2023, 09:41:02 pm »
WP,
   First of all, thanks for your reply!  Okay, I'll download the "Paradox Viewer" you mentioned and give it a try. I must of been using some tool in Delphi 7 to create these data files. It's been years since I programmed.  This old system was a Membership Mgt. system for Realtors I programmed back in 1997.  If the Paradox Viewer works or not, I'll get back to you.

Take care,
Donald aka 1HuntnMan

wp

  • Hero Member
  • *****
  • Posts: 12464
Re: What is a .DB file
« Reply #13 on: September 25, 2023, 11:17:31 pm »
no need to install anything
Sorry - this is not quite correct because the sqlite3 export requires the corresponding dlls. If you don't have them get them from https://www.sqlite.org/download.html. Choose the correct bitness! Assuming that you are on windows, if your Lazarus is 64 bit, choose https://www.sqlite.org/2023/sqlite-dll-win64-x64-3430100.zip, in case of 32-bit you need https://www.sqlite.org/2023/sqlite-dll-win32-x86-3430100.zip. Unpack the download into the folder which contains the exe file of the paradox viewer. (Or if you are brave, unzip the 64-bit download into c:\windows\system32, and the 32-bit download into c:\windows\syswow64 - the exchanged "32" and "64" are not typos!)

1HuntnMan

  • Sr. Member
  • ****
  • Posts: 278
  • From Delphi 7 to Lazarus
    • NewFound Photo Art
Re: What is a .DB file
« Reply #14 on: October 03, 2023, 03:19:08 pm »
I figured this all out. I can load all or any of these .DB files that I used for all my old Delphi 7 apps with a small app called Paradox Editor.  But, read ing several Lazarus Tutorials, I've seen a image of the Data Access components that included Paradox. But, I have the latest version of Lazarus and that component isn't installed in the Data Access tab. So, found the component for Paradox but can't install it, doing something wrong. If anyone knows any documentation on how to do this properly, please let me know.
Tks in advance, Donald aka 1HuntnMan

 

TinyPortal © 2005-2018