falcon-client/falcon

A (experimental) fast, modern, and extensible database client

falcon's Issues

PR: Connections

PR: excel-like spreadsheet features

We could use https://github.com/tomazy/xcell

See https://tomazy.github.io/xcell/ for examples

PR: Test Connection

Allow a user to test if the configuration for a connection works before saving the connection

PR: Open db by drag and drop

IDEA: Bundling languages

https://www.datanami.com/2018/02/12/programming-language-best-big-data/

PR: Support for blobs

Currently we just filter row values that have blobs because we don't support them:

{
  value: Object.values(value).filter(e => !(e instanceof Buffer))
}

We should add support for this. Even db browser has this:

TableDefinition doesn't work for certain tables

see employees table

Reimplement multi-row highlighting

PR: Embedding Python for data analysis

• https://github.com/aidanhs/empython
• https://github.com/pypyjs/pypyjs

Would prefer a WASM version

INVESTIGATE: Borrow Ideas from Hyper

hyper is a really good example of a high quality electron app. Here's some of the things we can learn/borrow from it:

• Auto Updates
• Plugin System
• Cross-platform nits/fixes/workarounds
• Channel-based builds and releases (nightly, canary, stable, etc)

PR: Interactive Schema Builder

Generate schemas for databases with an interactive GUI. This is basically a reimplementation of wwwsqldesigner. I think we should borrow the UI of ThreeNodes.js

PR: Table options

PR: Query planning

Taken from https://databaseflow.com/db/sqlite

PR: Saving Queries

Fix sqlite node 10 compatibility

Bump falcon-core when this issue is fixed:

falcon-client/falcon-core#37

PR: Migrate to webpack@4

PR: Autoincrements

We're missing autoincrements

PR: Remove sourcemaps in releases

This will prevent people from seeing the source code of falcon

INVESTIGATE: react-animated-tree

https://github.com/drcmda/react-animated-tree

PR: Render views, indexes, triggers in sidebar

https://github.com/amilajack/falcon-core/blob/master/src/db/provider_clients/SqliteProviderFactory.js#L473

listTableTriggers() in core will return all the triggers. Render this in a table. Do the same for views and indexes

PR: CRUD for schema

PR: Query Formatting

falcon-client/falcon-core#24

PR: Migrate to Monaco Editor

https://github.com/Microsoft/monaco-editor

Window Code Signing Certificate

Investigate cacert

• Free
• Need to see how this compares to paid certificates

Resources:

• https://www.quora.com/Where-can-I-find-free-or-cheap-code-signing-certificate

Migrate e2e tests to testcafe and add test specific data attributes

PR: Progress bar

http://ricostacruz.com/nprogress/

INVESTIGATE: improving startup performance

Things to investigate

• Dynamically import only parts of falcon-core that are necessary
• async/lazyload routes with react-router
• Service worker to reduce network startup
• prepack (waiting for this project to mature)
• Native compile cache
• electron-link (v8 snapshots)

Readings

• How Atom Uses Chromium Snapshots
• Dan Abramov
• Addy Osmani: Thoughts on precompiling JS bytecode for delivery through a server/CDN
• Atom Blog Post on Improving Startup Perf
• atom/electron-link#1
• V8 Blog Post: Energizing Atom with V8's custom start-up snapshot

Resources

• https://chromedevtools.github.io/timeline-viewer/

NOTE: Requiring falcon-core reduces startup perf by 1 whole second

PR: Responsive improvements

PR: Logic Migration

See PR #13

INVESTIGATE: HappyPack for faster build times

https://github.com/amireh/happypack

Rename Login.js to CreateConnection.js

PR: Add draggable bar between schema definition and table schema

PR: Progress bar in status bar

PR: New row insertion / deletion

PR: Consider new graph alternative

• https://github.com/idflood/ThreeNodes.js
• https://github.com/idflood/ThreeNodes.js/blob/master/src/scripts/threenodes/nodes/views/NodeView.coffee
• https://github.com/dagrejs/dagre-d3

A good web graphicsviz replacement: darge

UPDATE: Investigate altering graphviz attributes first to produce better graphs first

• https://stackoverflow.com/questions/10438895/graphviz-outputs-a-mess
• https://www.graphviz.org/doc/info/attrs.html
• http://graphs.grevian.org/example
• Wayyyy faster in terms of performance
• Doesn't rely on viz.js so build size is slower. No need for web-worker
• Much easier to customize.
• Graph is laid out in a much more simpler/intuitive way

PR: Design System

Summary

Falcon needs to have consistent look and feel across different pages and components. We need a 'custom bootstrap-like library for falcon'. We're not going to fork bootstrap or anything. But we need a UI library that is somewhat similar to it in the sense that it has basic components such as buttons, headers, etc.

Ideas

• auth0-cosmos
• Ant design
• UI Kit
• React toolbox
• ngx-datatable
• carbon
• Present UI library with react storyboard

Theming

• https://reactjs.org/blog/2018/03/29/react-v-16-3.html
• http://simurai.com/blog/2018/04/01/contextual-styling
• http://bradfrost.com/blog/post/creating-themeable-design-systems/
• https://designsystemsrepo.com/

INVESTIGATE: Preact Virtual List

https://jsfiddle.net/developit/qqan9pdo/

Butter smooth. Much faster than anything we've seen/discussed before. Worth investigating before MVP

PR: Memory leaks in development

Not sure if these are in production or not

PR: Test against race conditions

Test against simultaneous writes to sqlite database

Write e2e tests for different databases

Use multiple database fixtures

PR: Graph Representation

See #22

PR: Logs

PR: Prevent unnecessary re-rendering of graph

The graph creates an instance of grpahql and renders a graph on each instantiation of the graph component

PR: Async react routes

PR: Collapsable drawers

A pretty common feature of Mac Apps:

PR: Details section

List metadata such as connection count, processes, memory, etc. Ideally, we could have something similar to this:

PR: Initial MVP Features

• CRUD functionality (Is dependent on CRUD-related method rewrites in falcon-core)
• UI library
• Add toolbar
• Import/export
• Disabling buttons in certain contexts (see #13 (comment))
• Custom Grid (replace hansontable)
• Reimplement multi-row highlighting
• Re-enable file-channel feature (see HomePage.js)

Closes #36

Functionality Reimplementation

• Reimplement forms with formik
• UI library
• Add toolbar
• Import/export
• Saving and selecting Connections
• Temporarily migrate TableDefinition to ace editor
• Disabling buttons in certain contexts (see #13 (comment))
• Fix login/connection page (see #13 (comment))
• Fix navigation button size styling
• Fix hardcoded database path (see DatabasePathReducer)
• Adapt styling of hanson table to fit previous styling
• Update boilerplate (change icon, app name, etc)
• Custom Grid (replace hansontable)
• Reimplement multi-row highlighting
• Re-enable file-channel feature (see HomePage.js)
• CRUD functionality (Is dependent on CRUD-related method rewrites in falcon-core)

INVESTIGATE: Shadow DOM and CSS-in-JS for CSS Scoping

• https://github.com/treshugart/react-shade
• https://github.com/Wildhoney/ReactShadow

PR: Auto updates

We'll need auto updates for the MVP. If we don't do this, users that install the initial version of the app won't be able to get updates so they'll be stuck on the initial version. We will need an apple developer license which cost around $100