databases/sqldeveloper 24.3.1.347.1826_3
Graphical tool for database development
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
a56b99c040- License
- FUTC
- Categories
- databases, java
- Package size
- 397231.0 KiB, 490104.5 KiB installed
Description
Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks.
SQL Developer can connect to any Oracle Database version >= 9.2.0.1 and MySQL database version >= 3.0.
Install
As a binary package — by origin, or by package name:
pkg install databases/sqldeveloper
pkg install sqldeveloperFrom the ports tree:
cd /usr/ports/databases/sqldeveloper/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= sqldeveloper>0:databases/sqldeveloperPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 24.3.1.347.1826_3 | 24.3.1.347.1826_3 | - | - | 24.3.1.347.1826_3 |
| FreeBSD:14:quarterly | 24.3.1.347.1826_3 | 24.3.1.347.1826_3 | n/a | - | 24.3.1.347.1826_3 |
| FreeBSD:15:latest | 24.3.1.347.1826_3 | 24.3.1.347.1826_3 | n/a | - | - |
| FreeBSD:15:quarterly | 24.3.1.347.1826_3 | 24.3.1.347.1826_3 | n/a | n/a | n/a |
| FreeBSD:16:latest | 24.3.1.347.1826_3 | 24.3.1.347.1826_3 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Runtime 2
openjfx14>=0: java/openjfx14bash: shells/bash
The full lists below include those, and their dependencies in turn.
All run dependencies 144
- accessibility/at-spi2-core
- archivers/brotli
- archivers/libdeflate
- archivers/liblz4
- archivers/lzo2
- archivers/zstd
- audio/alsa-lib
- audio/lame
- audio/libogg
- audio/libvorbis
- audio/mpg123
- audio/opus
- audio/sndio
- converters/fribidi
- converters/libiconv
- databases/gdbm
- databases/sqlite3
- devel/dbus
- devel/dbus-glib
- devel/gettext-runtime
- devel/glib20
- devel/gobject-introspection
- devel/gsettings-desktop-schemas
- devel/icu
- devel/json-glib
- devel/libdaemon
- devel/libdatrie
- devel/libedit
- devel/libepoll-shim
- devel/libevent
- devel/libffi
- devel/libgudev
- devel/libgusb
- devel/libinotify
- devel/libpciaccess
- devel/libthai
- devel/libudev-devd
- devel/libunistring
- devel/pcre2
- devel/py-packaging
- devel/py-setuptools
- devel/readline
- dns/libidn2
- graphics/cairo
- graphics/colord
- graphics/gdk-pixbuf2
- graphics/giflib
- graphics/graphite2
- graphics/gtk-update-icon-cache
- graphics/jbigkit
- graphics/jpeg-turbo
- graphics/lcms2
- graphics/lerc
- graphics/libdrm
- graphics/libepoxy
- graphics/libglvnd
- graphics/librsvg2-rust
- graphics/png
- graphics/tiff
- graphics/wayland
- graphics/webp
- java/javavmwrapper
- java/openjdk11
- java/openjdk17
- java/openjfx14
- lang/duktape-lib
- lang/python312
- lang/python315
- lang/tcl86
- math/gmp
- math/libtommath
- math/mpdecimal
- misc/hicolor-icon-theme
- misc/hwdata
- misc/shared-mime-info
- multimedia/aom
- multimedia/dav1d
- multimedia/ffmpeg4
- multimedia/libass
- multimedia/libv4l
- multimedia/libva
- multimedia/libvdpau
- multimedia/libvpx
- multimedia/libx264
- multimedia/svt-av1
- multimedia/vmaf
- multimedia/x265
- net/avahi-app
- print/cups
- print/freetype2
- print/harfbuzz
- print/indexinfo
- print/libpaper
- security/gnutls
- security/libgcrypt
- security/libgpg-error
- security/libtasn1
- security/nettle
- security/p11-kit
- shells/bash
The first 100 are listed.
No port depends on this one.
Configuration
No options to configure.
- USES
- gnome java zip
- Service scripts
- none
Message after installing
Note for Oracle users:
In order to connect in a simple way to an Oracle database, it is needed to
set ORACLE_HOME environment variable and then locate in a
$ORACLE_HOME/network/admin/ directory a valid tnsnames.ora services file.
Alternatively, you can set TNS_ADMIN to point out directly to that
tnsnames.ora file.
After that choose "TNS" as "Connection Type" when you are going to add a
new connection database.
Note for MySQL users:
If you have enabled mysql support, it is needed to point out to SQL
Developer where the MySQL JDBC classes are. Go to Tools -> Preferences
menu, select Database -> Third Party JDBC Drivers and add the proper jar.
Do not install 5.1 version of mysql jdbc connector; see
https://docs.oracle.com/en/database/oracle/sql-developer/18.4/rptig/installing-sql-developer.html#GUID-3F68CF20-D03D-431C-A9A2-0EB971F06448
Files
pkg-plist 2221
- bin/sqldeveloper
- share/applications/sqldeveloper.desktop
- share/icons/hicolor/32x32/apps/sqldeveloper.png
- share/sqldeveloper/configuration/bundles.info
- share/sqldeveloper/configuration/oracle.datamodeler.bundles.info
- share/sqldeveloper/configuration/oracle.ide.sqldev.bundles.info
- share/sqldeveloper/dataminer/demos/workflows/apply workflow.xml
- share/sqldeveloper/dataminer/demos/workflows/apply_workflow.xml
- share/sqldeveloper/dataminer/demos/workflows/build_workflow.xml
- share/sqldeveloper/dataminer/demos/workflows/codegen_workflow.xml
- share/sqldeveloper/dataminer/scripts/XMLSchema.xsd
- share/sqldeveloper/dataminer/scripts/alterDBRestrictSession.sql
- share/sqldeveloper/dataminer/scripts/alterDBUnRestrictSession.sql
- share/sqldeveloper/dataminer/scripts/alterUserDefaultRole.sql
- share/sqldeveloper/dataminer/scripts/alterscheduledworkflows.sql
- share/sqldeveloper/dataminer/scripts/checkEnvironment.sql
- share/sqldeveloper/dataminer/scripts/copyTablesFromBackupAccount.sql
- share/sqldeveloper/dataminer/scripts/copyTablesToBackupAccount.sql
- share/sqldeveloper/dataminer/scripts/createODMRSYST.sql
- share/sqldeveloper/dataminer/scripts/createuser.sql
- share/sqldeveloper/dataminer/scripts/createusersgrantbackup.sql
- share/sqldeveloper/dataminer/scripts/createxmlschemaindexes.sql
- share/sqldeveloper/dataminer/scripts/createxmlworkflowsbackup.sql
- share/sqldeveloper/dataminer/scripts/createxmlworkflowsbackup2.sql
- share/sqldeveloper/dataminer/scripts/dbHasSchema.sql
- share/sqldeveloper/dataminer/scripts/disconnectODMRSessions.sql
- share/sqldeveloper/dataminer/scripts/displayVersion.sql
- share/sqldeveloper/dataminer/scripts/dmsh.sql
- share/sqldeveloper/dataminer/scripts/dmshgrants.sql
- share/sqldeveloper/dataminer/scripts/dropDemoData.sql
- share/sqldeveloper/dataminer/scripts/dropODMRSYST.sql
- share/sqldeveloper/dataminer/scripts/dropPublicSynonyms.sql
- share/sqldeveloper/dataminer/scripts/dropRepository.sql
- share/sqldeveloper/dataminer/scripts/dropRepositoryAndUserObjects.sql
- share/sqldeveloper/dataminer/scripts/dropRole.sql
- share/sqldeveloper/dataminer/scripts/dropSHDemoData.sql
- share/sqldeveloper/dataminer/scripts/dropSchedulerObjects.sql
- share/sqldeveloper/dataminer/scripts/dropSchema.sql
- share/sqldeveloper/dataminer/scripts/dropUserTablesViews.sql
- share/sqldeveloper/dataminer/scripts/dropjsonschemagen.sql
- share/sqldeveloper/dataminer/scripts/dropusergrants.sql
- share/sqldeveloper/dataminer/scripts/fixjsonpaths.sql
- share/sqldeveloper/dataminer/scripts/instCarsDemoData.sql
- share/sqldeveloper/dataminer/scripts/instDemoData.sql
- share/sqldeveloper/dataminer/scripts/instInsurCustData.sql
- share/sqldeveloper/dataminer/scripts/instJSONSalesData.sql
- share/sqldeveloper/dataminer/scripts/instMiningDataText.sql
- share/sqldeveloper/dataminer/scripts/instSalesData.sql
- share/sqldeveloper/dataminer/scripts/instWikiSampleData.sql
- share/sqldeveloper/dataminer/scripts/install_scripts_readme.html
- share/sqldeveloper/dataminer/scripts/installodmr.sql
- share/sqldeveloper/dataminer/scripts/instgrants.sql
- share/sqldeveloper/dataminer/scripts/instmessages.sql
- share/sqldeveloper/dataminer/scripts/instmessages_de.sql
- share/sqldeveloper/dataminer/scripts/instmessages_en.sql
- share/sqldeveloper/dataminer/scripts/instmessages_es.sql
- share/sqldeveloper/dataminer/scripts/instmessages_fr.sql
- share/sqldeveloper/dataminer/scripts/instmessages_it.sql
- share/sqldeveloper/dataminer/scripts/instmessages_ja.sql
- share/sqldeveloper/dataminer/scripts/instmessages_ko.sql
- share/sqldeveloper/dataminer/scripts/instmessages_pt_br.sql
- share/sqldeveloper/dataminer/scripts/instmessages_zh_cn.sql
- share/sqldeveloper/dataminer/scripts/instmessages_zh_tw.sql
- share/sqldeveloper/dataminer/scripts/instobjects.sql
- share/sqldeveloper/dataminer/scripts/instodmrsys.sql
- share/sqldeveloper/dataminer/scripts/instpackages.sql
- share/sqldeveloper/dataminer/scripts/instscheduler.sql
- share/sqldeveloper/dataminer/scripts/instschema_g.sql
- share/sqldeveloper/dataminer/scripts/inststopwords.sql
- share/sqldeveloper/dataminer/scripts/instsynonyms.sql
- share/sqldeveloper/dataminer/scripts/insureWorkflowsInactive.sql
- share/sqldeveloper/dataminer/scripts/isBinaryMigrationAllowed.sql
- share/sqldeveloper/dataminer/scripts/isBinaryXMLMigrationAllowed.sql
- share/sqldeveloper/dataminer/scripts/isNewTableSpaceRequired.sql
- share/sqldeveloper/dataminer/scripts/loadjsonschemagen.sql
- share/sqldeveloper/dataminer/scripts/loadjsonschemagenWithSN.sql
- share/sqldeveloper/dataminer/scripts/migratebinaryodmr.sql
- share/sqldeveloper/dataminer/scripts/migrateodmrhelper.sql
- share/sqldeveloper/dataminer/scripts/odmr_constant_hdr.plb
- share/sqldeveloper/dataminer/scripts/odmr_constant_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_data_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_data_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_data_sec_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_data_sec_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_dynamic_node_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_dynamic_node_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_hdr.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_hdr.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_sec_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_sec_hdr.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_mining_sec_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_output_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_output_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_output_sec_body.plb
- share/sqldeveloper/dataminer/scripts/odmr_engine_output_sec_hdr.sql
- share/sqldeveloper/dataminer/scripts/odmr_engine_sec_body.plb
The first 100 are listed.
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| oracle/sqldeveloper-24.3.1.347.1826-no-jre.zip | 5.87604133e+08 | 3390ef58972f1f255077c49e66b171b8664773bb16e37570a7ca16acc5afb8cb |
Master sites 1
- https://download.oracle.com/otn_software/java/sqldeveloper/
Commit history 1
| Date | Commit | Credits | Log message |
|---|---|---|---|
a56b99c040 |
Vladimir Druzenko | databases/sqldeveloper: Upstream change license from OTN to FUTC Old license:
- Oracle Technology Network License Agreement for Business Operations
- https://www.oracle.com/downloads/licenses/sqldev-license.html
New license:
- Oracle Free Use Terms and Conditions (Oracle Free License)
- https://www.oracle.com/downloads/licenses/oracle-free-license.html
PR: 296773
Sponsored by: UNIS Labs
Co-authored-by: Ronald Klop <[email protected]>
MFH: 2026Q3 |