Adminer — web interface for databases larger one .php file



In light of the recent post about a comparison of PostgreSQL and MySQL in the comments arose the problem of choosing a convenient interface for Postgres. I myself faced with this problem, deciding to look for alternatives all the well-known phpMyAdmin / php*Admin, who is the standard webmasters.

And since in life I love minimalism and speed, I was Gloria inside the feeling for the sake of viewing table structures, the data in the database, run SQL queries, I'm carrying a huge bunch of files in the archive, which occupies 5MB, I have been looking for. Were found www.adminer.org

Free web muzzle with open source, very reminiscent of the phpMyAdmin interface in a single *.php file size 189 KB (in minimum configuration). The functionality covers the needs of 95% of the developers:
the
    the
  • Support for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch, MongoDB
    • the
  • multilingual Support
    • the
  • Free for anyone to use
    • the
  • Browse, create, modify, data
    • the
  • Working with table structures and databases
    • the
  • manage indexes
    • the
  • Dump and import
    • the
  • authentication Mechanism with saving sessions
    • the
  • Support for themes (+1 .css file, I use Atat)
    • the
  • , etc.


The fastest way to see c demo with screenshots the website.

Of the minuses, I noticed incomplete support for postgresql data types (arrays, json, for example). For myself, I cured it by editing source code but more desire to look at the code I have, and you do not advise. The main thing that performs its task.
Article based on information from habrahabr.ru

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Abraham: you work hard, to catch the deadline. What now?

Изображение
the Author, Matthew burns, have worked on such game franchises as Halo, Call of Duty and Destiny. He is a writer and game developer from Seattle. Abraham, or the full effort in trying to catch the deadline (slang for English-speaking programmers – crunch [crunch]) is a regrettable phenomenon in our industry. And before someone will come up with a solution for this problem, what do we do with him? In the debate about the rush jobs we're talking about whether there are circumstances under which it is valid – that is, whether there is "good" and "bad" Abraham – what should the industry do in order to cut the number of "bad". I agree with the fact that for industry it would be useful to change from the top down. Usually managers can take on more responsibility to help improve working conditions and make game development a pleasant and stable work. But such a change would be slow and go it will be in parts. A huge number of studios and develo...
Далее...

Looking for books as you want

Изображение
this last week or two, as curious users can watch Russian search service on books from Google . However, the General public before the official announcement from Google itself remains in the dark. Meanwhile, already there is something to see and something to tell. Besides, Google has not gone unnoticed in Yandex, which last week began offering users with Store cards and the output presented there books. What, in turn, did not fail to say publicly. Let's take a closer look at what is offered book lovers the giants of the search. Let's start with Google. The California company offers us their traditional approach. Typing in the familiar search bar the title of the book, we get... well, what we will get, greatly depends on many factors. Mostly while where a book has been published. If it's a popular publication in the United States (as an example from reference service — exposing the social ills of America's best-selling book " Fast Food Nation "), the...
Далее...

Google: alternatives to the search giant

Изображение
Google is constantly working on innovations and improvements to their services. Only in the last few weeks the company has added the ability to automatically correct images when uploading to Google+, launched a network of balloons to provide Internet access in areas with poorly developed infrastructure has opened access to a new subscription service to music and updated service card. But while the company reports on the recent income and achievements, investors are only interested in one thing — income from contextual advertising company Among all innovations of Google, the search engine remains one of the most reliable sources of income of the company. In June, more than 90% of searches on computers and over 92% of queries on mobile devices in the UK were on Google. These numbers can be envied by any company. At the same time in the U.S. market, the average percentage below average and is about 78%. There are problems in the markets of China, Russia and South Korea. ...
Далее...