Syndicate content

version

Can I create an INDEX to accelerate a SELECT MIN(IF(...)) in MySQL?

I have a table with a few columns, two of which are integers, one of which can be NULL in which case the other integer is to be used in my query.

CREATE TABLE my_table (col1 INTEGER NOT NULL, col2 INTEGER);

If `col2` is NULL, then use `col1`. As is, there is how my query looks like:

SELECT MIN(IF(col2, col2, col1)) AS smallest FROM my_table LIMIT 1;

In other words, I need to get the row with the smallest integer, but if one column is NULL, I want to use the other column value.

On a very small sample, the query is still very fast, but the real version is not unlikely to have thousands ...

SugarCRM Community Edition for Ubuntu 16.04 with PHP 7

As I wanted to use SugarCRM on my new server, I looked into the Community Edition and apparently the company is not willing to convert their code so it works under PHP 7.

So that would not work on a newer system because the code uses quite a few forbidden mechanism (wrong class definitions, old defunct functions...) and that prevents to even instal the system on your machine.

Now, I have looked closer into it and I am getting a version that works pretty darn well already. I still have some issues here and there, but I think you can already make use of that version. Except for one thing which ...

Old Synergy 64bit version for windows compatible with Ubuntu synergy package version 1.4.12

As I like to have Synergy working on my Windows boxes (i.e. laptops), I am saving a copy of the installer 64 bit version which works fine with WinXP and Win7. I'm about to test it with Win10 which is likely to accept it as is too. Just in case you did not know, Synergy is a driver that takes one mouse device and makes it work on multiple computers. In other words, you can use any number of computers with one mouse and one keyboard. Move the mouse to the right computer and you can use the keyboard on that computer. No need for a KVM anymore (Keyboard Video Mouse device that allowed you to ...

Installing Solaris to compile your software

Now a day I like to install Solaris to check that my code compiles and generally runs under that OS.

I think that's a good way to prove that the code is multi-OS ready even if it is only for Unices.

OpenSolaris is free and can be downloaded from Oracle. The last URL I use was:

http://www.oracle.com/technetwork/server-storage/solaris11/downloads/index.html

The system, by default, comes with a directory named /usr/sfw which includes a really old version of gcc. It is possible, though, to move forward with a newer version of the compiler by installing a package. Under Solaris 11.2, this ...

[ODBC Driver Manager] Data source name not found and no default driver specified

As I was working on a MS-Windows installation, I ran in this weird error: Data source not found and no default driver specified...

This was output when I was running the following in a command line prompt:

osql -E

The result should have been an MSSQL prompt instead!

The problem on the computer was that I uninstalled MSSQL 2005 that was automatically installed by Visual Studio C++ and was not compatible with our application, so I first uninstalled that but that uninstallation is really not proper. It leaves a LOT of things behind.

After that I installed MSSQL 2014 which was reported as ...

List ciphers currently used by Apache2

If you are using Apache and e-Commerce, you probably want to know all the details of the ciphers used by the Apache SSL module.

So listing Apache supported ciphers is done using nmap as follow:

nmap --script ssl-cert,ssl-enum-ciphers -p 443 secure.m2osw.com

This call gives you a complete list of all the ciphers currently accepted by your running version of Apache. For example, the list may look like this:

| ssl-enum-ciphers:
|   SSLv3:
|     ciphers:
|       TLS_DHE_RSA_WITH_3DES_EDE_CBC_SHA - strong
|       TLS_DHE_RSA_WITH_AES_128_CBC_SHA - strong
|       ...

nvidia_XXX.ko No Such Device

Today I got a new video card because it looks like the old one I had was going bad. I hope that was not my KVM, although we'll see when it gets hot again, whether the video goes bouncy again or not... If not, then the old card is good for the trash (although it works in console mode just fine!)

So I got a new card. My old one was a NVidia GT 220. Fairly old model. Yes.

The new card is an NVidia GT 630 (to be precise: Asus GT630-SL-2GD3-L.)

When I tried to start X11, I saw an error (really quick) and the system did not come up. Looking closer into the matter, I could see that the NVidia ...

Remote access to another MS-Windows computer

I have used several different software to gain remote access to other's computers.

With a Unix system, it's easy. You use ssh and you can do everything you want (although some people just cannot handle a console, I'm fine with such, but ssh allows you to access X-Windows if you'd like with the -X command line option.)

With MS-Windows, since that system is just a desktop application, you need a special tool in order to achieve that feat. Most of them are for money or make use of things that do not work under Linux. Yet, there is one that I like, it is called TeamViewer. It was ...

Postfix says it does not allow relaying?!

As we are upgrading our server to jump from version 12.04 to 13.04, we encounter a few problems.

Two with Postfix, first the Postgrey port has changed. It was 60000 before, now it is 10023. Don't ask me... Anyway, that was the easy one.

The other problem was a relay error. I could send emails all I wanted, but not my partner who does not show his server as part of our Made to Order Software Corp. network. Relay is why a computer allows emails from server X to be sent to server Y through server Z. You are server Z, that's the relay.

The fact is that if you can log in your account on ...

PostgreSQL and blobs change in version 9.0 (bytea_output)

As I was moving my Drupal 6.x websites from an old server to a new one, I decided to make use of the newest PostgreSQL database system because over time I've notice quite a few things that got fixed and thus it is a lot better! (It is not as exciting as moving from 7.4 to 8.0 way back then, but still!)

Doing so, my Drupal site started showing WSOD (White Screens Of Death). Looking at the errors in my apache2 logs, I noticed that the error was in link with the cache. Looking closer, I could see that the cache (one of the only table doing so) makes use of the %b flag which means blob. It ...

Syndicate content Syndicate content

Diverse Realty

Diverse Realty Team

Want a New Home?
Want to Sell Your House?

Call Alex at
+1 (916)
220 6482

Alexis Wilke, Realtor
Salesperson
Lic. # 02024063

Cory Marcus, Broker
Lic. # 01079165

     

Terms of Site Index

Find the page/content you are looking for with our index.

  • WebDAV
  • drop
  • embedded

    Embedded software is a reference to software written to work in a piece of hardware equipment. At first, this was code written directly for a specialized processor such as an FPGA or a DSP. Today, regular computers will be used for applications such as a medical device or a kiosk and it is also called embedded software, even though these just are desktop applications...

  • language

    In computing, a language is a lexicon and grammar enabling a programmer to write software. There are interpreted and compiled languages. When compiling the computer transform the instructions of a program into instructions that the processor can execute natively.

  • multiple