All geek questions in one place

Connect PHP to Paradox.db file on linux server

I have the following situation:

I need to integrate a website (php on a Linux server) with an old application (Delphi and Paradox (.db file) on Windows) I need to get data from the paradox database and display it on the website. I can get the .db file via FTP.

I don’t think I can install external libraries .

I did not find a command-line tool on the command line to convert from a .db file to mysql or any format that supports PHP. In addition, the Paradox database is updated daily.

Does anyone have a solution or advice or something else?

+4
source share
2 answers

I found a solution here to retrieve data from a .db paradox file without DBE.

Sincerely.

0
source

It is probably best to write a new standalone application for the Windows host, which is associated with both Paradox libraries and PostgreSQL libraries; make queries to the Paradox database and write data to the PostgreSQL database.

If you want to go halfway and write a tool that uploads the Paradox database to CSV format for subsequent import to the end of PostgreSQL, this can work too, but in CSV formats it’s quite a hassle, which makes the whole Paradox → PostgreSQL transition in one application seems to be the best for me.

+2
source

Source: https://habr.com/ru/post/1415021/

More articles:


All Articles