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

Комментарии

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

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

Vkontakte sync with address book for iPhone. How it was done

Изображение
the Background application on androidphone when you install the application Vkontakte is possible to use it as a provider of contacts to synchronize the contacts from Facebook with contacts in your address book. In this case stretches the avatar, date of birth, address, phone numbers, etc. When I after prolonged use HTC Wildfire S rated and are so used to this that he wanted to find a similar to the iPhone. Not found, so we took it and made his own — Synchronizer VKontakte :) It was back in November of last year. The application was done fairly quickly — it uses quite a few functions of Vkontakte API and functionality with the address book of the iPhone. But when we started to deal with the automatic matching of contacts, it was fun. Compare head-on by name, last name and phone number was easy to do, easy, and worked through it quickly. But found only 20 percent of coincidences of the contacts from what is provider in Android. Of course, only direct hits do not sui
Далее...

Automatically create Liquibase migrations for PostgreSQL

Изображение
Working with Liquibase always brings confidence in the fact that the database objects are in the same condition in which you want it. It is this confidence and makes system migrations so popular databases. Today I want to tell you how to make using liquibase a bit easier. If you write a migration by hand, and your target database is PostgreSQL, then read this article, I am sure, the time spent on reading the article will be repaid with interest. I hope you already know how to work with Liquibase, so only two words describe how the system works. In order to make changes in the database, you need to create a migration file (changeset) that you need to specify in the file change log (changelog), after which the migration can be successfully applied to the target database. Undeniable and obvious benefit of this approach is the ability to rollback the changes. In my opinion, liquibase, there is only one drawback — the automatic rollback of changes only works only if the mi
Далее...

What part of the archived web

Изображение
/ > the time Machine Internet Archive is the largest and well-known archive that preserves web pages since 1995. Besides him there are a dozen other services, which are also archived to the web: the indexes of search engines and industry-specific archives like Archive-It , UK Web Archive , Cite Web , ArchiefWeb , Diigo . Interesting to know how many web pages gets into these files, relative to the total number of documents in the Internet? It is known that the base of the Internet Archive for 2011 contains more than 2.7 billion URIs , many of them in multiple copies taken at different points in time. For example, the home page of Habra "photographed" already 518 times since July 3, 2006 . It is also known that the base reference Google five years ago overstepped the mark in trillion unique URLS , although many of the documents were duplicated. Google is not able to perform all URLS, so the company decided to count the number of documents in the Internet a
Далее...