Tag: data types

Feed: Planet PostgreSQL. Date: 01.03.2021 Tags:   postgresql    pgxn    sqitch    pgtap    citext    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I’m a long-time open-source hacker in his early fifties. I’ve lived and worked in San Francisco, Portland OR, and now New York City. David E Wheeler How do you spend your free ... Read More

Feed: Planet MySQL; Author: Ovais Tariq; In 2016 we published blog posts (I, II) about Schemaless – Uber Engineering’s Scalable Datastore. We went over the design of Schemaless as well as explained the reasoning behind developing it. In this post today we are going to talk about the evolution of Schemaless into a general-purpose transactional database called Docstore.  Docstore is a general-purpose multi-model database that provides a strict serializability consistency model on a partition level and can scale horizontally to serve high volume workloads. Features such as Transaction, Materialized View, Associations, and Change Data Capture combined with modeling flexibility and ... Read More

Feed: Actian. Author: Lewis Carr. And why is it better than a Data Lake or an Analytics Hub? In the opening installment of this blog series—Data Lakes, Data Warehouses and Data Hubs: Do we need another choice?  I explore why simply migrating these on-prem data integration, management, and analytics platforms to the Cloud does not fully address modern data analytics needs. In comparing these three platforms, it becomes clear that while all of them meet certain critical needs, none of them meet the needs of business end-users without significant support from IT. What we in fact need is a platform ... Read More

Feed: Planet PostgreSQL. Millions of databases are being migrated to PostgreSQL today. This is because of the liberal PostgreSQL license in particular that invited more contributions to PostgreSQL and eventually made it Enterprise Grade. I have presented and also blogged about some of the rich enterprise features as following, those are otherwise available for an additional cost with some commercial databases. While it is great that there are several features available with Postgres by default, it may be challenging if there are no solutions to help with migrations to postgres. Fortunately, there are several contributions through extensions and Open source ... Read More

Feed: Recent Announcements. Today, AWS launched a new feature for static analysis of your event “detector models” (representations of your IoT devices as state machines on the AWS cloud) in AWS IoT Events. The feature automatically performs 7 different analyses (see list in developer guide) of your models for potential syntax errors (e.g. bad expressions or payloads), structural issues (e.g. missing states or input triggers) and runtime errors (e.g. data type mismatch, missing data, potential to hit service limits, etc.). This debugging tool is particularly useful for complex detector models which have a large number of state changes, each with ... Read More

Feed: Redis Labs. Author: Fredric Paul. Today we are excited to announce the general availability of RediSearch 2.0, bringing its powerful querying, indexing, and full-text search engine to all Redis users. In public preview since September 2020, RediSearch 2.0 has already garnered a growing list of customers who rely on it for a myriad of use cases from creating modern applications to full-text search to real-time analytics. RediSearch 2.0 introduces a brand new architecture that makes it more than twice as fast as RediSearch 1.6, and RediSearch now supports Redis Labs’ Active-Active geo-distribution and Redis on Flash.  Why RediSearch matters ... Read More

Feed: R-bloggers. Author: R Bloggers on Francisco Bischoff. It took some time, as you can see in the previous post, but the matrixprofiler package is done! What does this mean? The UCR Matrix Pofile is growing, undoubtedly, and the tsmp package is getting almost 700 downloads per month. We decided that we needed to separate the core from the practical usage of Matrix Profile. So the matrixprofiler package has been born and is focused on having the low-level code (C/C++), for speed and robustness. On top of that, the current tsmp package will focus on implementing the algorithms that use ... Read More

Feed: MariaDB Knowledge Base Article Feed. Author: . mariadb_schema is a data type qualifier that allows one to create MariaDB native date types in a SQL_MODE that has conflicting data type translations. mariadb_schema was introduced in MariaDB versions 10.3.24, 10.4.14, 10.5.5. For example in SQL_MODE=ORACLE, if one creates a table with the DATE type, it will actually create a DATETIME column to match what an Oracle user is expecting. To be able to create a MariaDB DATE in Oracle mode one would have to use mariadb_schema: CREATE TABLE t1 (d mariadb_schema.DATE); mariadb_schema is also shown if one creates a table ... Read More

Feed: Teradata Blog. Risk is ever evolving and financial institutions must continually strive to stay ahead of that evolution by orchestrating a myriad of point solutions for fraud and credit risk. According to Shift, the U.S. suffered nearly $25 billion in payment card losses in 2018.  Unfortunately, the U.S. is the most fraud-prone country in the world with more than one third of the world’s losses, growing at 15% annually. And, that fraud continuously evolves; what was once common, use of stolen card numbers gets locked down and the criminals move on to increasingly sophisticated attempts, such as account takeover.The ... Read More

Feed: Planet PostgreSQL. By Ryan Lambert -- Published February 16, 2021This post continues my quest to explore Postgres native partitioning and determine if it is a good fit for my OpenStreetMap data in PostGIS. I show how I am planning to implement a partitioning scheme in a way that a) works well for my use case, and b) is easy to implement and maintain.My previous post covered why I think partitioning will be a benefit in our databases. There will be at least one more post to follow this one that examines the performance impacts of partitioned data. The following ... Read More