Giter Club home page Giter Club logo

adminer's Introduction

Adminer - Vitess integration

This fork of Adminer supports Vitess. Currently it is considered as beta, because some features are not working yet. Feel free to test and create feature requestsm ideally together with pull requests.

Usage

  1. Clone this repository.
  2. Set up a web server with the document root in the root folder of the cloned repository.
  3. Get a precompiled vtctlclient binary and put it somewhere into PATH, to be accessible from anywhere.
  4. Run the following commands from the project root directory (you'll have to have Composer installed):
composer install
git submodule init
git submodule update
  1. To run adminer, you have to visit this url:
http://HOSTNAME/adminer/index.php

To be able to log in into Vitess, you have to pick Vitess in the System input field and then insert the server string in the following format:

vtgateHost:vtgatePort|vtctldHost:vtctldPort|cell

vtgateHost: IP or hostname of one of your VtGate services vtgatePort: port of one of your VtGate services vtctldHost: IP or hostname of your VtCtld service vtctldPort: port of your VtCtld service cell: Vitess cell name, which you are connecting to

You may, but don't have to input the keyspace name in the Database input field. Username and password may stay empty, since Vitess currently has no authentication support. Therefore we recommend to protect your Adminer setup at least with some HTTP Basic authentication on the HTTP server level.

Known issues

On a sharded Vitess setup, it ist currently not possible to insert or update rows in tables which use Vindexes, because the Adminer core generates incompatible queries. Therefore, manual query correction has to be made in such cases for the time being.

The implementation also isn't optimal yet, it might use some profiling and optimizations. But it's better than nothing :)

TODO

  1. Get rid of the vtctlclient binary, if the Vitess team creates Protobuf stubs for the VtCtl client and commands.
  2. Maybe integrate VSchema manipulation functions (if it won't go against VSchema best practises from the Vitess team).

Adminer - Database management in a single PHP file

Adminer Editor - Data manipulation for end-users

https://www.adminer.org/ Supports: MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch Requirements: PHP 5+ Apache License 2.0 or GPL 2

adminer/index.php - Run development version of Adminer editor/index.php - Run development version of Adminer Editor editor/example.php - Example customization plugins/readme.txt - Plugins for Adminer and Adminer Editor adminer/plugin.php - Plugin demo compile.php - Create a single file version lang.php - Update translations tests/selenium.html - Selenium test suite

adminer's People

Contributors

vrana avatar gargaj avatar juzna avatar helix84 avatar zemistr avatar srsbiz avatar janrossler avatar detrandix avatar ujovlado avatar milouse avatar amdev avatar dg avatar kadimi avatar beutnagel avatar vlakoff avatar veasin avatar robertopc avatar passkeykz avatar lm avatar ekurtovic avatar dalli avatar martinmecera avatar mediamonks-robert avatar robloach avatar rastusik avatar piit79 avatar peterdavehello avatar queria avatar n-i-m-a avatar cobisimo avatar

Watchers

James Cloos avatar Alouane Nour-Eddine 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.