Monday, July 16. 2012Building PLV8JS and PLCoffee for Windows using MingW64 w64-w32Printer FriendlyRecommended Books: PostgreSQL: Up and Running
Comments
Display comments as
(Linear | Threaded)
This is awesome! Thanks guys!
#1
on
2012-07-17 13:34
That's very interesting (even if I don't run Windows).
Any idea about performance against PL/PgSQL? TIA.
#2
on
2012-07-19 02:59
Haven't bench-marked it yet, but I expect it to be worse. For one like other PL/languages it has an spi to execute updates etc where as PL/PgSQL can do it directly. It is also still very new so doesn't have all the optimization enhancements etc. you get from people punching it and reporting bugs. That said one should not think of it as a replacement for PL/PgSQL (just as PL/Perl and PL/Python are not replacements). Rather as a tool to leverage functionality lacking in PL/PGSQL and much more portable than PL/Python, PL/Perl since it doesn't need an additional environment (beyond what you package with the lighter weight V8 engine)
One big one is being able to understand JSON natively. To us this is big as it allows you to build indexes on JSON objects and consume AJAX JSON requests/updates directly. We'll try to provide an example use case in another article.
#2.1
on
2012-07-19 08:28
I am not thinking about replacing PL/PgSQL with PLV8.
I am thinking about having the two PLs working side-by-side and exploiting the one that best fits every single needs. Nonetheless I think that knowing the relative performance will help in getting the best of the two worlds.
#3
on
2012-07-19 10:51
I have downloaded pg92plv8jsbin_w32.zip
to use with PG 9.2.2.1 w32, the installer was postgresql-9.2.2-1-windows.exe running on Windows2003 SP2. Here is the message I am getting: postgres=# create extension plv8js; ERROR: could not open extension control file "F:/Program Files/PostgreSQL/9.2/s hare/extension/plv8js.control": No such file or directory postgres=# create extension plv8; ERROR: could not load library "F:/Program Files/PostgreSQL/9.2/lib/plv8.dll": A ccess is denied. Could you please advise ?
#4
on
2013-01-10 12:51
Did you copy all the files that were in the bin folder of the zip into the bin folder of your PostgreSQL 9.2.
The all the dlls packaged in the bin folder should be copied into the bin of your PosgreSQL 9.2 e.g. libgcc*, libstd*, v8.dll and v8preparser.dll Without those the plv8.dll can't be installed. If it still doesn't work after that try dependency walker depends.exe to see what you might be missing. You of course also what to make sure the share/extension folder files are copied to your PostgreSQL share/extension folder.
#4.1
on
2013-01-11 05:06
My mistake was that I did not restart
postgresql service after copying the files to respective folders.I guess that was it. After reading your response all I did was to restart the service and create the extension. Sorry about that.
#4.1.1
on
2013-01-11 14:30
No problem. Glad it works for you since we feared it was something wrong with our binaries.
#4.1.1.1
on
2013-01-12 20:42
|
Entry's LinksQuicksearchCalendar
Categories
Blog Administration |
Tracked: Aug 09, 01:18
Tracked: Aug 09, 01:53
Tracked: Sep 22, 16:27