Microsoft Azure Blob Storage

Questions and answers regarding general SQL and backend databases

Microsoft Azure Blob Storage

Postby rafig » Fri Feb 24, 2017 1:51 pm

Hi
I have a client that requires me to use Azure Blob Storage for all 'media' data types, so instead of having a 'media' column in a table to hold something like a photo or a file scan, I have to put the 'blob' into Azure Blob Storage.
I can't find a JDBC driver for this, as it is not a proper SQL backend database.
There does appear to be a way to do it using JSON
https://blogs.msdn.microsoft.com/tconte/2011/08/10/accessing-windows-azure-blob-storage-using-jquery/
but I was just wondering if anyone here had already done this and if so how?? (to save me reinventing the wheel)
Thanks
Rafi
Servoy Certified Developer
Image
rafig
 
Posts: 704
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK

Re: Microsoft Azure Blob Storage

Postby david » Fri Feb 24, 2017 8:25 pm

The link you reference is for moving media from a browser client directly to Azure. If you're in Servoy Web Client this is going to get messy in a hurry. If you're in ngClient I would implement one of the many Angular1 wrapper services out there (example: https://github.com/kinstephen/angular-azure-blob-upload). Smart client this route is out of the question.

For all of the clients, an alternate approach would be to upload blobs first to Servoy server with the usual Servoy functionalities and then using the http plugin on the server to get/post/update blobs to Azure. Finally, wrap your Azure code in headless client plugin code so these tasks are done async/non-blocking.

Azure REST api to go through from Servoy server: https://docs.microsoft.com/en-us/rest/a ... e-rest-api
David Workman, Kabootit

Image
Everything you need to build great apps with Servoy
User avatar
david
 
Posts: 1727
Joined: Thu Apr 24, 2003 4:18 pm
Location: Washington, D.C.

Re: Microsoft Azure Blob Storage

Postby rafig » Sun Feb 26, 2017 10:51 pm

Thanks David!
I will have a look in to those suggestions.
Servoy Certified Developer
Image
rafig
 
Posts: 704
Joined: Mon Dec 22, 2003 12:58 pm
Location: Watford, UK


Return to SQL Databases

Who is online

Users browsing this forum: Bing [Bot] and 5 guests