EnterpriseDB NewsEnterpriseDB NewsNews and Commentary regarding EnterpriseDB, the Oracle compatible database built from PostgreSQL. Articles
Not working for EDB anymore
2008-07-19 19:58:00 Well, I am no longer working for EnterpriseDB. It was fun while it lasted but it's over so I am moving on. I found a new job, locally. It's pure Oracle and I will get to use Real Application Clusters in a production environment. That's something I haven't done in the past so I am looking forward to it. It's also a java, .net and Oracle Forms shop and they are doing some interesting things with telecommunications and SMS.From now on, I will only need to travel for conferences. No more trips to New Jersey. That's kind of a drag as I was almost at elite status on Continental. I have two more conferences this year and it just might be enough. I may even take a trip on my own just to get the miles. One of the trips is from Tampa to San Francisco, and back, so that will get me very close. The other is to Virginia and back.I am a database geek and I will be keeping an eye on EDB just as I did in the past. I will probably post here at the EDB blog about as frequently as I have been (n...
EnterpriseDB Gets a New CEO
2008-06-04 15:59:00 LewisC's An Expert's Guide To Oracle TechnologyLooks like I have a new boss. Actually, it looks like my boss's boss has a new boss. ;-)I'd like to personally welcome Ed Boyajian to EnterpriseDB. Looks like he has quite a bit of experience with OSS and monetizing software solutions. He's been an executive at Redhat for a long time. 6 years in his last position but in many other positions before that.We (EnterpriseDB employees) have known this was coming for a while now. I knew Andy and the board were looking when I was hired. I just now learned the name of the chosen, though. It's always interesting in a company when executive leadership changes hands.I like Andy (Astor, the ex-CEO) and I'm glad he's staying as the new executive VP of Business Development. I believe that is where his strength (i.e. past experience) lies.I don't like to touch too much on people or activities where I work. Makes me kind of uncomfortable discussing what is normally private stuff. This is newswo...
EnterpriseDB Gets a New CEO
2008-06-04 15:59:00 LewisC's An Expert's Guide To Oracle TechnologyLooks like I have a new boss. Actually, it looks like my boss's boss has a new boss. ;-)I'd like to personally welcome Ed Boyajian to EnterpriseDB. Looks like he has quite a bit of experience with OSS and monetizing software solutions. He's been an executive at Redhat for a long time. 6 years in his last position but in many other positions before that.We (EnterpriseDB employees) have known this was coming for a while now. I knew Andy and the board were looking when I was hired. I just now learned the name of the chosen, though. It's always interesting in a company when executive leadership changes hands.I like Andy (Astor, the ex-CEO) and I'm glad he's staying as the new executive VP of Business Development. I believe that is where his strength (i.e. past experience) lies.I don't like to touch too much on people or activities where I work. Makes me kind of uncomfortable discussing what is normally private stuff. This is newswo...
Wavemaker Provides EnterpriseDB Support
2008-05-29 15:13:00 EnterpriseDB News at BlogspotChris Keene, the CEO for Wavemaker just blogged that combining Wavemaker and EnterpriseDB just got easier. Wavemaker has a new version that has out of the box support for both Postgres and EnterpriseDB.I wrote a couple of weeks ago about my first day of Wavemaker training. I still haven't found time to start day two but now that Wavemaker supports EnterpriseDB, I'll probably redo day 1 using Advanced Server instead of MySQL. I could have done it before since it already supported Postgres and EnterpriseDB via a manual configuration. But now I'll want to see how easy it is with the automatic support.If you want a little bit more info on Wavemaker, I also posted about my first look with it.Wavemaker is an open source AJAX GUI builder for almost any relational database. You can get it, for free, here.Thanks,LewisC Technorati : database, enterprisedb, gui, open source, postgres, wavemaker More About: Support
Wavemaker Provides EnterpriseDB Support
2008-05-29 15:13:00 EnterpriseDB News at BlogspotChris Keene, the CEO for Wavemaker just blogged that combining Wavemaker and EnterpriseDB just got easier. Wavemaker has a new version that has out of the box support for both Postgres and EnterpriseDB.I wrote a couple of weeks ago about my first day of Wavemaker training. I still haven't found time to start day two but now that Wavemaker supports EnterpriseDB, I'll probably redo day 1 using Advanced Server instead of MySQL. I could have done it before since it already supported Postgres and EnterpriseDB via a manual configuration. But now I'll want to see how easy it is with the automatic support.If you want a little bit more info on Wavemaker, I also posted about my first look with it.Wavemaker is an open source AJAX GUI builder for almost any relational database. You can get it, for free, here.Thanks,LewisC Technorati : database, enterprisedb, gui, open source, postgres, wavemaker More About: Support
Learn EDB: Basic Encryption
2008-05-27 15:33:00 LewisC's An Expert's Guide To Oracle TechnologyAn ITToolbox user recently asked a question on the EnterpriseDB discussion group, Oracle equilant UTL_I18N.STRING_TO_RAW IN ENTERPRISEDB.Basic ally, Sreenivas asked which functions in EnterpriseDB could be used to implement dbms_crypto, hex_to_raw, string_to_raw, etc. I believe he is using EnterpriseDB Postgres Plus Advanced Server which is the product that gives Oracle Compatibility. The short answer to his question is that right now, there are no compatibility functions for those. The long answer is that you can re-implement that functionality using native PG functionality.If you look at Sreenivas's message you can see how his existing code works. I posted a simple example in response which I am reposting below. The PG docs suggest that you use PGP based encryption rather than what they call raw encryption. I think it depends on exactly what you're doing, personally. Anyway, raw encryption was closer to what Sreenivas was doing so ... More About: Encryption , Learn
Learn EDB: Basic Encryption
2008-05-27 15:33:00 LewisC's An Expert's Guide To Oracle TechnologyAn ITToolbox user recently asked a question on the EnterpriseDB discussion group, Oracle equilant UTL_I18N.STRING_TO_RAW IN ENTERPRISEDB.Basic ally, Sreenivas asked which functions in EnterpriseDB could be used to implement dbms_crypto, hex_to_raw, string_to_raw, etc. I believe he is using EnterpriseDB Postgres Plus Advanced Server which is the product that gives Oracle Compatibility. The short answer to his question is that right now, there are no compatibility functions for those. The long answer is that you can re-implement that functionality using native PG functionality.If you look at Sreenivas's message you can see how his existing code works. I posted a simple example in response which I am reposting below. The PG docs suggest that you use PGP based encryption rather than what they call raw encryption. I think it depends on exactly what you're doing, personally. Anyway, raw encryption was closer to what Sreenivas was doing so ... More About: Encryption , Learn
Wavemaker Training Day 1
2008-05-15 15:17:00 LewisC's An Expert's Guide To Oracle TechnologyI mentioned the other day that I was playing with a new GUI builder from an EnterpriseDB partner, Wavemaker. Wavemaker, in addition to providing the software, provides some training that is downloadable from the web site.This training is a two day basics course in powerpoint format. I would guess that this is what they use for instructor led training and they just made this available to the public. Anyway, I decided to see how good the training was which in turn kind of tells me how easy wavemaker is to learn.Day 1 includes 8 powerpoint presentations:IntroductionWavemaker ArchitectureWavemaker InstallationWavemaker Studio OverviewPage Designer BasicsWavemaker Data ModelService ComponentsData WidgetsSeeing as how I was already making some simple pages with the tool, I blew through the intro, the architecture and installation. It's interesting stuff, though.I snagged a screenshot of the wavemaker runtime from the powerpoint presentatio... More About: Training
Wavemaker Training Day 1
2008-05-15 15:17:00 LewisC's An Expert's Guide To Oracle TechnologyI mentioned the other day that I was playing with a new GUI builder from an EnterpriseDB partner, Wavemaker. Wavemaker, in addition to providing the software, provides some training that is downloadable from the web site.This training is a two day basics course in powerpoint format. I would guess that this is what they use for instructor led training and they just made this available to the public. Anyway, I decided to see how good the training was which in turn kind of tells me how easy wavemaker is to learn.Day 1 includes 8 powerpoint presentations:IntroductionWavemaker ArchitectureWavemaker InstallationWavemaker Studio OverviewPage Designer BasicsWavemaker Data ModelService ComponentsData WidgetsSeeing as how I was already making some simple pages with the tool, I blew through the intro, the architecture and installation. It's interesting stuff, though.I snagged a screenshot of the wavemaker runtime from the powerpoint presentatio... More About: Training
Bind Variables in Postgres Plus Advanced Server
2008-05-13 03:56:00 Bind variables are used to ease code maintenance and to save memory and processing on the server. When you save memory and processing power, you improve the overall performance of the server. The inner details of how this saves memory has been enumerated in other places on the web. This article is designed to help developers users bind variables when running queries against Postgres Plus Advanced Server .What are bind variables?The easiest way to think of a bind variable is to consider it just another variable. Instead of it being a variable to be used by your application (and whatever language you happen to be using), think of it as a variable to be used by SQL. Better yet, think of it as a parameter to be used by SQL.Why do you use parameters in your functions and procedures? Take a look at this very simple SPL procedure:PROCEDURE start_program ISBEGIN DBMS_OUTPUT.PUT_LINE('Hello World');END;Now, that procedure works just fine. When the program starts, it calls start_program and... More About: Variables
Bind Variables in Postgres Plus Advanced Server
2008-05-13 03:56:00 Bind variables are used to ease code maintenance and to save memory and processing on the server. When you save memory and processing power, you improve the overall performance of the server. The inner details of how this saves memory has been enumerated in other places on the web. This article is designed to help developers users bind variables when running queries against Postgres Plus Advanced Server .What are bind variables?The easiest way to think of a bind variable is to consider it just another variable. Instead of it being a variable to be used by your application (and whatever language you happen to be using), think of it as a variable to be used by SQL. Better yet, think of it as a parameter to be used by SQL.Why do you use parameters in your functions and procedures? Take a look at this very simple SPL procedure:PROCEDURE start_program ISBEGIN DBMS_OUTPUT.PUT_LINE('Hello World');END;Now, that procedure works just fine. When the program starts, it calls start_program and... More About: Variables
DBMS_PIPE & DBMS_ALERT In EnterpriseDB
2008-05-08 14:59:00 LewisC's An Expert's Guide To Oracle TechnologyThe latest release of the EnterpriseDB database, Postgres Plus Advanced Server (AS) 8.3, includes additional Oracle compatibility features. Two of those new features are DBMS_PIPE and DBMS_ALERT. Old Oracle hands will recognize those two packages that are used for interprocess communication. This post is a quick tutorial on using these two features. If you've used them in Oracle, you would have no problem using them in AS.DBMS_ALERTDBMS_ALERT allows you to send an alert to any processes that are registered to hear (listen) that alert. The listening process can register to hear multiple alerts. When any alert comes that matches the listen list, the receiving process will take action. A process can block, i.e. freeze, while waiting for an alert or it can continue processing and periodically poll for alerts. This is accomplished via a timeout parameter.The first step in alerting is to register to hear an alert. This is done via the regi...
DBMS_PIPE & DBMS_ALERT In EnterpriseDB
2008-05-08 14:59:00 LewisC's An Expert's Guide To Oracle TechnologyThe latest release of the EnterpriseDB database, Postgres Plus Advanced Server (AS) 8.3, includes additional Oracle compatibility features. Two of those new features are DBMS_PIPE and DBMS_ALERT. Old Oracle hands will recognize those two packages that are used for interprocess communication. This post is a quick tutorial on using these two features. If you've used them in Oracle, you would have no problem using them in AS.DBMS_ALERTDBMS_ALERT allows you to send an alert to any processes that are registered to hear (listen) that alert. The listening process can register to hear multiple alerts. When any alert comes that matches the listen list, the receiving process will take action. A process can block, i.e. freeze, while waiting for an alert or it can continue processing and periodically poll for alerts. This is accomplished via a timeout parameter.The first step in alerting is to register to hear an alert. This is done via the regi...
Calling a Packaged Procedure via .Net
2008-04-24 14:23:00 Someone recently posted a question in the Postgres Forums about how to call a package in Advanced Server. He also had a question about how to call a packaged procedure in a specific schema.Here is my reply to the question:You can't actually execute packages. You execute the procedures or functions in them. Here is some code to execute a procedure in a package. I am using public as the schema name. If you want to execute a procedure in a user's schema, just replace public with the user's name. using System;using System.Data;using EnterpriseDB.EDBClient;namespace ConsoleApplication2{ class Program { static void Main(string[] args) { EDBConnection conn = new EDBConnection( "Server=localhost;" + "Port=5444;" + "User Id=enterprisedb;" + "Password=enterprisedb;" + "Database=edb"); conn.Open(); EDBCommand cmd = new EDBCom... More About: Calling
Calling a Packaged Procedure via .Net
2008-04-24 14:23:00 Someone recently posted a question in the Postgres Forums about how to call a package in Advanced Server. He also had a question about how to call a packaged procedure in a specific schema.Here is my reply to the question:You can't actually execute packages. You execute the procedures or functions in them. Here is some code to execute a procedure in a package. I am using public as the schema name. If you want to execute a procedure in a user's schema, just replace public with the user's name. using System;using System.Data;using EnterpriseDB.EDBClient;namespace ConsoleApplication2{ class Program { static void Main(string[] args) { EDBConnection conn = new EDBConnection( "Server=localhost;" + "Port=5444;" + "User Id=enterprisedb;" + "Password=enterprisedb;" + "Database=edb"); conn.Open(); EDBCommand cmd = new EDBCom... More About: Calling
EDB Tip #4: Database Links in EDB
2008-04-23 15:47:00 LewisC's An Expert's Guide To Oracle TechnologyThis tip relates to the latest version of EnterpriseDB's Advanced Server (AS) product. This is the commercially licensed database that provides Oracle compatibility. I have spoken quite a bit about what that compatibility entails but the gist of it is that the compatibility is code compatibility. The latest version of AS offers quite a few new features that I will be writing about over time. Today I am writing about the Oracle compatible db links.To understand database links in Oracle, read my entry here on ittoolbox, Database Links : A Definition in Plain English. That entry will give you a good overview of what a link is and what Oracle does with links. This is a hugely useful feature. Pulling data from remote databases can be incredibly important to many applications.AS provides DDL syntax that is very close to Oracle syntax and DML syntax exactly like Oracle syntax. In addition, you can choose to create links from AS to Oracle or ...
EDB Tip #4: Database Links in EDB
2008-04-23 15:47:00 LewisC's An Expert's Guide To Oracle TechnologyThis tip relates to the latest version of EnterpriseDB's Advanced Server (AS) product. This is the commercially licensed database that provides Oracle compatibility. I have spoken quite a bit about what that compatibility entails but the gist of it is that the compatibility is code compatibility. The latest version of AS offers quite a few new features that I will be writing about over time. Today I am writing about the Oracle compatible db links.To understand database links in Oracle, read my entry here on ittoolbox, Database Links : A Definition in Plain English. That entry will give you a good overview of what a link is and what Oracle does with links. This is a hugely useful feature. Pulling data from remote databases can be incredibly important to many applications.AS provides DDL syntax that is very close to Oracle syntax and DML syntax exactly like Oracle syntax. In addition, you can choose to create links from AS to Oracle or ...
Combined Forums for Postgres and EnterpriseDB Issues
2008-04-23 15:28:00 In the past, your basic support for postgres has been mail groups. I've never been a big fan of mail groups. You have to subscribe to the group and usually you get tons of stuff you don't really want. Worst of all, you either have to sort through it or filter it to a folder. I never seem to be able to keep up with the stuff I am interested in due to the clutter.EnterpriseDB has had forums for a while but recently combined the postgres and advanced server forums into a single location. GridSQL also has it's own forum. You can ask pretty much any question you might have. The forums are monitored by EnterpriseDB employees and there are also some very knowledgeable users out there.LewisCforums enterprisedb More About: Issues , Forums
Combined Forums for Postgres and EnterpriseDB Issues
2008-04-23 15:28:00 In the past, your basic support for postgres has been mail groups. I've never been a big fan of mail groups. You have to subscribe to the group and usually you get tons of stuff you don't really want. Worst of all, you either have to sort through it or filter it to a folder. I never seem to be able to keep up with the stuff I am interested in due to the clutter.EnterpriseDB has had forums for a while but recently combined the postgres and advanced server forums into a single location. GridSQL also has it's own forum. You can ask pretty much any question you might have. The forums are monitored by EnterpriseDB employees and there are also some very knowledgeable users out there.LewisCforums enterprisedb More About: Issues , Forums
EnterpriseDB Open Sources GridSQL
2008-03-26 15:30:00 I wrote about GridSQL and EnterpriseDB a while back. EnterpriseDB bought GridSQL (from Mason who now works at EnterpriseDB) and has been working to improve it. Yesterday, they announced that they are open sourcing it.GridSQL is really for data warehousing but can be applied to some OLTP/reporting combination databases. What it does is take a query and spread it out to run in parallel against a set of cheap PCs. There is a controller machine, called a coordinator, that keeps track of what is running and where.Because there is a central point of failure (the coordinator), it is not a high availability solution. But, also because of the coordinator, you can hot swap, add or remove nodes while users are accessing the data. Very cool technology.LewisCgridsql enterprisedb More About: Open
EnterpriseDB Open Sources GridSQL
2008-03-26 15:30:00 I wrote about GridSQL and EnterpriseDB a while back. EnterpriseDB bought GridSQL (from Mason who now works at EnterpriseDB) and has been working to improve it. Yesterday, they announced that they are open sourcing it.GridSQL is really for data warehousing but can be applied to some OLTP/reporting combination databases. What it does is take a query and spread it out to run in parallel against a set of cheap PCs. There is a controller machine, called a coordinator, that keeps track of what is running and where.Because there is a central point of failure (the coordinator), it is not a high availability solution. But, also because of the coordinator, you can hot swap, add or remove nodes while users are accessing the data. Very cool technology.LewisCgridsql enterprisedb More About: Open , Sources
Free Electronic Copy of My Book
2008-03-13 19:19:00 Someone pointed out to me that the publisher has made an electronic copy of my EnterpriseDB: The Definitive Reference book available as a PDF on their web site.I don't know how long they plan to leave this out there. EnterpriseDB: The Definitive Referencebook enterprisedb More About: Electronic , Free , Book , Copy
A New EnterpriseDB Webinar
2008-03-07 15:26:00 I'm doing a "Best Practices on Database Migration" webinar at ITToolbox.com March 12. I'll talk about ways to make your life easier when doing database migrations.LewisCoracle enterprisedb More About: Oracle , Webinar
A New EnterpriseDB Webinar
2008-03-07 15:26:00 I'm doing a "Best Practices on Database Migration" webinar at ITToolbox.com March 12. I'll talk about ways to make your life easier when doing database migrations.LewisCoracle enterprisedb More About: Oracle , Webinar
Open Source Data Integrator Apatar Announces Partnership with EnterpriseDB
2008-02-11 19:23:00 Apatar is a provider of open source software tools for the data integration market. Apatar provides data integration to the companies by offering provides support, training, and consulting services for its integration software solutions.Apatar provides connectivity to EnterpriseDB, Oracle , MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJData Store, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine, any JDBC data sources and more.The free Community Edition is available for download and provides plenty of functionality out of the box. There is a also an Enterprise Edition that provides some additional features. You can compare features in the feature matrix."We are pleased to support EnterpriseDB's world-class database solutions as part of our integration practice," said Renat Khasanshyn, founder and CEO of Apatar, Inc. "In today's enterprises, most data integration projects never get built. The ROI (Return on Investment)... More About: Open Source , Open , Source
Open Source Data Integrator Apatar Announces Partnership with EnterpriseDB
2008-02-11 19:23:00 Apatar is a provider of open source software tools for the data integration market. Apatar provides data integration to the companies by offering provides support, training, and consulting services for its integration software solutions.Apatar provides connectivity to EnterpriseDB, Oracle , MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJData Store, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine, any JDBC data sources and more.The free Community Edition is available for download and provides plenty of functionality out of the box. There is a also an Enterprise Edition that provides some additional features. You can compare features in the feature matrix."We are pleased to support EnterpriseDB's world-class database solutions as part of our integration practice," said Renat Khasanshyn, founder and CEO of Apatar, Inc. "In today's enterprises, most data integration projects never get built. The ROI (Return on Investment)... More About: Open Source , Open , Source
EnterpriseDB CEO Named One of the ?Top Leaders in Open Source Business?
2008-02-05 21:22:00 EnterpriseDB's CEO, Andy Astor, was named one of 13 ?Top Leaders in Open Source Business ? by LinuxWorld Magazine. EnterpriseDB was also recently named one of the ?Top 20 Companies to Watch in 2008" by Linux Magazine.This is good news for open source and for people looking to save money on database license fees.EnterpriseDB sells the open source based Oracle compatible EnterpriseDB Advanced Server as well as a packaged Postgres implementation. EnterpriseDB also offers consulting and training.oracle enterprisedb
EnterpriseDB CEO Named One of the ?Top Leaders in Open Source Business?
2008-02-05 21:22:00 EnterpriseDB's CEO, Andy Astor, was named one of 13 ?Top Leaders in Open Source Business ? by LinuxWorld Magazine. EnterpriseDB was also recently named one of the ?Top 20 Companies to Watch in 2008" by Linux Magazine.This is good news for open source and for people looking to save money on database license fees.EnterpriseDB sells the open source based Oracle compatible EnterpriseDB Advanced Server as well as a packaged Postgres implementation. EnterpriseDB also offers consulting and training.oracle enterprisedb
EnterpriseDB: The Definitive Reference for less than $25 USD
2008-01-23 01:41:00 If you've thought about buying the book, EnterpriseDB: The Definitive Reference , you should check out A1Books.com. As of right now, 1/22/08, it's going for $24.80 USD (Brand New).Shipping would depend on your location.LewisCoracle enterprisedb More About: Oracle
EnterpriseDB: The Definitive Reference for less than $25 USD
More articles from this author:2008-01-23 01:41:00 If you've thought about buying the book, EnterpriseDB: The Definitive Reference , you should check out A1Books.com. As of right now, 1/22/08, it's going for $24.80 USD (Brand New).Shipping would depend on your location.LewisCoracle enterprisedb More About: Oracle 1, 2, 3 |
 |
|
 |
