Every time when I woke up my MacBook, the process BTServer started to run at 140% CPU power and the fan would blow like crazy. Looking for a solution, I found that this problem is quite common, but I couldn’t find complete instructions to solve this problem.

I searched my Mac for files with BTServer in their names and found com.apple.BTServer.txt among other names. The file is in a folder called launchDeamons, which gave me a clue.

The only website I could find, mentioning both the file and high CPU usage, is at: http://qery.us/1vu . Below follows what I did after reading the site.

First open folder /Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator5.0.sdk/System/Library/LaunchDaemons/ and locate the file com.apple.BTServer.txt. Copy this file to your desktop. Before continuing, you might want to duplicate the file first.

Open it in TextEdit by right-clicking (or control-clicking) on it and choosing Open With>TextEdit from the popup menu. Find the text

<key>Disabled</key>
    <false/>

and change it into

<key>Disabled</key>
    <true/>

The website doesn’t mention it, but there is also a key KeepAlive containing

<key>SuccessfulExit</key>
        <true/>

I might be overdoing things, but I set this key to false too:

<key>SuccessfulExit</key>
        <false/>

Now save and close the file. Drag the file back into aforementioned folder. When you’re asked if you want to replace, click on Replace. When you’re asked to authorize this action, allow it and enter your password when asked for.

At first this didn’t work for me, but after I restarted the Mac, the problem seemed to have gone away.

In this blog post, I use a very simple example to answer the question how to select data from two different tables in a MySQL database.

Start with creating a database. Now create 2 tables:

CREATE TABLE t1 (col1 VARCHAR(1),col2 INT(1));
CREATE TABLE t2 (col3 VARCHAR(1),col4 INT(1));
INSERT INTO t1 VALUES (‘a’,1),(‘b’,2),(‘c’,3);
INSERT INTO t2 VALUES (‘x’,1),(‘y’,2),(‘z’,3);

Now do a joined select and notice that you can one very big table:

SELECT * FROM t1,t2

output:
a     1     x     1
b     2     x     1
c     3     x     1
a     1     y     2
b     2     y     2
c     3     y     2
a     1     z     3
b     2     z     3
c     3     z     3

However, if col2 of t1 and col4 of t2 are identifiers for the same subjects, we can use these keys to display only rows that make sense:

SELECT * FROM t1,t2 WHERE col2=col4

output:
a     1     x     1
b     2     y     2
c     3     z     3

We can adjust this statement to get only the information we want, e.g. all information from both tables about subject x:

SELECT * FROM t1,t2 WHERE col2=col4 AND col3=’x’

Suppose that the two columns col2 and col4 have the same name, e.g. ‘id’ (which would make sense) then we would write:

SELECT * FROM t1,t2 WHERE t1.id=t2.id AND col3=’x’

and if we only need to know col1 (because the id column is really just an identifier and doesn’t contain information we need and we use col2 to identify subject x, which is information we already have) then we can write:

SELECT col1 FROM t1,t2 WHERE t1.id=t2.id AND col3=’x’

output:
a

Installer Maker is a programme that wraps your software in a nice and easy installer. Installer Maker 1.7.4Sb01 contains more than 20 new features and bug fixes. Installer Maker creates installers of your software for Mac OS X and Windows and is especially convenient for users of RAD environments such as RealStudio, SuperCard and LiveCode.

Currently, the official standalone version of Installer Maker is 1.6.1. This version is almost a year old. During that year, we added many new features, which were included in the plugin version for LiveCode but not in the standalone version. We are now releasing Installer Maker 1.7.4Sb01, which includes all new features.

Note that 1.7.4Sb01 is a beta version. It may work or fail completely. Economy-x-Talk doesn’t bear any responsibility for any problems caused by Installer Maker. See also our business terms and the license included with the software.

There are 4 different versions (for Mac OS X PPC, Mac OS X Intel, Mac OS X Universal and for Windows), which you can download here.

Do you like Installer Maker? You can buy a license with a 25% discount until Friday 9 March! Go to http://qery.us/1v7 to get your discount! The discount applies to both the standalone and the plugin version of Installer Maker.

Installer Maker is a programme that wraps your software in a nice and easy installer. Installer Maker 1.7.4Sb01 contains more than 20 new features and bug fixes. Installer Maker creates installers of your software for Mac OS X and Windows and is especially convenient for users of RAD environments such as RealStudio, SuperCard and LiveCode.

Currently, the official standalone version of Standalone Maker is 1.6.1. This version is almost a year old. During that year, we added many new features, which were included in the plugin version for LiveCode but not in the standalone version. We are now releasing Installer Maker 1.7.4Sb01, which includes all new features.

Note that 1.7.4Sb01 is a beta version. It may work or fail completely. Economy-x-Talk doesn’t bear any responsibility for any problems caused by Installer Maker. See also our business terms and the license included with the software.

There are 4 different versions (for Mac OS X PPC, Mac OS X Intel, Mac OS X Universal and for Windows), which you can download here. Do you like Installer Maker? You can buy a license with a 25% discount until Friday 9 March! Go to http://qery.us/1v7 to get your discount! The discount applies to both the standalone and the plugin version of Installer Maker.

It’s Spring and that’s a good time to do something nice. Economy-x-Talk is offering all new customers a 25% discount on a license for the Installer Maker Plugin for LiveCode. IM for LC is an easy way to make installers for Windows and Mac OS X with nothing but LiveCode. Please go to http://qery.us/1v7 for more info about the discount and the Installer Maker Plugin. The discount is available until Friday 9th March 2012.