Giter VIP home page Giter VIP logo

sql2pgrest's Introduction

sql2pgrest

sql2pgrest allows you to convert standard SQL queries into PostgREST URLs.

Example

<div class="row">
    <div class="mb-3">
        <label for="queryInput" class="form-label">Enter your SQL query:</label>
        <textarea class="form-control" id="queryInput" rows="6"></textarea>
    </div>
    <div class="mb-3">
        <button type="button" name="convert2Postgrest" class="btn btn-primary" onclick="convertToPostgREST()">Convert!</button>
    </div>
    
    <div class="mb-3">
        <h3>PostgREST URI:</h3>
        <p id="pgUrl"></p>
    </div>
</div>
...
<script src="sql2pgrest.min.js"></script>
<script>
    function convertToPostgREST() {
        var data = document.getElementById('queryInput').value;
        result = sql2postgrest(data);
        if (result) {
            if (result.success) {
                log("SUCCESS: Query converted.", "success")
                document.getElementById("pgUrl").textContent=result.message;
            } else {
                log("ERROR: Unable to convert query.", "error")
                document.getElementById("pgUrl").textContent=result.message;
            }
        } else {
            log("things have gone badly for us.")
        }
    }
</script>

Contributions

This is by no means finished. There are a bunch of unsupported PostgREST operators, basic AF JSONB support, and this is the first thing I have ever written in JavaScript. Please help. Ta.

sql2pgrest's People

Contributors

cj13579 avatar

Stargazers

Nikola Markovic avatar

Watchers

 avatar Nikola Markovic avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.