Blog
Oracle - MySQL Bootcamp
Oracle - MySQL Bootcamp

Oracle – MySQL Bootcamp in Dusseldorf (the boys on tour)

BSL is extremely experienced in the use of Oracle databases – we have been an Oracle partner for many years. Our developers were recently invited to take part in a MySQL Bootcamp. The aim? To learn more about the MySQL Enterprise edition, the commercial version of this product.

What is MySQL?

MySQL is the world’s most popular open-source database. It’s therefore no coincidence that MySQL is supplied as part of LAMP. The LAMP web development platform bundles together the 4 open-source components used most frequently in web applications. Namely Linux, Apache, MySQL, and PHP.  Such is it’s success that MySQL is now used in large commercial organizations such as Google, Twitter, Facebook. As well as leading Web applications such as Booking.com.

Oracle takeover

Oracle took over MySQL in 2010. At the time, there were concerns about the product’s future as Oracle has its own database. However these concerns proved unfounded. Oracle continues to develop MySQL. MySQL is freely available under a GPL license. However, developers and businesses can also choose to purchase a commercial edition, giving them access to support services and a range of additional plugins. For example, backup, data masking or auditing plugins. We’ll come back to some of these later in the blog.

Bootcamp

The 3-day Bootcamp was a mixture of theory provided by trainers, followed by hands-on experience in a series of workshops. Servers were available running both Linux and Windows. Firstly we were told about the basics of MySQL. We then installed MySQL on both platforms, and created users. And because we were working with MySQL version 8, we were able to use the new MySQL client shell. Features in this updated shell include support for automatic text completion, searches for previously used commands, and JavaScript/Python commands.

 

Food for thought

Oracle not only fed our brains but our stomachs too! To help us to absorb all the new information, Oracle arranged an energy-packed lunch each day. Dishes of sausages, pasta, potatoes, and more besides. And for anyone that may have missed breakfast (or just had a big appetite), there were sandwiches in the morning, and biscuits and snacks throughout the day.

 

What did we learn?

Fully energized,  we learnt about the internal workings of MySQL. Including how tables, rows and indexes are created and stored. We learnt too how the MySQL Documents Store plugin supports record storage in JSON. The JSON is validated by the database, and even the individual fields are accessible! We also discovered how the Firewall works. How it can block SQL statements if they are not included in a whitelist of permitted statements. At the same time, we could monitor the database using the MySQL Enterprise Monitor. The Monitor not only gives information about, for example, complex, ineffective statements. But recommendations for improvements too. And to round off the practical training, we set up database replication using a master/slave system.

Participants in the MySQL Bootcamp

Oracle - MySQL Bootcamp

Jurjen Schröder
Java developer at BSL, responsible for projects such as PricewaterhouseCooper (PwC) Pulse and ABN AMRO SRS.

Specialist areas:
– Design and development of Java applications
– Development of web pages using JavaScript and HTML.

How I’ll apply the Bootcamp knowledge:
– To build on and expand my database knowledge. Until now, I’ve mainly used databases using simple, hand-written queries. I found it particularly interesting to learn about setting up backups and replications for your database.

 

Oracle - MySQL
Eric Wijnands

Software architect at BSL, responsible for projects such as NBD Biblion MIPS/MOM, ABN AMRO SRS, Literatuurplein, and CRV Mediabank.

Specialist areas:
– Consultancy, functional/technical design
– Design-/development of Oracle, SQL Server databases
– Software development

How I’ll apply the Bootcamp knowledge:
– When advising clients about solutions where MySQL Enterprise can play a role, or where it can be an alternative for Oracle.

MySQL Bootcamp – a valuable experience

So all in all, a really valuable training! If you would like to know more about MySQL, and the benefits of the commercial edition, or if you need help with your MySQL project, then contact BSL. We have the know-how and skills in-house!

A new website for BoekWijzer

A new website for BoekWijzer

We’ve completely revamped the BoekWijzer website! The website was built to support the BoekWijzer app, the mobile guide to the world of Dutch literature. Using the app, you can quickly and easily stay up to date with the latest literary news.

New developer / web designer at BSL

New developer / web designer at BSL

If you have any questions about your website or web design in general, then Patrick van Bennekom is ready to help you five days a week at BSL. Patrick helps to design and create websites and apps for our customers, including the design of logos and house styles to deliver a professional end product.

Migrating to the Cloud, benefits and opportunities

Migrating to the Cloud, benefits and opportunities

Several of our clients are migrating to the Cloud, and some that aren’t yet ready for this step are reviewing their legacy systems, intending to migrate to the Cloud in the future. We’ve recently completed two migrations on behalf of multinationals, and our experience has taught us that a direct approach (simply redeploying existing databases and applications on virtual machines) is not always the best route…

Beleev: Controlled Multisensory Environments

Beleev: Controlled Multisensory Environments

Perhaps you have never heard of snoezelen, a Dutch term that describes controlled multisensory environments (MSE) that stimulate various senses within a custom environment – a so-called “Snoezel” room. On behalf of St. John the Baptist special education school in Kerkrade, we’ve created custom software to create and manage so-called “Snoezel” rooms, controlling, lights, audio, switches and a video projector.

Goodbye 2021 and COVID-19 lockdowns – It’s time to look back

Goodbye 2021 and COVID-19 lockdowns – It’s time to look back

So who, in early 2020, thought that we’d still be operating under COVID-19 lockdown measures in January 2022? Luckily, my skill set has given me a better understanding of software development and technology than catering or hospitality. As director of an IT company, I’m happy to say that Bright Side of Life has taken to remote working as a fish to water. Let me tell you about our year.

Canon of the Netherlands apps now available in stores

Canon of the Netherlands apps now available in stores

The Dutch Canon of the Netherlands (2007) tells the story of how the Netherlands was formed. Using the Canon, BSL developed the popular EnToen Nu apps for iOS and Android a few years later. In 2020, the Canon was extensively revised, so we’ve completely rewritten the Canon apps, bringing them up-to-date, making them faster and even more fun to use. They’re now available in the app stores.

Integrating powerful AI search capabilities within apps and web-services

Integrating powerful AI search capabilities within apps and web-services

Search technology is continually evolving, so we’re always ready to adopt new technologies to meet specific client needs. This blog outlines our recent experiences with Azure Cognitive Search and Cognitive Search AI services – that we’re using to classify thousands of new documents each day, delivering customised briefings to subscribers. Using Machine Learning and AI we can create intelligent search prototypes in just a few weeks.

Canon van Nederland apps coming soon!

Canon van Nederland apps coming soon!

The Committee on the Development of the Dutch Canon developed the Canon van Nederland in 2007. BSL developed the EnToen app a few years later, and since its launch in 2013, it has been a top-rated school app. In 2020, a new Canon Committee updated the Canon. We’re now busy working on new Canon Apps, with a modern look, and using the latest technical know-how.

Drupal 9 replaces Drupal 8. Long live Drupal 7!

Drupal 9 replaces Drupal 8. Long live Drupal 7!

Drupal 9 arrived last year, and Drupal 8 is end-of-life in November 2021. Nothing strange about this. But did you know that Drupal 7’s life has been extended to November 2022? Due to the high number of active users, it will remain in use longer than Drupal 8! Nevertheless, if you’re still using Drupal 7, you’re drinking in the last chance saloon, and it’s time to plan your transition to Drupal 9.

BSL delivers a new Pulse importer using the Forrester API

BSL delivers a new Pulse importer using the Forrester API

We developed our “Pulse” Business Intelligence Software for PwC. It’s a global service, maintained and supported by BSL. Pulse imports thousands of documents daily from commercial content providers and website feeds, delivering personal briefings to PwC subscribers throughout the PwC organisation. At the request of PwC, we recently created a new importer for Forrester using their API.

Outsourcing, retainers and long-term development partnerships

Outsourcing, retainers and long-term development partnerships

It’s not always straightforward for even large companies to create cutting edge development teams, as their core business may not be related to IT. Moreover, even when IT is a significant part of their business, there is frequently a wide gap between delivering core services and innovating with new technologies. BSL offers development services that can help fill the gap.

Machine Learning technology for Library services

Machine Learning technology for Library services

We’ve worked for many years with NBD Biblion, a unique organisation that selects and distributes books to public libraries in the Netherlands. They recently introduced Machine Learning (ML) technology to automate their client recommendations. After this success, NBD Biblion asked BSL to integrate a new Machine Learning service with MIPS, developed by BSL.

Drinks and a movie at BSL

Drinks and a movie at BSL

Enjoying a few drinks and watching a film together was a regular feature of life at BSL. I write ‘was’ because COVID-19 has kept most of us working from home. As a result, sharing a drink and watching a film together has not been an option. So instead, we’ve organised Digi-parties, Easter surprises and other events. Most recently, we arranged for everyone to enjoy a movie at home.

Two BSL anniversaries in May, time for a party

Two BSL anniversaries in May, time for a party

Two BSL anniversaries this week. Senior developer Peter Verbaan has been a key resource within BSL for 15 years, and front-end developer Roderick Gadellaa for 5 years. Reason enough for a party, you might say, and that’s something we love at the “Bright Side of Life.” For now, Corona makes this impossible, so it’s an online drink and a virtual hug.

Designing a simple phone app for 1888 information numbers

Designing a simple phone app for 1888 information numbers

1850 BV has asked us to design and develop a new simple phone app for Android and iOS, designed to help people who have difficulty using modern smartphones. After all, not everyone is excited about all the hundreds of features provided by a typical smartphone. It’s hard for people who lack the technological skills to figure all this stuff out. And or course, many simply find tiny screens challenging.

Early to market? Try developing a Minimum Viable Product

Early to market? Try developing a Minimum Viable Product

Entrepreneurs frequently contact us with ideas for their ground-breaking app, web-service, or web application. Their market research completed, business plan ready, financial backing sorted. They want to start, and get their product to the market as quickly as possible. This is when we introduce the concept of an MVP or Minimum Viable Product.

The Entoen Nu app makes history lessons easy

The Entoen Nu app makes history lessons easy

Do you sometimes have trouble with Dutch history? The EnToen Nu app is intended for those interested in Dutch culture and history, particularly children from grade 5 up to and including secondary school. It can be used at school, and at home. We’ve recently updated the app, adding support for the latest version of the Canon of the Netherlands.

SRS: New Job Model and Access Governance Foundation

SRS: New Job Model and Access Governance Foundation

Since developing the original Signature Registration System (SRS) on behalf of a large international bank we’ve made many changes. Migrating SRS to an Azure SQL cloud service is our current focus, but earlier this year we worked on two other infrastructure changes: Introducing NJM (New Job Model) and AGF (Access Governance Foundation) support in SRS.

Oracle migration to Azure SQL database – Part 2

Oracle migration to Azure SQL database – Part 2

In recent months, two clients have asked us to migrate legacy Oracle systems to Azure. In the previous blog, we explained how our tiered web applications make it easy to maintain our software and to migrate from one database to another. We asked Eric Wijnands to tell us about one of these migrations, moving a Banking solution from Oracle to Azure SQL.

Oracle migration to Azure SQL database – Part 1

Oracle migration to Azure SQL database – Part 1

Is Azure the flavour of the month? We’ve been approached by two clients in recent months to help them transition legacy Oracle systems to an Azure Cloud database. We’ve been building tiered database solutions for many years, with Front-end web applications calling web-services that use Oracle databases for storage. Just how easy is it to migrate these applications to Azure?

BSL creates a new Corporate site for WCC Group

BSL creates a new Corporate site for WCC Group

The WCC Group is a leading provider of advanced solutions for Public & Private Employment Services and ID/Security government agencies. Two years ago we designed and developed a dedicated Careers site to help find the specialized personnel needed to support their rapid expansion. This year they asked us to create a new, modern, responsive Corporate site.

Bright Side of Life Director – Martyn Simpson – Part 2

Bright Side of Life Director – Martyn Simpson – Part 2

In his previous blog, Martyn introduced us to his time working for Computervision/CIS, creating custom solutions for their clients. Experiences that he uses daily within BSL. After leaving CV, he continued to travel, working firstly with a company you’ve maybe never heard of (although you’ve probably used their products). And then with a company that you all know: Apple Computer.

Bright Side of Life Director – Martyn Simpson

Bright Side of Life Director – Martyn Simpson

So rounding off our current series of Bright Stories, it’s the turn of Martyn, our director. Martyn created the Bright Side of Life more than 25 years ago, and he’s been developing software since 1977. It’s not easy to condense 43 years of software development into a single blog, so in this first part, we find out just why he became a software developer, with some “Lessons Learned” on the way.

Front-end Developer – Roderick Gadellaa

Front-end Developer – Roderick Gadellaa

Continuing our “Bright Stories”, this week we turn our attention to Front-end Developer, Roderick Gadellaa. Someone with a very sweet tooth, and who enjoys solving design and UX problems. You’ll frequently find him on Twitter, tweeting about design changes and concepts. Here at BSL, Roderick’s enthusiastic whistling and singing are part of our soundscape!

PA / Customer Relations Manager – Caroline Bos

PA / Customer Relations Manager – Caroline Bos

As part of our “Bright Stories” series, it’s now the turn of Caroline, PA / Customer Relations Manager at BSL. We tell you why her varied background, outgoing personality, and talent for organization make her ideal for the role. Connecting and communication with people is in her DNA! Having worked nearly 8 years at BSL, she plays a pivotal role in our organization.

Software Developer – Jurjen Schröder

Software Developer – Jurjen Schröder

Our “Bright Stories” campaign is your chance to get to know some of the talented individuals that make up the Bright Side of Software. This week, the spotlight is on one of our software developers: Jurjen Schröder. An opportunity to find out more about Jurjen, and at the same time discover why he keeps some very unusual housemates!

Agile working is a success even during Corona

Agile working is a success even during Corona

Agile working is ideal for teams working remotely. Although we’ve used Agile for several years, there’s always room for improvement. Flexibility is part of this approach. Each client has their preferences, and so we refine our working methods to suit each customer. Fortunately, this type of refinement is more or less built-in to Agile: The Sprint Retrospective…

NBD’s LiteRom and Uittrekselbank online websites refreshed

NBD’s LiteRom and Uittrekselbank online websites refreshed

Agile development is part of our culture. During two recent Sprints, BSL delivered new versions of NBD’s Literom and Uittrekselbank online web services. LiteRom contains thousands of book reviews, as well as many articles about authors. Uittrekselbank subscribers can access thousands of extracts about books, as well as detailed author profiles. Find out more in our blog…

Working from home, but staying connected

Working from home, but staying connected

We’re working from home as much as possible due to the Coronavirus (COVID-19). We’re doing all we can to keep Business as Usual. Technical innovation is part of our DNA, and so we’re perhaps finding this easier than others. Nevertheless, we are having to change the way we work in response to these challenges. Our blog tells you about some of the steps we are taking.

Eric Wijnands, Designer and Developer, with a love of Jazz

Eric Wijnands, Designer and Developer, with a love of Jazz

BSL has always looked for designer and developer candidates who have their own stories to tell. Rounded individuals who offer more than just IT skills. Our work frequently begins with understanding the work carried out by our clients. So we supply inventive teams that deliver usable, productive solutions – not just code. Offering designers and developers with wide interests outside of IT.

4

Previous

5

Next

    Get in touch

      Contact BSL
      Contact BSL