Oracle Database 23.4 Free now available on gvenzl/oracle-free

~ Gerald ~ Leave a comment

Last Thursday (2nd of May 2024), Oracle released Oracle Database 23ai on Oracle Cloud but included Oracle Database 23ai Free for on-premises. Some of you may have already heard that 23ai is the new name for 23c, so what you get is still Oracle Database 23.4 and it’s the same code base as 23.3 and 23.2 before. The difference is that 23.4 comes with a lot more AI-related features, given last year’s change in focus in the industry, such as a new VECTOR data type and Vector Search. Anyway, that’s probably worth a blog post on its own. But it is important for the users of gvenzl/oracle-free to understand that 23ai is not a brand new release that may need some migration or code changes in your app, it’s simply the new name for what was supposed to be 23c.

Continue reading “Oracle Database 23.4 Free now available on gvenzl/oracle-free” →

How to Use Databases Inside GitHub Actions

~ Gerald ~ Leave a comment

GitHub Actions is a platform that automates the build, test and deployment pipeline of your GitHub projects. Since its introduction, GitHub Actions has been steadily gaining popularity among developers. Not only do GitHub Actions help automate the test and integration cycles, but it can also drastically shorten them, accelerating developer feedback as part of the process.

Continue reading “How to Use Databases Inside GitHub Actions” →

1 billion row challenge in SQL and Oracle Database

~ Gerald ~ 24 Comments

On the 1st of January 2024, Gunnar Morling launched The One Billion Row Challenge, fitting for a great start to the new year. As the challenge states:

Your mission, should you decide to accept it, is deceptively simple: write a Java program for retrieving temperature measurement values from a text file and calculating the min, mean, and max temperature per weather station. There’s just one caveat: the file has 1,000,000,000 rows!

Not surprisingly, the challenge has become widely popular on the internet and spilled over to other languages and technologies, including Go, Python, Rust, .NET, C, and, to no surprise SQL as well, given that SQL does well when it comes to aggregations.

Continue reading “1 billion row challenge in SQL and Oracle Database” →

Introducing Oracle Database 23c Free

~ Gerald ~ Leave a comment

Oracle Database 23c Free, a free offering of the industry-leading Oracle Database that enterprises rely on every day, is now generally available.

Oracle Database 23c Free is packaged for ease of use and a full-featured experience, making it the perfect entry-level database for anyone who wants to Develop, Learn, and Run an Oracle Database for Free. It is available straight from the web, with no user account or license click-through requirements, enabling simple and fast access to the world’s only converged database that supports all data models and workload types. It can be downloaded as a standalone file, Container image, or VirtualBox appliance.

Oracle Database Free is the successor of Oracle Database Express Edition (XE). It is released under the same Free Use Terms and Conditions, resource limits, and community support as its predecessor. Users of Oracle Database Express Edition are advised to upgrade to Oracle Database 23c Free now to take advantage of the latest and greatest features of Oracle Database.

The built-in upward compatibility with Oracle Database Enterprise Edition and Oracle Database cloud services ensures that users of Oracle Database Free can move to any other Oracle Database offering anytime.

Users of Oracle Database 23c Free – Developer Release, the developer-exclusive, first release of Oracle Database 23c, are advised to upgrade to Oracle Database 23c Free. Oracle Database 23c Free – Developer Release is no longer available for download.

For more information about Oracle Database Free, see https://oracle.com/database/free.

This blog post was originally published at https://blogs.oracle.com/database/database-23c-free-ga

Introducing the Oracle Database Error Help Portal

~ Gerald ~ Leave a comment

In a continuous effort to increase user productivity, we are pleased to introduce the new Error Help Portal for Oracle Database, which will help users gain faster and improved insights into Oracle Database errors.

You can easily access the new portal via https://docs.oracle.com/error-help/db/ and the Oracle Database Documentation landing page:

Continue reading “Introducing the Oracle Database Error Help Portal” →