EasySQL for Joomla
Version
1.27 (last update on Jan 10, 2009)
Rating
Compatibility
Votes
Favoured
60
License
GPLv2 or later
Non-Commercial
Type
Views
141217
Date Added
21 August 2007
Features:
* (NEW) replace table prefix (REPLACE PREFIX `jos_` TO `newprefix_`)
* execution any queries to MySQL;
* execution of several queries for time;
* restore database sql-dump;
* data acquisition of the table selected from the list;
* displayed query results; horizontal scrolling the wide table;
* croping long strings in cells of the table (option);
* creating, editing and deleting records;
* export to csv-file;
* support multilang-interface (inside: EN, RU, FR, ES).
* support Joomla 1.0.x and 1.5.x in native mode
PS: to change delimiter (comma)
for englih and J1.5 see com_easysql/lang/en-gb.php
define('_ES_CSV_DELIMITER', ';');
to
define('_ES_CSV_DELIMITER', ',');
Installed on J1.5 stable without a hitch. Works as advertised so far. Would love to see CREATE TABLE supported.
[I found that I could create tables by entering the full command in the free text area. It gives an error message but the tables were created exactly as specified. I don't recommend it but it worked for me.]
[I found that I could create tables by entering the full command in the free text area. It gives an error message but the tables were created exactly as specified. I don't recommend it but it worked for me.]
I'm serious, this component is a lifesaver!! I've been needing to delete the tables from fireboard to do a clean install. Without phpmyadmin or any clue how to query a sql database, this program did it.
There is a dropdown list which doesn't list the command "drop", but it works fine if you throw the command into the blank window and hit execute.
Thanks for putting this together :)
There is a dropdown list which doesn't list the command "drop", but it works fine if you throw the command into the blank window and hit execute.
Thanks for putting this together :)
This component is very simple, and surely could be expanded with other features, for example view / edit / create table structure, but it's a valid and useful alternative for sysadmin if phpMyAdmin is not available, to have a basic control of records. In fact, with this extension you can easily list, edit, delete and create records; in addiction there are also some useful queries like "SHOW STATUS" and "SHOW CREATE TABLE".
To use at best this extension, you should have a minimum SQL knowledge.
To use at best this extension, you should have a minimum SQL knowledge.
When I first checked this out and went to the home page and discovered it was Russian I thought bugger. Downloaded the component and unzipped and there was no help documentation either, again thought bugger. However, ever adventurous I uploaded it to my test site and it could not be easier. 95% of all the mysql functions have been predefined and you can very simply right your own query and see the results and then click a button and they are exported to a csv. Magic component.It is not quite as powerful as phpmyadmin but comes close.
Page 2 of 2