![]() “PostgreSQL can create a virtually unlimited read cluster”. There are a lot of APIs for extensions, but the vendor must have to control what runs in the engine in order to provide support. Commercial, which means with vendor supported. Oracle is multi-platform proprietary software. Yes, to be platform-independent, and has many other External Authentication: Extensibility “Oracle has a built-in authentication system.” The latest trend being JSON: Authentication Support for the structures and languages you mention are all there. And it is not (only) about HTML, JSON, or XML but is a low-code Rapid Application Development with no equivalent for other databases. HTML DB can be found in paper books, but the name is “APEX” since 2006. PostgreSQL natively supports JSON, XML and plugs in Javascript”. “Oracle acknowledges the existence of HTML through HTML DB. You can also use any “any character encoding, collation and code page” but not relying on the OS implementation of it makes it cross-platform compatible and OS upgrade compatible (see ) Web Development ![]() The “globalization toolkit” is only one part of the globalization features. In order to access internal structures, which is what you mention, Oracle provides relational views (known as V$ views) accessible with the most appropriate API for a relational database: SQL Internationalization and Localization Providing an “API to communicate with the database” is not about open source as the main goal is: encapsulation and hide implementation details. ![]() You mention languages as “as plug-ins” and for this, there are other ways to run different languages (external procedures, OJCM, External Table preprocessor,…) but when it comes to performance, transaction control, dependency tracking,… that’s PL/SQL. That’s different from PL/pgSQL which is interpreted at execution time. It is compiled (to pcode or native), manages dependencies (tracks dependencies on schema objects), optimized for data access (UDF can even be compiled to run within the SQL engine), can be multithreaded (Parallel Execution). “Oracle has a built-in programming language called plSQL.” If your goal is to federate and distribute some small reference tables, then Materialized Views is the feature you may look for. ETL needs optimized bulk loads and there are other features for that (like External Tables to read files, and direct-path inserts to fast load). But anyway, I would never use that for ETL. The closest from your description is Database links and Heterogeneous Services through Database Gateway. As an example, nobody will get search hits for “Federation”, or “plSQL”, or “HTML DB”… in the Oracle documentation but they will find “Oracle Gateway”, “PL/SQL”, “APEX”… Federation vs. I’m afraid they may not recognize the names and descriptions you provide, at least in current versions. In italics are the quotes from the article.Īs you do a comparison and link to a list of PostgreSQL features, let me refine the name and description of the Oracle features you compare to, so that people can find them and do a fair comparison. It is totally valid to consider a move to Open Source databases, but doing it without good understanding is a risk for your migration project success. You should never take any decision on what you read on the internet without verifying. ![]() I originally wrote this as a comment on the following post that you may find on internet: īut my comment was not published (many links in it… I suppose it has been flagged as spam?) so I put it there.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |