Find Jobs
Hire Freelancers

Create a SQL Server CLR to store BLOBs outside the DB

$30-250 USD

In Progress
Posted almost 8 years ago

$30-250 USD

Paid on delivery
The project is to create a CLR that will automatically store BLOBs inserted to a table/view into Amazon S3 and retrieve them when selected. I am not looking to do this via stored procedure but instead handle this when data is inserted or retrieved from a table or view. The idea is that the query inserting and deleting is unaware that the BLOB is not actually stored in the DB and is not required to change its behavior. One idea to accomplish this is to create a view that when data is SELECTed from will select the BLOB data using a CLR function. When data is INSERTed an "instead of" trigger will fire and push the BLOB to S3 storage. It will then store the key in the underlying table. When data is UPDATED it will use the key from the table to update the blob in S3. If you have a better idea please let me know. To connect to S3 you can use Amazon's API: [login to view URL] in the CLR. We will need to load test this and compare performance for both INSERT and SELECT to regular BLOB storage to see what kind of speed and server performance impact this change has. We will also need to ensure it doesn't fail under load/stress. In order to be considered for this project you must mention in your bid text that you have read this description and provide a brief outline of how you plan to implement this project. Feel free to mention any relevant past experience. Good luck!
Project ID: 10358939

About the project

7 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
United States
4.5
25
Payment method verified
Member since May 18, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.