is it possible to SQL query the Essential PIM database file
Moderators: TerryRogers, Max
is it possible to SQL query the Essential PIM database file
Hi ,
I would like to know whether it is possible to SQL query the database file using firebird software independently out of Essential PIM ?
Of course I need to know the tables structure or the schema inside this file. Will you will be willing to give us this schema of tables at least for the email section of it, to enable us to query it independently ?
I have no problem of signing an NDA. I have an 80 GB of office data now - all of which is just email from before 2012. Hence I wish to experiment with SQL on this file and if it crashes in the future be able to retrieve data this way.
Please let me know.
--
Sincerely,
Surya, India
I would like to know whether it is possible to SQL query the database file using firebird software independently out of Essential PIM ?
Of course I need to know the tables structure or the schema inside this file. Will you will be willing to give us this schema of tables at least for the email section of it, to enable us to query it independently ?
I have no problem of signing an NDA. I have an 80 GB of office data now - all of which is just email from before 2012. Hence I wish to experiment with SQL on this file and if it crashes in the future be able to retrieve data this way.
Please let me know.
--
Sincerely,
Surya, India
-
- Site Admin
- Posts: 15603
- Joined: Thu Nov 25, 2004 3:12 am
- Has thanked: 1412 times
- Been thanked: 984 times
Re: is it possible to SQL query the Essential PIM database file
It is possible, please check the following topic for more info: viewtopic.php?t=10650
Android version of EssentialPIM. Keep all your data in sync!
Re: is it possible to SQL query the Essential PIM database file
Hi,
Thank you for the pointer. But I did not find a clear answer. Did you make a documentation on the database design or an API to access it. if it is now made given that so many evinced interest in that thread in 2011-12, can you please point me to that direction.
Sorry if I have missed it and am asking you to point at it again in that thread.
--
Sincerely,
Surya@India
Thank you for the pointer. But I did not find a clear answer. Did you make a documentation on the database design or an API to access it. if it is now made given that so many evinced interest in that thread in 2011-12, can you please point me to that direction.
Sorry if I have missed it and am asking you to point at it again in that thread.
--
Sincerely,
Surya@India
-
- Site Admin
- Posts: 15603
- Joined: Thu Nov 25, 2004 3:12 am
- Has thanked: 1412 times
- Been thanked: 984 times
Re: is it possible to SQL query the Essential PIM database file
There's no much interest apart from the one in the topic, so there's no additional progress. If you have some specific questions, please feel free to ask.
Android version of EssentialPIM. Keep all your data in sync!
-
- Guru
- Posts: 187
- Joined: Sun May 08, 2016 8:39 am
- Has thanked: 1 time
- Been thanked: 30 times
Re: is it possible to SQL query the Essential PIM database file
We use an old copy of RazerSQL to interact directly with the EPIM database.
Newer copies of RazerSQL could work. We've just moved entirely over to Heidi SQL for everything else and only keep the old copy of RazerSQL around for EPIM. (RazerSQL is $100 per user per year. It's not a subscription so after the year you keep the old version you paid for, thus why we keep an old version of it around for EPIM but use Heidi for everything newer.)
Newer copies of RazerSQL could work. We've just moved entirely over to Heidi SQL for everything else and only keep the old copy of RazerSQL around for EPIM. (RazerSQL is $100 per user per year. It's not a subscription so after the year you keep the old version you paid for, thus why we keep an old version of it around for EPIM but use Heidi for everything newer.)
- ecsaltz
- Guru
- Posts: 644
- Joined: Fri Jul 18, 2008 12:14 pm
- Location: Durham, North Carolina, USA
- Has thanked: 30 times
- Been thanked: 77 times
Re: is it possible to SQL query the Essential PIM database file
Is there any reason for not using Heidi SQL for EPIM? I'm asking as I just starting to investigate a SQL front end for EPIM for occasional inqeury use.Rose Ford wrote: ↑Thu Mar 23, 2023 12:16 am We use an old copy of RazerSQL to interact directly with the EPIM database.
Newer copies of RazerSQL could work. We've just moved entirely over to Heidi SQL for everything else and only keep the old copy of RazerSQL around for EPIM. (RazerSQL is $100 per user per year. It's not a subscription so after the year you keep the old version you paid for, thus why we keep an old version of it around for EPIM but use Heidi for everything newer.)
PC Desktop: Window 11 Pro, 34 inch 4K monitor.
Cell phone: Verizon Wireless Samsung Galaxy S22 Ultra, Android 12 - linked with Garmin Fenix 6 Pro wrist watch and Fitbit Sense wrist watch.
Cell phone: Verizon Wireless Samsung Galaxy S22 Ultra, Android 12 - linked with Garmin Fenix 6 Pro wrist watch and Fitbit Sense wrist watch.
Re: is it possible to SQL query the Essential PIM database file
Ok, can you at least post the Database model with or without the views, implemented in the backend database file so that I can use that to query.
--
Surya@India
--
Surya@India
-
- Guru
- Posts: 187
- Joined: Sun May 08, 2016 8:39 am
- Has thanked: 1 time
- Been thanked: 30 times
Re: is it possible to SQL query the Essential PIM database file
Heidi SQL only supports firebird 3x and 4x well.
EPIM runs on 2x
It's worth noting 2.5 support ended in 2019 and by that time it was already fairly unpopular as most people had moved to version 3 that came out in 2016.
- ecsaltz
- Guru
- Posts: 644
- Joined: Fri Jul 18, 2008 12:14 pm
- Location: Durham, North Carolina, USA
- Has thanked: 30 times
- Been thanked: 77 times
Re: is it possible to SQL query the Essential PIM database file
Thanks, Rose. Any recommendations for current free/low cost SQL that would work with EPIM?
PC Desktop: Window 11 Pro, 34 inch 4K monitor.
Cell phone: Verizon Wireless Samsung Galaxy S22 Ultra, Android 12 - linked with Garmin Fenix 6 Pro wrist watch and Fitbit Sense wrist watch.
Cell phone: Verizon Wireless Samsung Galaxy S22 Ultra, Android 12 - linked with Garmin Fenix 6 Pro wrist watch and Fitbit Sense wrist watch.
-
- Site Admin
- Posts: 15603
- Joined: Thu Nov 25, 2004 3:12 am
- Has thanked: 1412 times
- Been thanked: 984 times
Re: is it possible to SQL query the Essential PIM database file
surya, you can create a new EPIM db file and then open it with a suitable SQL editing tool (Interbase Query, for instance) to get a database model and its structure. Hope that's what you were looking for.
Android version of EssentialPIM. Keep all your data in sync!
Re: is it possible to SQL query the Essential PIM database file
I got the following error on trying to use the software you suggested. I also posted the first opening screen below. Please let me know where I am going wrong.
Please let me know where I am going wrong.
--
Sincerely,
Surya@India
Please let me know where I am going wrong.
--
Sincerely,
Surya@India
-
- Site Admin
- Posts: 15603
- Joined: Thu Nov 25, 2004 3:12 am
- Has thanked: 1412 times
- Been thanked: 984 times
Re: is it possible to SQL query the Essential PIM database file
I guess this is more of a question for the software author. My assumption would be that the error has something to do with the Firebird server version. You can click on Help->About and check which Firebird version is mentioned as the "Client".
Android version of EssentialPIM. Keep all your data in sync!
-
- Site Admin
- Posts: 15603
- Joined: Thu Nov 25, 2004 3:12 am
- Has thanked: 1412 times
- Been thanked: 984 times
Re: is it possible to SQL query the Essential PIM database file
It should be 2.5.
Android version of EssentialPIM. Keep all your data in sync!