Editing Ingres (database) (section)

=== Ingres release history ===
{| class="wikitable"
|-
! Release
! General availability
! End of Enterprise Support
! End of Extended Support
! End of Obsolescence Support
! Notes
|-
! {{Version |o |Ingres 6.4}}
| September, 1991
| 30-Sep-01
| {{N/A}}
| 31-Dec-08
| 
|-
! {{Version |o |OpenIngres 1.x & 2.x}}
| January, 1996
| September 31, 2000
| {{N/A}}
| {{nowrap|31-Dec-08}}
| It integrated an unstructured data type (audio, video, blob), temporary tables (in memory) and the Visual DBA administration suite
|-
! {{Version |o |Ingres II 2.0}}
| February, 1999
| 1-May-05
| {{nowrap|31-Dec-08}}
| 31-Dec-13
| Line locking, variable page size, massive loading, server level replication (the old system of capturing data modifications by rules has been abandoned).
|-
! {{Version |o |Ingres II 2.5}}
| July, 2001
| 31-Dec-07
| 31-Dec-12
| 31-Dec-17
| First Ingres version for [[Linux]]. This version also made it possible to fully exploit 64-bit architectures. Introduction of the [[Java Database Connectivity|JDBC driver]].
|-
! {{Version |o |Ingres II 2.6}}
| May, 2002
| 31-Dec-09
| 31-Dec-14
| 31-Dec-19
| First enterprise-class DBMS to fully exploit the 64-bit architecture under Linux. Support for XML, Unicode and improvement and splitting of administration tools (Ingres Visual Manager, Ingres Performance Monitor, Ingres Import Assistant, Ingres Visual SQL, etc.).
|-
! {{Version |o |Ingres R3}}
| November, 2004
| 31-Dec-07
| {{N/A}}
| {{N/A}}
| Computer Associates makes Ingres R3 open source under the CATOSL license. Support for partitioned tables, parallel query and a new data optimization algorithm.
|-
! {{Version |o |Ingres 2006 (9.0 & 9.1)}}
| March, 2007
| 31-Dec-11
| 31-Dec-16
| 31-Dec-21
| Entry of Ingres into the world of open source products (under GPL license). Stability, further enhanced functionality and performance, ease of installation. Release of IceBreaker BI.
|-
! {{Version |co |Ingres 9.2}}
| November, 2008	
| 31-Dec-15
| 31-Dec-20
| 31-Dec-25
| Improved support for JDBC, .Net and PHP in terms of performance. Log shipping features and UTF-8 support.
|-
! {{Version |co |Ingres 10.0}}
| September, 2010	
| 31-Dec-16
| 31-Dec-21
| 31-Dec-26
| The release contains a number of major enhancements that minimize application development time when migrating applications from other databases to Ingres. New features include support for [[multiversion concurrency control]] (MVCC), high-performing batched statement execution, full scalar subquery support, support for identifiers up to 256 characters long, and column-level data encryption. The release supports an automated, seamless migration from earlier versions of Ingres.
|-
! {{Version |co |Ingres 10S (10.1)}}
| May, 2012	
| 31-May-17
| 31-May-22
| 31-May-27
| Includes comprehensive spatial support, allowing to extend location-based data through spatial-aware applications, avoiding complex add-ons and integrations with other databases, and no need to pay extra to access geospatial features.
|-
! {{Version |co |Ingres 10S (10.1) - VMS Itanium Only}}
| April, 2014	
| 31-May-18
| {{nowrap|31-May-23}}
| {{nowrap|31-May-28}}
|
|-
! {{Version |co |Ingres 10.2}}
| 4-Sep-14	
| 1-Sep-19
| 1-Sep-22
| 1-Sep-25
| New features include 2-D, 3-D and 4-D Spatial Data Types, Remote GCA, UTF-8 Transliteration, DBMS Level Authentication, IPV4 and IPV6 Data Types and Functions and Per-query Parallelism Level. Users can also take their first steps into Big Data Analytics by applying the new Windowing functions to their existing transactional data.
|-
! {{Version |co |Ingres 11.0 (Solaris SPARC, Solaris AMD, AIX and 32-bit Windows)}}
| 31-Mar-17	
| 31-May-23
| 31-May-27
| 31-May-32
| Ingres 11 includes two significant additions for application integration and monitoring. IngresConnect provides an end-to-end solution for designing, deploying and managing data integration, and the Actian Enterprise Monitoring Appliance (EMA) can use [[Nagios]] compatible plug-ins now in Ingres to monitor Ingres environments.

Ingres 11 also contains many new geospatial, performance, ease-of-use and security features. A few of the highlights are: ArcGIS plug-in, [[Query optimization|query optimizer]] reuse heuristics, automatic log file rotation, IANA timezones, Y2K38 fix, blob encryption and AES password encryption.
|-
! {{Version |co |Ingres 11.0 (VMS Itanium and HP Itanium)}}
| 31-Mar-17	
| 31-May-23
| 31-May-27
| {{CNone|(None offered, platform not supported by HPE after Dec 2028)}}
|
|-
! {{Version |co |Ingres 11.2 (VMS Itanium and HP Itanium)}}
| 6-May-22	
| 31-Dec-25
| {{CNone|(None offered, platform not supported by HPE after Dec 2028)}}
| {{CNone|(None offered, platform not supported by HPE after Dec 2028)}}
|
|-
! {{Version |co |Ingres 11.2 (Solaris SPARC, Solaris AMD, and AIX)}}
| 6-May-22	
| 31-May-27
| 31-May-32
| 31-May-37
| Ingres 11.2 contains many new management, development and security features. Ingres 11.2 introduces Workload Management Phase 1, [[JSON]] Support, [[Data masking|Data Masking]] for sensitive data, Partition Management, [[Pivot table|Pivot Tables]], and Encryption Initialization Vectors, among other changes.

Ingres 11.2 also contains a development release of SQL UDFs with development-only support.
|-
! {{Version |c |Ingres 12.0 (Linux, Windows)}}
| 31-May-24
| 31-May-29
| 31-May-34
| 31-May-39
| For Ingres 12.0, Actian decided to withdraw the Actian X brand from the market, with the new release of Ingres inheriting its capabilities and the X100 engine. Other improvements include:

* Cloud Backup & Disaster Recovery: Simplifies on-premises and cloud deployments with VMs or Kubernetes, reducing risks of downtime and data loss in disasters.

* Enhanced Security: AES-256 encryption and fortified protection defend against cyber threats, such as brute force and DoS attacks.

* Boosted Performance: X100 engine increases query speeds by 20%, while Workload Manager 2.0 improves resource allocation flexibility.

* Improved Developer Experience: OpenROAD 12.0 accelerates app modernization for web/mobile, preserving existing business logic.

* gRPC Server Architecture: Enables cloud integration for modern clients, enhancing business logic adaptability.

Check the New Features section, on the official documentation,<ref>{{Cite web|url=https://docs.actian.com/actianx/12.0/index.html#page/RelSum/NewFeatures.htm|title=Actian Ingres 12.0 New Features|website=docs.actian.com}}</ref> for a complete list.
|-
! {{Version |c |Ingres 12.0 (Solaris SPARC, Solaris AMD and AIX)}}
| 31-May-24
| 31-May-29
| 31-May-34
| 31-May-39
| Ingres 12.0 introduced High Availability option with a Solaris Sparc cluster
|-
! {{Version |c |Ingres 12.0 (VMS x86)}}
| 20-Sep-24
| 20-Sep-29
| 20-Sep-34
| 20-Sep-39
|
|}
{{Version|l|show=111100}}

With the announcement of Ingres 9.1 (Ingres 2006 release 2) on the [[OpenVMS|VMS]] platform the support dates for VMS will now follow the normal Actian release dates as listed above with the following exceptions; dropping of the Alpha VMS 2.0 release has been announced and Enterprise Support ended on December 31, 2009 with Extended Support offered through December 31, 2013. All support for [[VAX]] VMS ended on December 31, 2008.<ref>{{Cite web|url=https://communities.actian.com/s/supportservices/lifecycle-dates/actian-x-ingres|title=Actian X and Ingres|website=communities.actian.org}}</ref>