Feature Request: Re-enable Oracle for SQLPro Studio
choongjoey opened this issue · 15 comments
Is your feature request related to a problem? Please describe.
Re-enable Oracle for SQLPro Studio
Describe the solution you'd like
With Oracle finally releasing an instant client for Apple Silicon, would Oracle connections be re-enabled for SQLPro Studio Mac and iOS?
Describe alternatives you've considered
N/A
Additional context
https://www.oracle.com/database/technologies/instant-client/macos-arm64-downloads.html
Environment (please complete the following information):
- Device: [e.g. iPhone6, MacBook] iOS, macOS
- OS: [e.g. iOS8.1, macOS 11] iOS, macOS
- SQLPro app Version [e.g. SQLPro Studio 2022.x] SQLPro Studio 2024.x
- Installation source: [App Store, Website download, Setapp]. App Store
- Target database server [e.g. MySQL, PostgreSQL, Microsoft SQL Server, etc] Oracle
I'm investigating this now and seeing if it's something that can be done.
Thanks for looking into this. Oracle is the primary reason I purchased the tool. I am still running on a 2019 MacBook (Intel), but will be forced to an M3 MacBook in the next 3 months.
How has the investigation going into the new Oracle Instant Client for Apple Silicon?
Slowly! I SIP is what is currently slowing me down at the moment. Previously when I would build SQLPro for Oracle it was a system without SIP but in order to build/link the newer libraries on the newer system thats a bit more difficult. I also still need to figure out if I can combine the old libraries and the new libraries together so that I can still distribute SQLPro for both platforms, or if I no longer support older platforms. Not a decision I've made yet. So... slowly :)
Thank you for much for the feedback.
Just checking in to see if you are still making progress.
Happy New Year Kyle, is there any update for SQLPro for Oracle on Apple Silicon?
I'm hoping to re-visit this within the next month or so. What I tried before didn't work, so I've got to re-evaluate how to get them working.
I I'm getting closer. Just wondering, do you have access to an arm64 (apply m1-x) system as of yet?
One issue I'm seeing is that oracle libs are:
v23.1 for arm64 and
v19.1 for intel
Not positive if I can create a build that will work on system as of yet, meaning once I have an oracle build ready it may be arm64 only.
I will put in a ticket to our IT group requesting a loaner arm64 (probably an m3) with a explanation that I need to test software compatibility.
I just received a loaner M2 and would be happy to perform any tests.
Could you try:
https://sqlprostudio.s3.us-east-1.amazonaws.com/oracle/SQLProOracle.2025.1.app.zip
There are still a few issues.
- There is a crash sometimes when cancelling a query (or closing a tab while a query is running).
- It runs in hardened mode, but is not yet sandboxed. I'm having troubles getting sandboxed to build.
- arm64 only support.
I was able to install from the zip, SQLPro for Oracle 2025.1 [Build 593] on a MacBook Pro M2 Pro chip running Sequoia 15.2
Connected to my development and production Oracle 19c Enterprise databases.
I have tried various actions (just a few) and don't see any issues showing on the UI.
I would be happy to run various test cases and send the log file.
On my MacBook Pro 2019 Intel chip I am running SQLPro for Oracle 2023.81 (Build 581)
Thanks! My main issues at the moment are still the three mentioned here:
1. There is a crash sometimes when cancelling a query (or closing a tab while a query is running).
2. It runs in hardened mode, but is not yet sandboxed. I'm having troubles getting sandboxed to build.
3. arm64 only support.
I don't think there is anything specific from users that will help me out, but I will let you know if I come up with anything. I'm trying to work with one of the ocilib maintainers to figure out the crash and seeing if I can contact anyone at oracle for item 2. I will need to get both of the first items solved before I can post an App Store update.