Удобное решение для работы с БД
Обычно для работы с 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;
(Английский)
(Установил специально для Вас)
That is very attention-grabbing, You are an excessively skilled blogger. I have joined your feed and look ahead to searching for more of your excellent post. Also, I’ve shared your website in my social networks!
My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the expenses. But he’s tryiong none the less. I’ve been using Movable-type on a variety of websites for about a year and am nervous about switching to another platform. I have heard good things about blogengine.net. Is there a way I can transfer all my wordpress content into it? Any kind of help would be really appreciated!
Congratulations for posting such a useful blog. Your blog isn’t only informative but also extremely artistic too. There usually are extremely couple of individuals who can write not so easy articles that creatively. Keep up the good writing !!
I’m normally to blogging and i truly appreciate your content regularly. The content material has actually peaks my interest. My goal is to bookmark your web blog and maintain checking for initial time information.
Congratulations for posting such a useful blog. Your blog isn’t only informative but also extremely artistic too. There usually are extremely couple of individuals who can write not so easy articles that creatively. Keep up the good writing !!
I wanted to make a quick word to be able to say thanks to you for all the wonderful advice you are showing at this site. My rather long internet look up has at the end been honored with awesome information to share with my close friends. I ‘d assert that we readers are truly lucky to exist in a fantastic site with so many perfect people with insightful methods. I feel extremely grateful to have come across the web pages and look forward to plenty of more fun minutes reading here. Thank you again for a lot of things.
Youre so awesome, man! I cant believe I missed this blog for so long. Its just great stuff all round. Your design, man…too amazing! I cant wait to read what youve got next. I love everything that youre saying and want more, more, MORE! Keep this up, man! Its just too good.
This is a good posting, I was wondering if I could use this write-up on my website, I will link it back to your website though. If this is a problem please let me know and I will take it down right away
Amazing! This blog looks just like my old one! It’s on a entirely different subject but it has pretty much the same layout and design. Excellent choice of colors!
Good ¡V I should definitely pronounce, impressed with your website. I had no trouble navigating through all the tabs as well as related info ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or anything, website theme . a tones way for your client to communicate. Nice task..
When I originally commented I clicked the «Notify me when new comments are added» checkbox and now each time a comment is added I get several e-mails with the same comment. Is there any way you can remove me from that service? Appreciate it!
Definitely, what a magnificent website and enlightening posts, I surely will bookmark your blog.Have an awsome day!
Fantastic read, I just passed this onto a friend who was doing a little research on that. And he actually bought me lunch because I found it for him smile So let me rephrase that: Thanks for lunch!
Nice post. I learn something more challenging on different blogs everyday. It will always be stimulating to read content from other writers and practice a little something from their store. I’d prefer to use some with the content on my blog whether you don’t mind. Natually I’ll give you a link on your web blog. Thanks for sharing.
Congratulations on having one of the most sophisticated blogs Ive come across in some time! Its just incredible how much you can take away from something simply because of how visually beautiful it is. Youve put together a great blog space –great graphics, videos, layout. This is definitely a must-see blog!
Whats Taking place i am new to this, I stumbled upon this I have found It positively useful and it has aided me out loads. I hope to contribute & assist different customers like its aided me. Good job.
Your current positions always include many of really up to date info. Where do you come up with this? Just declaring you are very innovative. Thanks again
Getting a group of Toyota car headlights that looks very good along with suits excellent
It is really a nice and useful piece of information. I am glad that you shared this helpful information with us. Please keep us informed like this. Thank you for sharing.
Great info. Lucky me I ran across your site by accident (stumbleupon). I’ve book-marked it for later!
I wanted to create you the little note to say thank you yet again considering the wonderful pointers you’ve shown on this site. It has been certainly surprisingly generous of you to supply publicly exactly what a lot of folks might have sold for an e-book in making some dough for themselves, chiefly now that you might have done it if you decided. Those strategies likewise served to become good way to comprehend most people have the identical interest really like mine to learn lots more with regard to this issue. Certainly there are millions of more pleasant opportunities up front for many who start reading your blog post.
Congratulations on having one of the most sophisticated blogs Ive come across in some time! Its just incredible how much you can take away from something simply because of how visually beautiful it is. Youve put together a great blog space –great graphics, videos, layout. This is definitely a must-see blog!
I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favorites blog site list and will be checking back soon. Please check out my site as well and let me know what you think.
Wonderful items from you, man. I’ve keep in mind your stuff prior to and you’re simply extremely wonderful. I actually like what you have got right here, certainly like what you’re saying and the best way wherein you are saying it. You make it entertaining and you continue to take care of to stay it smart. I can not wait to learn much more from you. That is actually a wonderful site.
I’m really enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more pleasant for me to come here and visit more often. Did you hire out a developer to create your theme? Superb work!
Thank you for your whole labor on this web site. Betty enjoys engaging in investigations and it is simple to grasp why. We know all about the compelling manner you create very important guidelines by means of the website and as well as foster response from others on the topic and our favorite princess has always been being taught so much. Take advantage of the remaining portion of the year. You’re the one conducting a very good job.
Great write-up, I’m normal visitor of one’s website, maintain up the excellent operate, and It’s going to be a regular visitor for a long time.
Awesome things here. I am very happy to peer your article. Thank you so much and I’m having a look ahead to touch you. Will you please drop me a e-mail?
I just want to say I’m very new to weblog and definitely loved you’re blog. Almost certainly I’m likely to bookmark your site. You actually come with perfect article content. Appreciate it for sharing with us your website.
Deference to op , some superb entropy.
I view something really interesting about your blog so I saved to favorites .
There are some interesting points in time in this article but I don’t know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as well
hello there and thank you for your info – I have definitely picked up something new from right here. I did however expertise some technical points using this web site, as I experienced to reload the web site lots of times previous to I could get it to load correctly. I had been wondering if your hosting is OK? Not that I’m complaining, but slow loading instances times will often affect your placement in google and can damage your high-quality score if advertising and marketing with Adwords. Anyway I’m adding this RSS to my email and could look out for a lot more of your respective interesting content. Make sure you update this again very soon..
There are certainly a lot of details like that to take into consideration. That is a great point to bring up. I offer the thoughts above as general inspiration but clearly there are questions like the one you bring up where the most important thing will be working in honest good faith. I don?t know if best practices have emerged around things like that, but I am sure that your job is clearly identified as a fair game. Both boys and girls feel the impact of just a moment’s pleasure, for the rest of their lives.
I enjoy the efforts you have put in this, thanks for all the great blog posts.
Have you ever thought about publishing an e-book or guest authoring on other blogs? I have a blog based upon on the same ideas you discuss and would love to have you share some stories/information. I know my subscribers would enjoy your work. If you’re even remotely interested, feel free to send me an e mail.
I do like the manner in which you have framed this specific concern and it really does supply me personally a lot of fodder for thought. Nevertheless, from just what I have seen, I simply hope when the actual commentary pile on that men and women keep on point and in no way start upon a soap box regarding the news of the day. Anyway, thank you for this outstanding point and even though I can not really concur with this in totality, I regard the viewpoint.
Excellent post. I learned a lot reading it. Thanks.
We absolutely love your blog and find almost all of your post’s to be just what I’m looking for. can you offer guest writers to write content for you personally? I wouldn’t mind creating a post or elaborating on many of the subjects you write about here. Again, awesome web site!
The other day, while I was at work, my cousin stole my iphone and tested to see if it can survive a forty foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views. I know this is entirely off topic but I had to share it with someone!
I was curious if you ever considered changing the structure of your website? Its very well written; I love what youve got to say. But maybe you could a little more in the way of content so people could connect with it better. Youve got an awful lot of text for only having 1 or two images. Maybe you could space it out better?
Witty! I’m bookmarking you site for future use.
very nice post, i definitely love this fabulous website, persist with it
There is no bad patience. Knappert p. 46 Swahili.
Thanks for all of your effort on this site. Kate really loves doing internet research and it’s really easy to understand why. All of us learn all regarding the compelling method you offer advantageous items via this web site and foster contribution from visitors on the point plus our own simple princess is truly starting to learn a lot. Take advantage of the remaining portion of the new year. You are conducting a powerful job.