Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 337 Next 30 Older Entries

Displaying posts with tag: open-source (reset)

Inner vs. Outer Joins
+1 Vote Up -0Vote Down

I want to teach you the difference between an inner and an outer join. We first need to think about what a join is. Simply, it’s when you combine two tables to make a new one. You’re not physically creating a new table when you join them together, but for the purposes of the query, you are creating a new virtual table. Every row now has the columns from both tables. So if TableA has columns Col1 and Col2 and TableB has columns Col3 and Col4, when you join these two tables, you’ll get Col1, Col2, Col3, and Col4. Just as with any query, you have the option of including all columns or excluding some, as well as filtering out rows.

Inner join. A join is combining the rows from two tables. An inner join

  [Read more...]
3 rules for naming things in your database
+0 Vote Up -0Vote Down

They say there are two hard things in software development: cache invalidation, naming things, and off-by-one errors. Even though it seems like a simple thing, naming tables, columns, and stored procedures is hard when designing a SQL database. There are three simple rules I like to abide by when designing schema: give things meaningful names, be consistent, and favor verbosity over obscurity. Let’s expand each one of those points, and then I’ll cover some MySQL specific addendums.

Meaningful Names

The first part of this idea is to give objects unique, specific names. A table that is named Entities is going to confuse everyone. You want to name your table with the specific category of data or noun it represents.

  [Read more...]
Foreign Data Wrappers
+0 Vote Up -0Vote Down

Original images from Flickr user jenniferwilliams

One of our clients, for various historical reasons, runs both MySQL and PostgreSQL to support their website. Information for user login lives in one database, but their customer activity lives in the other. The eventual plan is to consolidate these databases, but thus far, other concerns have been more pressing. So when they needed a report combining user account information and customer activity, the involvement of two separate databases became a significant complicating factor.

In similar situations in the past, using earlier

  [Read more...]
MySQL vs. SQL Server
+0 Vote Up -0Vote Down

A new company often means new responsibilities and learning new ways of doing things. For a tech guy, it often means picking up a new framework or maybe if you are a glutton for punishment, a new language. I recently switched OSes, languages, and databases as a DBA/DB Developer. This was quite a massive shift for me. I went from the stable, enterprise database, SQL Server, to the little engine that could, MySQL. Before the switch, I would stew over the fact that SQL Server lacked features in comparison to Oracle or Postgres, but now I realize that there are far better things to worry about (such as non-blocking backups). I just wanted to go over some of the differences I found.

  • MySQL is a collection of binaries that manipulate data files. It is not a monolithic application that persists its data to disk, but instead it
  •   [Read more...]
    Living With Linux
    +0 Vote Up -0Vote Down

    I learned how to use a computer on DOS and Windows. My first programming projects were written in QBASIC and my first Web applications were written in VB using ASP on Windows 2000. The first job where I made decent money was developing a SQL Server-based application. I bought my first car, an engagement ring, and a honeymoon with money from making software on Windows. Needless to say, I found a lot of intellectual and financial fulfillment from Windows over the years.

    That first real job also allowed me flexibility in what technology I could employ, and I helped implement a features using Redis on top of Ubuntu. This was a fun time, because my company basically paid me to study a new technology and to gain experience using it. On my own, I began to use Linux and to embrace open-source ideas, one of which is that the consumer

      [Read more...]
    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.

    Open APIs are the new open source
    +1 Vote Up -0Vote Down

    We’ve seen the rise of open source software in the enterprise and also beyond the IT industry, but the real keys to openness and its advantages in today’s technology world — where efficient use of cloud computing and supporting services are paramount — exist in open application programming interfaces, or APIs.

    Open source software continues to be a critical part of software development, systems administration, IT operations and more, but much of the action in leveraging modern cloud computing and services-based infrastructures centers on APIs. Open APIs are the new open source.

    Read the full story at LinuxInsider.

    CAOS Theory Podcast 2012.01.20
    +0 Vote Up -0Vote Down

    Topics for this podcast:

    *Hadoop v1.0 and year ahead
    *Oracle-Cloudera deal for more Hadoop
    *Oracle’s ‘Sun spot’ with Solaris
    *Open Source M&A outlook for 2012
    *Our new MySQL/NoSQL/NewSQL survey

    iTunes or direct download (28:49, 4.9MB)

    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...]
    The future of commercial open source business strategies
    +0 Vote Up -0Vote Down

    The reason we are confident that the comparative decline in the use of the GNU GPL family of licenses and the increasing significance of complementary vendors in relation to funding for open source software-related vendors will continue is due to the analysis of our database of more than 400 open source software-related vendors, past and present.

    We previously used the database to analyze the engagement of vendors with open source projects for our Control and Community report, plotting the strategies used by the vendors against the year in which they first began to engage with open

      [Read more...]
    VC funding for OSS hits new high. Or does it?
    +0 Vote Up -0Vote Down

    One of the favourite blog topics on CAOS Theory blog over the years has been our quarterly and annual updates on venture capital funding for open source-related businesses, based on our database of over 600 funding deals since January 1997 involving nearly 250 companies, and over $4.8bn.

    There are still a few days left for funding deals to be announced in 2011 but it is already clear that 2011 will be a record year. $672.8m has been invested in open source-related vendors in 2011, according to our preliminary figures, an increase of over 48% on 2010, and the highest total amount invested in any year, beating the previous best of $623.6m, raised in 2006.

    Following the largest single quarter for funding for open

      [Read more...]
    WebOS and the open alternative live another day
    +0 Vote Up -0Vote Down

    There has been no shortage of reaction to HP’s move to make the Linux-based WebOS open source software. Below, I offer some of my thoughts on the meaning for the different players affected.

    *What’s it mean for WebOS?
    Moving WebOS to open source was best option for HP. It retains some value in the software depending on its involvement. It is also the best fate for the code, rather then being sold or simmered to its IP and patent value or even used as another weapon in the ongoing mobile software patent wars. Still, the move comes amid huge developer and consumer uncertainty for WebOS. Nevertheless, at least WebOS was already in the market with a compelling products, the Palm the Pre, in the modern smartphone market. WebOS will hopefully have a faster path to open source than Symbian since the former is based on Linux. I still think the greatest opportunity for

      [Read more...]
    451 CAOS Links 2011.12.09
    +0 Vote Up -0Vote Down

    Funding for BlazeMeter and Digital Reasoning. Red Hat goes unstructured. And more.

    # BlazeMeter announced $1.2m in Series A funding and launched the a cloud service for load and performance testing.

    # Digital Reasoning announced a second round of funding to help develop its Hadoop-based analytics offering.

    # Red Hat announced the availability of Red Hat Storage Software Appliance, based on its recent acquisition of Gluster.

    # Red Hat also

      [Read more...]
    05.12. Doctrine 2
    +0 Vote Up -0Vote Down
    Introduction

    Object-relational mapping (ORM) frameworks have been around for several years now and for some people, ORM is already outdated by now. As we have seen with other technologies and concepts before, PHP is not exactly what we call an early adopter among the programming languages. Thus it took some time for ORM to grow up in the PHP context.

    There have been some frameworks before Doctrine 2 that implement ORM (remember e.g. Propel) specific tasks but most of them lack the required maturity to be used in large projects. With Doctrine 2, PHP takes a huge step into the right direction – Doctrine 2 is fast, extensible and easy to use.

    This article will take you on a tour through the main concepts of Doctrine 2 in the first part and then explain how to use it in

      [Read more...]
    451 CAOS Links. 2011.12.02
    +0 Vote Up -0Vote Down

    Talend delivers v5. Zentyal raises series A. The TCO of OSS. And more.

    # Talend announced version 5 of its data integration suite, adding business process management capabilities via an OEM relationship with BonitaSoft. Yves De Montcheuil explained the name changes in version 5.

    # Zentyal closed a series A venture capital funding of over $1m by Open Ocean Capital.

      [Read more...]
    451 CAOS Links 2011.11.18
    +0 Vote Up -0Vote Down

    Rapid7 secures new funding. Microsoft drops Dryad. And more.

    # Rapid7 secured $50m in series C funding.

    # Microsoft confirmed that it is ditching its Dryad project in favour of Apache Hadoop.

    # Arun Murthy provided more details of Apache Hadop 0.23.

    # The Google Plugin for Eclipse and GWT Designer projects are now fully open source.

    # openSUSE released version 12.1.

    # Amazon

      [Read more...]
    VC funding for Hadoop and NoSQL tops $350m
    +0 Vote Up -0Vote Down

    451 Research has today published a report looking at the funding being invested in Apache Hadoop- and NoSQL database-related vendors. The full report is available to clients, but non-clients can find a snapshot of the report, along with a graphic representation of the recent up-tick in funding, over at our Too Much Information blog.

    CAOS Theory Podcast 2011.11.11
    +0 Vote Up -0Vote Down

    Topics for this podcast:

    *Continuent extends MySQL replication to Oracle Database
    *CFEngine updates server automation software
    *Devops moving mainstream
    *Neo Technology integrates with Spring
    *451 CAOS report from Hadoop World

    iTunes or direct download (26:56, 4.6MB)

    451 CAOS Links 2011.11.08
    +0 Vote Up -0Vote Down

    Cloudera raises $40m. Accel announces $100m fund. Rackspace takes OpenStack private. And more.

    # Cloudera raised $40m in series D funding and announced a partnership with NetApp around its NetApp Open Solution for Hadoop.

    # Accel Partners launched a $100m Big Data Fund to invest in Hadoop- and NoSQL-related vendors.

    # Rackspace

      [Read more...]
    451 CAOS Links 2011.11.01
    +0 Vote Up -0Vote Down

    Appcelerator raises $15m. Hortonworks launches Data Platform. And more.

    # Appcelerator raised $15m in a third round led by Mayfield Fund, Translink Capital and Red Hat.

    # Modo Labs closed a $4m investment from Storm Ventures and New Magellan Ventures.

    # Hortonworks launched its Hortonworks Data Platform Apache Hadoop distribution, as well as a new partner program. Eric Baldeschwieler put the

      [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)

    451 CAOS Links 2011.10.25
    +0 Vote Up -0Vote Down

    Microsoft: “more than half your Android devices are belong to us”. And more

    # Microsoft claimed that more than half of the world’s ODM industry for Android and Chrome devices is now under license to Microsoft’s patent portfolio following its agreement with Compal Electronics.

    # Hadapt expanded its board of directors and confirmed its $9.5m series A funding round.

    # Appcelerator entered into an

      [Read more...]
    Got open source cloud storage? Red Hat buys Gluster
    +0 Vote Up -0Vote Down

    Red Hat’s $136m acquisition of open source storage vendor Gluster marks Red Hat’s biggest buy since JBoss and starts the fourth quarter with a very intersting deal. The acquisition is definitely good for Red Hat since it bolsters its Cloud Forms IaaS and OpenShift PaaS technology and strategy with storage, which is often the starting point for enterprise and service provider cloud computing deployments. The acquisition also gives Red Hat another weapon in its fight against VMware, Microsoft and others, including OpenStack, of which Gluster is a member (more on that further down). The deal is also good for Gluster given the sizeable price Red Hat is paying for the provider of open source, software-based, scale-out storage for unstructured data and also as validation of both open source and software in

      [Read more...]
    451 CAOS Links 2011.10.04
    +0 Vote Up -0Vote Down

    Red Hat acquires Gluster. Adobe acquires PhoneGap. Oracle does Hadoop. And more.

    # Red Hat agreed to acquire Gluster for approximately $136m in cash. Red Hat CTO Crian Steven explained why.

    # Adobe announced its agreement to acquire Nitobi, creator of PhoneGap.

    # Oracle unveiled its Oracle Big Data Appliance, including Apache Hadoop and Oracle NoSQL database.

    # ODF 1.2 has been approved as an OASIS standard.

    # Univa

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

    Topics for this podcast:

    *Cloud M&A potential around OpenStack
    *Oracle’s commercial extensions for MySQL
    *Puppet Labs rolls out Enterprise 2.0, hosts PuppetConf
    *Basho bolsters Riak distributed data store in NoSQL race
    *Our latest special CAOS report, ‘The Changing Linux Landscape’

    iTunes or direct download (25:59, 4.4MB)

    451 CAOS Links 2011.09.30
    +0 Vote Up -0Vote Down

    Microsoft’s Android revenue. Tizen formation. And more.

    # As Microsoft announced its latest Android-related patent agreement with Samsun, Goldman Sachs estimated that the company will make $444m in revenue from Android patent deals for fiscal year 2012.

    # LiMo Foundation and The Linux Foundation announced the formation of Tizen to develop a Linux-based device software platform.

    # Karmasphere raised $6m in a series B round

      [Read more...]
    PuppetConf and the state of devops
    +0 Vote Up -0Vote Down

    It’s been some time now that we’ve been talking about devops, the pushing together of application development and application deployment via IT operations, in the enterprise. To keep up to speed on the trend, 451 CAOS attended PuppetConf, a conference for the Puppet Labs community of IT administrators, developers and industry leaders around the open source Puppet server configuration and automation software. One thing that seems clear, given the talk about agile development and operations, cloud computing, business and culture, our definition of devops continues to be accurate.

    Another consistent part of devops that also emerged at PuppetConf last week was the way it tends to introduce additional stakeholders

      [Read more...]
    MySQL at the core of commercial open source
    +2 Vote Up -0Vote Down

    Oracle last week quietely announced the addition of new extended capabilities in MySQL Enterprise Edition, confirming the adoption of the open core licensing strategy, as we reported last November.

    The news was both welcomed and derided. Rather than re-hashing previous arguments about open core licensing, what interests me more about the move is how it illustrates the different strategies adopted by Sun and Oracle for driving revenue from MySQL, and how a single project can be used to describe most of the major strategies from

      [Read more...]
    451 CAOS Links 2011.09.23
    +0 Vote Up -0Vote Down

    Red Hat revenue up 28% in Q2. Funding for NoSQL vendors. And more.

    # Red Hat reported net income of $40m in the second quarter on revenue up 28% to $281.3m.

    # 10gen raised $20m in funding, while DataStax closed an $11m series B round, while also releasing its DataStax Enterprise and Community products. Additionally Neo Technology

      [Read more...]
    451 CAOS Links 2011.09.07
    +0 Vote Up -0Vote Down

    HP builds Cloud Services on OpenStack. Linux on Github. And more.

    # HP announced the private beta program of its OpenStack-based HP Cloud Services.

    # Linus Torvalds made Linux 3.1 available on Github, albeit temporarily.

    # The National Security Agency proposed a new database, Accumulo, to the Apache Foundation for incubation.

    # Nominations for the Document Foundation board elections are now open.

    #

      [Read more...]
    Showing entries 1 to 30 of 337 Next 30 Older Entries

    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.