Giter VIP home page Giter VIP logo

cdb-manager's Introduction

CDB Manager

Installation

Just clone the repo and point your browser to the index.html file.

It is highly recommended that you test using a local web server (just run httpserv.py), instead of using file:/// URLs.

cdb-manager's People

Contributors

ajaest avatar danicarrion avatar iamwfx avatar marcus-gomes-v avatar pramsey avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

cdb-manager's Issues

Config file to load / export accounts

For those of us who use a bunch of different accounts simultaneously, having the option to upload a config file (such as the cartorc.yaml used in @jsanz 's carto-cli) would be really awesome.

Similary, being able to export your current accounts would also be a huge plus.

Not sure if this is limited somehow by #7

Tables don't show schema info

When I look at table info in the table browser, I cannot see the schema name the table is living in. (I currently have 450 dead tables in my importer schema I want to delete...)

Truncate or wrap the_geom in records tab

the_geom EWKT is super long... truncate and add an elipses or just indicate what type of vector it is and allow the user to expand it to view the EWKT if they want.

Add map widget to display query results

Results from the SQL Console will be displayed on a map widget. Each time a query is sent, the result is displayed as a layer. The map can be cleared anytime. Map can be hidden if not needed.

Also remove old viz.json and named map sections.

Add some high level descriptions for each tab

Most people will know what the SQL tab is for, but fewer may know what triggers, indices, and constraints are. While this is a tool for advanced users, there may be those in the middle who would benefit from some annotations on each tab explaining what they are/how to use them/what to expect

Avoid multiple accounts?

May I suggest that the app not support multiple accounts at once, at least to start? It adds a layer of complexity (the top tab bar) to a UI that is probably going to be pretty complex already. Start w/ one login, and later we can add the ability to have more than one and switch contexts quickly with a dropdown or somthing.

history browsing on mac

On Mac Chrome "Ctrl-Up / Ctrl-Down to browse history" does not work - the keystroke is for some mac special window management instead. So I could not find way to browse SQL history at all.

Control+Up doesn't work on Mac

Control+Up is trapped by OSX to fire a desktop selection thing so never gets to the browser (I think).

BTW a button to go up and down on the history (like on any browser) would be enough for me 😄 even yes, I can use the search bar.

Add way to see current running queries

Not sure if we want to make this public, but just discovered you can use the SQL API to see your own long running queries and terminate them.
As you presales guys are keen on running long queries 😛, it could be useful to have this.
It will only work to see the queries ran with the API key, though, not for the public_user used for read-only calls.

select * from pg_stat_activity where usename=current_user
and
select * pg_terminate_backend(pid)

You can only kill your own queries. Useful query to kill everything you have running:
select pg_terminate_backend(pid) from pg_stat_activity where usename=current_user

Autofill API URLs

The API end-point URLs form fields include text beneath with suggestions, but I have to copy and paste it in... can you just in-fill it for me?

Columns w/ identical names are dropped

In the SQL console table view.

select n.oid, n.nspname, c.oid, c.relname 
from pg_class c 
join pg_namespace n on c.relnamespace = n.oid 
where n.nspname != 'pg_catalog'

Add SELECT and CREATE queries to tables

When selecting a table, it'd be great to have the SELECT field1, field2, etc. statement and the CREATE TABLE myTable ( field1 type, field2 type, etc)

Those two queries are handy when you want to replicate the table or with tables with a large schema, you want to include a SELECT where you want to remove some of the fields.

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.