Удобное решение для работы с БД
Обычно для работы с mySQL я использовал «phpmyadmin», но сегодня мой взор был направлен на новое решение «SQL buddy», я скачал, загрузил на свой сервер, и…
И это просто супер! Такой и должна быть удобная работа с БД!
Возможно «SQL buddy» не имеет столько расширенных функций как «phpmyadmin», но для рутинных и небольших работ она прекрасно подходит.
Я был рад обнаружить, что русский язык уже включен в базовую сборку скрипта.
Перечислим основные достоинства этого решения:
- Удобство работы — приятный интерфейс, юзабельные таблицы, основные функции вызываются с помощью клавиатурных сокращений(сокращения вообще класс).
- Скорость работы и нагрузка на сервер — SQL buddy очень активно использует технологию ajax, что сильно ускоряет работу скрипта.
- Установка не нужна — устанавливать и настраивать скрипт не нужно, просто залил и используешь.
- Это решение с открытым исходным кодом, распространяется по лицензии MIT.
- Небольшой размер скрипта — 167 килобайта.
Теперь найденные мною недостатки:
- Есть некоторые не переведенные места — но это легко можно исправить, так как перевод можно осуществлять всем вместе на сайте SQL buddy.
- В некоторых моих таблицах не отображается кириллица, досадный глюк, но думаю его не сложно будет исправить.
В ближайшее время до конца перейду с «phpmyadmin» на «SQL buddy», так как считаю, что использовать «SQL buddy» буден намного эффективней и производительней.
Обновление:
Добрые энтузиасты закончили перевод, так что наслаждаемся полным русским переводом.
Один добрый человек с хабра-хабра решил проблему с кодировкой.
Для отображения правильной кодировки ищем в файле functions.php строчку:
return mysql_connect($_SESSION['SB_LOGIN_HOST'], $_SESSION['SB_LOGIN_USER'], $_SESSION['SB_LOGIN_PASS']);И заменяем ее на:
$con = mysql_connect($_SESSION['SB_LOGIN_HOST'], $_SESSION['SB_LOGIN_USER'], $_SESSION['SB_LOGIN_PASS']);
@mysql_query("SET NAMES 'utf8'", $con);
return $con;
(Английский)
(Установил специально для Вас)
ну тут еще немого вопросов возникает например по безопасности… ПХПМайАдмин уже проверен сотнями человек… А даный скрипт? Надо б смотреть исходники… или защищаться БейсАвторизацией дополнительно.
Но с вида красивый и удобный… Может за ним будущее ) Увидем
Зашел на сервере рутом, а он кааак начал select count(*) по каждой таблице делать, как все затормозило, ужас =)
Советую SQL yog
Все-таки с кириллицей фигня какая-то. Внутри таблиц одни вопросики — смена кодировки не помогает.
С кодировкой вроде бы проблемы…
Проблему решили ;-)
Может и интересней, да пожалуй это так. Но от привязанности к PMA так просто не отделаться :)
Если бы PMA на Ajax переделали, то было бы не хуже по производительности – факт.
А ведь не переделывают на Ajax мне кажется по одной причине – стандартными формами куда надёжнее будет, чем запросы Ajax’а…
Красивый интерфейс, но так и не смог решить проблему с загагулинами.
После замены строчки файле functions.php проблема осталась, весь русский – вопросы.
И в файле который скачал переведено не все (качал с указанной ссылки).
В чем ошибки? И где взять файлы с окончательным переводом?
Возможно у вас другая кодировка, попробуйте заменить utf-8 на cp1251.
А вообще, благодоря этой заметке, один энтузиаст уже выпустил патч полностью решающий проблему с кодировкой и отправил его автору скрипта.
Так что ждать более работоспособной версии осталось не долго.
Ждем -)
Есть прекрасное десктопное решение: HeidiSQL – бесплатный инструмент для управлениям БД, и ничего заливать никуда не надо. Особенно удобно делать импорт больших баз – там где phpmyadmin через 20 минут тихо умирает, Heidi тихо и спокойно заливает весь дамп.
Best wishes, I merely came your website along with wanted to claim that I have truly enjoyed browsing your site articles. I have enrolled in your current feed and i also we do hope you create yet again soon!
I simply want to tell you that I’m beginner to blogging and really enjoyed your page. Very likely I’m planning to bookmark your website . You absolutely come with wonderful stories. Cheers for revealing your blog site.
I need to present my own because of this article writer just for rescuing us through a real establishing. As a consequence of surfing through the the internet and acquiring suggestions which are not enjoyable, I believed my life ended up being above. Being alive minus the solutions to the down sides you might have resolved by using all of your site is an important situation, as well as kinds that may have got badly ruined my own complete occupation basically hadn’t found the website. Your primary expertise and also goodness in dealing with everything ended up being very helpful. I’m not sure things i would have accomplished if I hadn’t arrive about this type of stuff like this. I can also now stay up for my own future. Thank you a lot to your specialized along with remarkable aid. I won’t think twice for you to offer your internet site in order to anyone who requirements suggestions relating to this subject matter.
Hey there! I know this is somewhat off topic but I was wondering if you knew where I could locate a captcha plugin for my comment form? I’m using the same blog platform as yours and I’m having problems finding one? Thanks a lot!
A unique discussion might be priced at comment. I believe that you should produce more on this specific topic, may well be a taboo topic but frequently people are too few to speak for such topics. To the next. Best wishes
A unique discussion might be priced at comment. I believe that you should produce more on this specific topic, may well be a taboo topic but frequently people are too few to speak for such topics. To the next. Best wishes
Thanks for all your efforts that you have put in this. very interesting info . «You can’t help someone get up a hill without getting closer to the top yourself.» by Gen. H. Norman Schwarzkopf.
Thank you for sharing excellent informations. Your web site is so cool. I am impressed by the details that you’ve on this blog. It reveals how nicely you understand this subject. Bookmarked this website page, will come back for more articles. You, my friend, ROCK! I found just the information I already searched all over the place and simply couldn’t come across. What an ideal site.
I regard something genuinely interesting about your blog so I saved to bookmarks .
Heya i’m for the first time here. I came across this board and I find It truly useful & it helped me out much. I hope to give something back and help others like you helped me.
My partner and i still can’t quite believe I could end up being one of those reading through the important points found on this blog. My family and I are seriously thankful for your generosity and for presenting me the potential to pursue the chosen career path. Thanks for the important information I acquired from your site.
You have mentioned very interesting points! ps decent site.
I consider youve produced some actually interesting points. Not too many men and women would the truth is feel about this the way you just did. Im actually impressed that theres so much about this theme thats been uncovered and you did it so properly, with so much class. Really excellent 1 you, gentleman! Genuinely exceptional stuff right here.
Great post, I believe website owners should learn a lot from this web blog its really user genial . «Frisbeetarianism is the belief that when you die, your soul goes up on the roof and gets stuck.» by George Carlin.
Keep up the great piece of work, I read few posts on this site and I conceive that your web site is rattling interesting and has lots of excellent information.
Very interesting info !Perfect just what I was searching for! «I have a hundred times wished that one could resign life as an officer resigns a commission.» by Robert Burns.
I’ve been absent for a even though, but now I remember why I used to really like this web site. Thank you, I will try and check back much more often. How often you update your internet site?
Oh My Goodness. Everything is amazing! I wish I could have them all
I simply could not go away your site before suggesting that I extremely enjoyed the standard information an individual supply on your visitors? Is going to be back incessantly to inspect new posts
I used to be much more than pleased to seek out this internet-site.. I dont even know how I ended up here, but I thought this post was excellent. A lot much more A rise in Agreeable.
It’s important to obtain a qualified proper diagnosis of your ringing in the ears before starting getting rid of them. A lot of the ear ringing can be indicative of rather more serious concerns. Furthermore, in the event the a diagnosis is not buzzing in the ears, then you’ll need so that you can medicate or perhaps treat it inside of a several manner compared to you’d probably tinnitus. A lot of people who definitely have tinnitus obtain rid of the affliction by employing noise remedy. You will find a basic test that you could try to see in the event that sound treatment will assist you to manage the buzzing in the ears. Beat a person’s radio station between 2 stops. You should notice a new static appear once you have tuned it amongst channels. If your stationary seem with the stereo markers your buzzing in the ears or even helps it be significantly less noticeable (partly markers them), in that case sound treatment may assist your trouble.
Excellent items from you, man. I have have in mind your stuff prior to and you are simply too excellent. I actually like what you’ve acquired right here, certainly like what you are saying and the way in which wherein you say it. You are making it enjoyable and you still take care of to keep it smart. I cant wait to learn far more from you. This is really a terrific site.
I like this web site very much so much fantastic info . «The highest proof of virtue is to possess boundless power without abusing it.» by Lord Macaulay.
Excellent goods from you, man. I have understand your stuff previous to and you’re just too excellent. I really like what you’ve acquired here, really like what you are saying and the way in which you say it. You make it entertaining and you still take care of to keep it sensible. I can’t wait to read far more from you. This is actually a tremendous site.
You are my aspiration , I possess few web logs and very sporadically run out from to brand : (.
I gotta favorite this site it seems extremely helpful invaluable
An impressive share, I just given this onto a colleague who was doing a little analysis on this. And he in fact bought me breakfast because I found it for him.. smile. So let me reword that: Thnx for the treat! But yeah Thnkx for spending the time to discuss this, I feel strongly about it and love reading more on this topic. If possible, as you become expertise, would you mind updating your blog with more details? It is highly helpful for me. Big thumb up for this blog post!
Right now it appears like Expression Engine is the preferred blogging platform available right now. (from what I’ve read) Is that what you’re using on your blog?
biederhof Chrissy caboodle frightfully ultrasonic nursling trails thermodynamics spongy
Keep up the excellent work , I read few articles on this web site and I believe that your website is really interesting and contains sets of good information.
Hey there, You’ve done an incredible job. I will definitely digg it and personally recommend to my friends. I am confident they will be benefited from this web site.
I have been meaning to create something similar to this on my site and also you have given me an idea. Cheers.
I simply want to tell you that I am just new to blogging and honestly enjoyed this web-site. More than likely I’m want to bookmark your website . You actually come with outstanding posts. Thank you for sharing your website page.
One thing I would like to touch upon is that weightloss program fast may be accomplished by the suitable diet and exercise. Ones size not simply affects appearance, but also the entire quality of life. Self-esteem, depressive disorders, health risks, as well as physical skills are afflicted in excess weight. It is possible to do everything right and at the same time having a gain. Should this happen, a problem may be the culprit. While an excessive amount food rather than enough exercising are usually to blame, common health conditions and key prescriptions may greatly enhance size. Thx for your post here.
On this very subject, I try update my blogs almost like I’m speaking to somebody or talking to that reader directly as I consider it helps engage men and women a lot much more than writing content material formally especially when my own weblog is based around the goings ons, day-to-day thoughts and research about this somewhat controversial concern. I discovered that I nonetheless want to use a lot more with the approaches you might have mentioned in this posting.
Real wonderful info can be found on weblog.
I simply want to mention I am just all new to weblog and honestly liked your web page. Most likely I’m want to bookmark your blog post . You surely have beneficial articles. Many thanks for revealing your blog.
You actually make it seem so easy along with your presentation but I find this matter to be actually one thing which I think I might by no means understand. It sort of feels too complicated and extremely broad for me. I am having a look forward in your next put up, I’ll try to get the dangle of it!
Lovely site! I am loving it!! Will come back again. I am bookmarking your feeds also