benson
Uploaded by
6 SLIDES
206 VUES
60LIKES

SQLShare: A Comprehensive API and Database Interface for Python and Web Development

DESCRIPTION

SQLShare integrates a powerful SQL database with various programming interfaces including Python, Perl, and C#. It supports both REST API and CLI for managing and querying database content efficiently. Users can access and manipulate datasets like employee records through simple SQL commands. The platform enables seamless integration with cloud environments like AWS and Azure, enhancing scalability and accessibility. Additional resources include a project page, documentation, and a Subversion repository for code access. Contact Patrick Michaud for inquiries and code-related questions.

1 / 6

Télécharger la présentation

SQLShare: A Comprehensive API and Database Interface for Python and Web Development

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

Playing audio...

  1. SQLShare CLI interface (Python) SQLShare Python Interface (Python) SQLShare UI (HTML/Javascript) SQLShare (Solstice, Perl, EC2) SQLShare REST API (C#, Web Role, Windows Azure) SQLShare Database (SQL Azure; SQL Server on EC2)

  2. Saved as: URL: ..REST/db/query/userX My employees SQL: SELECT * FROM Employees SQLShare (Solstice, Perl, EC2) JSON BODY sql_code: SELECT*FROMEmployees description: foo Is_public: false REST PUT QUERY METADATA sql_code: SELECT*FROM.. description: foo Is_public: false name: My Employees owner: userX SQLShare REST API (C#, Web Role, Windows Azure) SQLShare Database (SQL Azure) VIEW DEFINITION [userX].[My Employees]

  3. Links • Application http://sqlshare.escience.washington.edu • Project Page http://escience.washington.edu/sqlshare • Subversion Repository https://subversion.assembla.com/svn/sqlshare/

  4. Get the Code Subversion repository on Assembla https://subversion.assembla.com/svn/sqlshare/ trunk/ client/ server/ pythonclient/

  5. REST API • Partial implementations in Ruby, Python, Perl, C# • Contact me for code

  6. Dev environment • Amazon Machine Image • With Apache, code, etc. all installed • Ask me if you’re interested, and I’ll launch you an instance • Patrick Michaud (pmichaud@uw.edu) for other questions

More Related