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.
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.
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
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...)
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.
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.
Named maps are all shown on the same zoomed out map, do a query to get the bounds and zoom the map accordingly.
No errors in the JS console, but these warnings keep popping up in the GUI.
I know there is an option to change it, but the default should be 10 or 25 or 50.
The long ids are meaningless, the pretty names would be better in the list, with the id shown after selecting a map.
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
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.
So the intense queries are funneled and managed
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.
ORDER BY last modified date or something so the datasets I just uploaded will be at the top, but give the option to sort alphabetically too.
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.
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
To visualize results. +1 if I don't have to include the_geom_webmercator in my result set.
Need to investigate if this is a feature/bug of the SQL API.
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?
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'
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.
When you try to add savi-builder
as a user, you get an error, I forget what it was.
Also for some odd reason jbraden
also didn't work as a user.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.