Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 5

Displaying posts with tag: ip (reset)

Mixed signals in IT’s great war over IP
+0 Vote Up -1Vote Down

Recent news that Microsoft and Barnes & Noble agreed to partner on the Nook e-reader line rather than keep fighting over intellectual property suggests the prospect of more settlement and fewer IP suits in the industry. However, the deal further obscures the blurry IP and patent landscape currently impacting both enterprise IT and consumer technology.

It is good to see settlement — something I’ve been calling for, while also warning against patent and IP aggression. However, this settlment comes from the one conflict in this ongoing war that was actually shedding some light on the matter, rather than further complicating it.

See the full article at TechNewsWorld.

2012 to be year of Linux domination
+0 Vote Up -1Vote Down

Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.

I expect to see nothing but continued strength for Linux and

  [Read more...]
CAOS Theory Podcast 2011.10.28
+0 Vote Up -0Vote Down

Topics for this podcast:

*Opscode Chef extends to Windows for more enterprise devops
*Black Duck continues growth, gains new funding
*Cloudant expands NoSQL database focus, customers
*New open source Web server and vendor Nginx arrives
*The downside of Microsoft’s Android dollars

iTunes or direct download (27:35, 4.7MB)

Microsoft suing TomTom, not Linux, not open source
+0 Vote Up -0Vote Down

One might have thought Microsoft was back rattling the patented software sabres against Linux and open source this week, reading some of the recent reports regarding Redmond’s patent infringement suit against automotive navigation and GPS player TomTom. However, upon further review, it seems that Microsoft is making a point to say that these suits are not aimed at the Linux OS or open source. In response to my own query, the company offered this:

First, to answer your earlier question on how the suit with TomTom involves the Linux Operating System, three of the infringed patents read on the Linux kernel as implemented by TomTom. However, open source

  [Read more...]
Backwards LIKE Statements
+0 Vote Up -0Vote Down

Sometimes you need to think backwards.

Here was the problem. I needed to match up some IP address ranges to the company that owns them. Looking for a simple solution to the problem I came up with storing the IP address block patterns in the database as follows:

ip_pattern
----------------
127.%.%.%
192.168.%.%
10.%.%.%

Any idea why I choose % as the wildcard?

That's right - it's the wildcard operator in SQL for the LIKE statement.

So now when I have have an IP address 192.168.1.1, I can do what I like to call a backwards LIKE query:

SELECT company, ip_pattern
FROM company_blocks
WHERE '192.168.1.1' LIKE ip_pattern

This works on SQL Server and MySQL, and I would think it should work fine on any database server.

Showing entries 1 to 5

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.