Norvald H. Ryeng

MySQL 8.0 supports SQL feature T491 LATERAL derived table, also called the "for each" loop of SQL. What is it? How does it work? How can you use it? What is it good for? Learn all about it in this talk!

MySQL 8.0 is right around the corner, and the most important new spatial feature is support for geography and ellipsoidal coordinate reference systems (CRSs). The final release is not out yet, but there is a release candidate, so we know what to expect.

In this talk we'll go on a tour of the spatial support in MySQL with a focus on the new features in 8.0, especially those related to geography and ellipsoidal CRSs.

What can MySQL do? Which ellipsoids/CRSs does MySQL support? Can I create my own? Which functions can I use? How does it work? Are there limitations? These questions, and more, will be answered by this talk.

GIS development was ramped up in MySQL 5.7, and we expect GIS support to be greatly improved in the coming versions. MySQL 8.0 is still in development, but we're starting to see the first GIS enhancements pushed into development releases. What is new? In which direction is MySQL going?

In this talk, we will look at the plans for GIS in future versions of MySQL, and in MySQL 8.0 in particular. We'll cover the big overarching design decisions, what it means for the future direction of GIS in MySQL, and how it translates into implementation of specific new functionality.

This talk is both for those that know GIS and would like to know what MySQL can offer, and for those that know MySQL GIS today and want to know what to expect in future versions.

What is an SRID, and why should I care? Does MySQL care? The answers to these questions and more will be given in this talk as we give a quick introduction to GIS in general and in MySQL in particular. MySQL 5.7 gave GIS a real boost, and more is to be expected in the future. If you're not using it yet, it's time to get started!

This crash course covers data types, import, export, indexing, operations on GIS data, caveats and how to prepare for the future of more and better GIS in MySQL. If you've never used GIS before and are curious to learn, or if you already know GIS and want to know how MySQL supports it, this talk is for you.

The first stable version of MySQL 5.7 was released in October with a large number of new features and improvements, such as JSON support, new optimizer hints, functional indexes, a query rewriting framework, a new optimizer cost model, new GIS functions, a number of InnoDB improvements, Group Replication, Fabric, performance schema extensions, SYS schema, Workbench, and much more!

This talk covers all that and more. We won't go into the details of every feature, but we'll get a quick overview of what's new and how all the individual pieces fit together.

The first stable version of MySQL 5.7 was released in October with a large number of new features and improvements, such as JSON support, new optimizer hints, functional indexes, a query rewriting framework, a new optimizer cost model, new GIS functions, a number of InnoDB improvements, Group Replication, Fabric, performance schema extensions, SYS schema, Workbench, and much more!

This talk covers all that and more. We won't go into the details of every feature, but we'll get a quick overview of what's new and how all the individual pieces fit together.

Web maps are everywhere these days, and there are a lot of frameworks that can display a map. But you still have to provide the data yourself. This talk teaches you how to use MySQL with its GIS functions in the database back end for your maps.

MySQL GIS is getting a boost in 5.7 with InnoDB R-trees, new GIS functions and more accurate results. This talk presents the new functionality by leading the audience through a step by step guide to making a simple web map service.

The target audience is MySQL users that want to learn the basics of how to display their data in a map. Users that already know MySQL GIS will learn about the new features in 5.7.

How is it to be a fairly large project upstream of several Linux distributions? How is it do be downstream of such a project? Among the challenges are coordinating between distributions, handling different expectations from distributions and users, and technical issues such as making the software easy to package. Using MySQL as the example, we'll go through several real-life cases and try to see them from both sides of the developer-maintainer relationship.

MySQL is the world's most popular open source DBMS, with a large user base on Linux, Windows, OS X, FreeBSD, Solaris, and others. Besides direct download from the upstream web site and package repositories, Linux distributions are the major delivery channels for MySQL. This talk is based on real-life experiences in the upstream-downstream relationship between MySQL and the major Linux distributions over the last few years.

Among the topics covered are upstream's role in coordinating between the different distributions, how to handle distributions that deliver on platforms that are unsupported by upstream, handling bugfixes and requests for new features in stable releases, and how having an upstream package repository can improve the quality of packages in the distributions.

The target audience is software developers that have or want to have their software packaged for one or more Linux distribution, package maintainers in distributions, and end users wanting to understand more about how Linux distributions are made.