Profile cover photo
Profile photo
Dan McGhan
423 followers
423 followers
About
Posts

Post has attachment
Working with Oracle Database 12.2+ and need to generate JSON with PL/SQL? You'll want to make friends with the new JSON types! 🤗 https://jsao.io/2018/11/relational-to-json-with-pl-sql/
Photo
Photo
11/5/18
2 Photos - View album
Add a comment...

Post has attachment
Just posted an update to my series on converting relational data to JSON. This one covers @OracleDatabase 12.2+ SQL! https://jsao.io/2018/10/relational-to-json-with-sql/ … Next up: 12.2+ PL/SQL... #json
Add a comment...

Post has attachment
New post: "Creating a REST API: Module Based Pagination, Sorting, and Filtering" https://jsao.io/2018/08/creating-a-rest-api-module-based-pagination-sorting-and-filtering/ See how a module can make these operations simple! :D #NodeJS #OracleDatabase
Add a comment...

Post has attachment
Part 5 of "Creating a REST API with #NodeJS and #OracleDatabase" is published! :D This part covers manual pagination, sorting, and filtering. https://jsao.io/2018/08/creating-a-rest-api-manual-pagination-sorting-and-filtering/ That's the last "core" post in the series, but I have many follow-up posts planned! 👍
Add a comment...

Post has attachment
Part 4 of "Creating a REST API with #nodejs and #OracleDatabase" is now available. It covers implementing POST, PUT, and DELETE request on the "employees" API endpoint: https://jsao.io/2018/04/creating-a-rest-api-handling-post-put-and-delete-requests/
Add a comment...

Post has attachment
Part 3 of my series on creating a REST API with #nodejs and #oracledatabase is now available. It covers creating routing, controller, and database logic to handle a GET request on an "employees" API endpoint: https://jsao.io/2018/04/creating-a-rest-api-handling-get-requests/
Add a comment...

Post has attachment
📣 New series: Creating a REST API with #nodejs and #oracledatabase https://jsao.io/2018/03/creating-a-rest-api-with-node-js-and-oracle-database/ Will cover web server & database basics as well as handling GET/PUT/POST/DELETE requests and more.
Add a comment...

Post has attachment
+Matthias Brantner with Oracle Labs recently demonstrated an experimental feature, Multilingual Engine (MLE), that allows JavaScript to be executed in Oracle Database:

https://www.youtube.com/playlist?list=PL_lVOJzXeE_8UwipLqfu6vKnOYDF3ITaI

Demos include:

* JavaScript Module as UDF in SQL
* SQL Driver for JavaScript in Oracle Database
* Sequelize ORM in Oracle Database
* JavaScript Based Aggregate Function in SQL

Visit this page to get more info, download a VM that includes a DB + MLE, and provide feedback via the MLE Community: http://www.oracle.com/technetwork/database/multilingual-engine/overview/index.html
PhotoPhotoPhoto
10/9/17
3 Photos - View album
Add a comment...

Post has attachment
Need to version data for what-if analysis, auditing (valid time), or other purposes? 👀 my talk on Oracle Database Workspace Manager! https://www.youtube.com/watch?v=NJlpIz1Xu_g
Add a comment...

Post has attachment
Add a comment...
Wait while more posts are being loaded