|Showing entries 1 to 9|
Chuck Bell, one of my former colleague from MySQL AB, has created a connector for Arduino to MySQL. So this allows Arduino code to be a direct client of a MySQL or MariaDB server, with Ethernet and WiFi shields supported.
With Arduino boards being used more and more, this can come in really handy – not only for retrieving (for instance) centralised configuration data, but also for logging. Useful stuff. Thanks Chuck!
I recently got pointed towards https://github.com/shodanium/nanomysql/ which is a tiny (less than 400 lines of C++) MySQL client library which is GPL licensed.
If you need to link into non-GPL compatible code, there is the (slightly larger and full featured) libdrizzle library. But if you want something *tiny* and are okay with GPL, then nanomysql may be something to look at.
Finally there is an LGPL C client library for MariaDB, and thus also for MySQL. Monty Program and SkySQL have been working on this for some time. Admittedly there was already the BSD licensed Drizzle client library which was also able to talk to a MySQL/MariaDB server, however its API is different. The C client library for MariaDB has exactly the same API existing applications are used to, so you can just re-link and keep going! There is also a new LGPL Java client library for MariaDB.
In case you don’t quite realise: this is actually a major thing.
At MySQL AB, the client library was made GPL and this flowed through to Sun Microsystems and then Oracle Corp. This licensing[Read more...]
Problem: you wish to write table data to file, but you wish to do so on client side.
SELECT ... INTO OUTFILE writes the file on server. What are your options on client?
If you have direct access from your client machine to your DB server machine, and can connect via mysql client, you get a very customizable file write:
bash$ mysql -h db_host --execute "SELECT * FROM my_table" > /tmp/output.txt
The above writes fancy tables, so you probably want to:
bash$ mysql -h db_host --execute "SELECT * FROM my_table" --bat > /tmp/output.txt
[Read more...]bash$ mysql -h db_host --execute "SELECT * FROM my_table" --silent
I manage several mysql servers and often on these servers for security reasons the SUPER account is not allowed external network access, so access is made to localhost. When connecting to several hosts at the same time, for example from different ssh sessions, this can be inconvenient as the \h prompt only ever shows localhost and not the hostname of the server to which I’m connected.
The following small patch against 5.1.36 which can also be found here adds a new \H option which behaves the same as \h except in this case the hostname is shown.
diff --git a/Docs/mysql.info b/Docs/mysql.info index 7747201..dffacfd 100644 --- a/Docs/mysql.info +++ b/Docs/mysql.info @@ -20512,6 +20512,8 @@ sequences. `\D' The full current date `\d' The default[Read more...]
It’s always the little things in life. One of the things that has been a very “little thing” that causes a lot of frustration while writing The MySQL Administrator’s Bible is the prompt. Specifically, the fact that you can only change the first line of the prompt, but not the subsequent lines.
The default prompt that appears on the first line of the prompt is:
The default (and unchangeable) second line of the prompt is four spaces followed by an ASCII arrow:
The second line of the prompt is hard-coded to match up very nicely with the first line in a fixed-width font:
mysql> SELECT -> 1+2;
However, you can change the prompt, which is pretty handy:
mysql> prompt \d:[Read more...]
If you haven't heard of Digsby yet, you have probably been living in some kind of a virtual cave or have no friends. Digsby is a multi-network instant messenger application, similar to Trillian, Pidgin (GAIM), or Miranda. I said 'similar', so what makes Digsy special? Reviews I read so far don't give the real reasons and don't dive into the features in depth. Instead, you get a standard load of marketing BS and in the end to you, the user, Digsby may end up being "yet another IM program." Some reviews describe certain features, but so far I haven't seen one that highlighted THE MAIN REASON why Digsby is different. And may I preface it with: finally somebody got a clue. I never before wanted to write about any other IM client,[Read more...]
|Showing entries 1 to 9|