Re: [GENERAL] Large data and slow queries
Hello Vinny, Samuel, Perhaps I'm missing something, but I'd be interested in the reasoning behind this. For column 'what', it seems you have no index on all values, only indices with specific values for 'what'. How does this speed up the search? Will PostgreSQL use those indices, instead of using a generic index on 'what' and optionally other columns? That's a "partial index", it only contains records that meet the requirements of the index definition. https://www.postgresql.org/docs/9.5/static/indexes-partial.html Basically; if you create an index on records where 'name = kees' then if your query contains "where name=kees" the planner can just load that index and know that the records in that index will not contain any other names, saving the need to filter for 'name=kees' Martijn that is a good question. It's because we are only concerned with a subset of events for this index and this particular query. The query planner can recognise this and use the index correctly. By doing this, we reduce the size of the index significantly. In the best case, where we only wanted a few things, the index was reduced from 21GB to 8MB. Thank for the answers, I've seen such indices before, but used, for example, on an UPPER(...) of all values, never thought of using them to filter out specific values in order to make the index smaller. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Large data and slow queries
Samuel, others,
Perhaps I'm missing something, but I'd be interested in the reasoning behind
this.
For column 'what', it seems you have no index on all values, only indices
with specific values for 'what'.
How does this speed up the search? Will PostgreSQL use those indices,
instead of using a generic index on 'what' and optionally other columns?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
-Original Message-
From: Samuel Williams
Sent: Wednesday, April 19, 2017 6:01 AM
To: pgsql-general
Subject: [GENERAL] Large data and slow queries
Hi.
We have 400,000,000 records in a table (soon to be 800,000,000), here
is the schema (\d+)
https://gist.github.com/ioquatix/bddda36d9e4ffaceb7a62d7b62259121
We want the following kinds of query to be fast:
SELECT DISTINCT "user_event"."user_id" FROM "user_event" WHERE
"user_event"."what" IN ('poll', 'location_change',
'midnight_location') AND ("user_event"."created_at" >= '2016-04-19
01:23:55') AND (latitude > -37.03079375089291 AND latitude <
-36.67086424910709 AND longitude > 174.6307139779924 AND longitude <
175.0805140220076);
We have a btree index and it appears to be working. However, it's
still pretty slow.
EXPLAIN ANALYZE gives the following:
https://gist.github.com/ioquatix/bddda36d9e4ffaceb7a62d7b62259121#gistcomment-2065314
I'm thinking that I need to do the following to help:
CLUSTER user_event ON index_user_event_for_visits_3 followed by
analyze... Our data is mostly time series but sometimes we get some
dumps with historical records.
Perhaps add a BRIN index on created_at
I'm wondering if... we can use an index to cache, all user_ids seen on
a given day. If we change our index to be more discrete, e.g.
created_at::date, would this help? The set union of user_ids for 365
days should be pretty fast?
I'm open to any ideas or suggestions, ideally we can keep
optimisations within the database, rather than adding a layer of
caching on top.
Kind regards,
Samuel
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] import CSV file to a table
Hi, If this is a one-time thing, you can use the Import Data tool in Database Workbench, see http://www.upscene.com/documentation/dbw5/tools_dataimport.htm Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. From: Günce Kaya Sent: Wednesday, March 08, 2017 10:13 AM To: pgsql-general@postgresql.org Subject: [GENERAL] import CSV file to a table Hi all, I want to import content of CSV file to a table via bash script without creating temporary table and I also want to skip some columns in CSV file (for instance, CSV file has 12 column and main table has only 2 column, If possible I would use only 2 column in CSV file) Is there any way to do it? Regards, -- Gunce Kaya
Re: [GENERAL] Why is table not found?
Hello Egon,
You created the table using delimited identifiers:
"Raum"
which is not the same as
Raum of raum or RAUM
When you use delimited identifiers (eg: "MyTable" instead of MyTable), the
name becomes case sensitive.
When you use SQL, you need to use delimited identifiers:
select * from "Raum"
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL,
SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I
find the the table. In sql field is shown:
-- Table: "Raum"
-- DROP TABLE "Raum";
CREATE TABLE "Raum"
(
"RaumID" serial NOT NULL, -- Automatisch vergebenes
Identifizierungsmerkmal für den Raum
"Raum" character varying(15), -- Bezeichnung des Raums
CONSTRAINT "Raum_pkey" PRIMARY KEY ("RaumID")
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Raum"
OWNER TO egon;
COMMENT ON COLUMN "Raum"."RaumID" IS 'Automatisch vergebenes
Identifizierungsmerkmal für den Raum';
COMMENT ON COLUMN "Raum"."Raum" IS 'Bezeichnung des Raums';
-- Index: "Raum_RaumID_idx"
-- DROP INDEX "Raum_RaumID_idx";
CREATE INDEX "Raum_RaumID_idx"
ON "Raum"
USING btree
("RaumID");
But psql tells me "Raum" is not existent:
egon@xfEinzel ~ $ psql Hausrat
psql (9.3.15)
Type "help" for help.
Hausrat=# SELECT * FROM Raum;
ERROR: relation "raum" does not exist
LINE 1: SELECT * FROM Raum;
^
Hausrat=#
Why?
Egon
-BEGIN PGP SIGNATURE-
Version: GnuPG v2.0.22 (GNU/Linux)
iQIbBAEBAgAGBQJYkJTwAAoJECc7nbY+bg5uiRQP9iC4UtbHpPvdvV796fxcMSFp
dncPHzkTKHvcEh3V9t/Xn/BzEHBDAO6RO8jmU18Ja9f/0nOyNXrWxal0OJZXint5
l3/qRKbekkl7zfogysh4XgZQkpWwsJcYDGoG5tCUQm8TJ3sCk9a9+mbkDhy0Vsev
MPeyYl/fYvlTBkiRmlPZTOX7YjRzeryKXguB3PBke3Vo6SZ1sFWnMjJ7bc2b
4cW9hmInmwXZ4EBOfcUW4QnfM0mgHBMGxJwYVQfeC6fQeqT8emh0KQLqozjFe/tk
KNKDU0RebcrBgXP/lIGI34XahZW+WOdLli/t8wBUNiINruY2FlizuH6Uuak3tLjC
cD7vi0SzNK2YFr9Rozw8ow9WVxSfjWBLiOA1GkFdhxKb80NLHthzo8oIVaCqz0bj
71kA0ewgZ9NMay6ch1VjqSPPFhAZHc1Ho3xIAa0BsZpvEdccDBsL+yk/6DGDYua9
5oT1p6CZqfDJqxEIoUiNaJEKm3An5ySN8hHn527/apG9yA9QMh5qJPHA0wRqtLxN
hNSxugKhS6UOw/Wivbx0OIhN8jqBv4m22UgO9pFGgxHLs1hheSTMUSbExFCLuK+z
sS1Kw9syplk+lFTzK6mqNpr3BQ6v2fmkPmRTZoID4e9T3DY8Bna2JXG2U1QGEzwa
kwpJOMAvY3DDPv3pIK8=
=i8FY
-END PGP SIGNATURE-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Generating sample data
Hi, Not open source, but also not pricey (IMO): Advanced Data Generator. http://www.upscene.com/advanced_data_generator/ Generates e-mail addresses, street names, first & last names, company names, complex relationships etc. And yes, this is our product. ;) With regards, Martijn Tonies Upscene Productions http://www.upscene.com My previous databases used real client (or my own) data; now I want to generate sample data for the tables in the two applications I'm developing. My web search finds a bunch of pricey (IMO) commercial products. Are there any open source data generators that can provide sample data based on each table's schema? TIA, Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Er Data Modeller for PostgreSQL
Hello Gunce, Do you mean some sort of reverse engineering? Database Workbench supports that. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. From: Andreas Joseph Krogh Sent: Friday, December 23, 2016 11:57 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Er Data Modeller for PostgreSQL På fredag 23. desember 2016 kl. 06:50:54, skrev Günce Kaya <guncekay...@gmail.com>: Hi All, I'm looking for an ER Data Modeller tool for postgresql. I use Navicat Premium for postgresql and the tool has a modeller but I would like to display a database modeller that belonging to a tables of an schema under a database. If I use Navicat for modeller, I have to drag and drop whole tables which I want to add to data modeller. So It's pretty manual process. Is there any way to display an er modeller that show only chosen schema under the database? Any advice would be appreciated. Regards, -- Gunce Kaya
Re: [GENERAL] ANN: Upscene releases Database Workbench 5.2.4
On Wed, Oct 12, 2016 at 2:51 AM, Martijn Tonies (Upscene Productions) <m.ton...@upscene.com> wrote: Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2.4 " The 5.2 release includes support for PostgreSQL and adds several other features and bugfixes. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! I'm not sure announcements of commercial software updates belong on the pgsql-general email list. if every vendor of apackage with postgres support posted announcements of each incremental update, we'd be buried in spam. Yeah.. If it applies somewhere that would be pgsql-announce. For the record, it was my understanding pgsql-announce was by PostgreSQL only. Nope, pgsql-announce is for exactly these types of things. It is a moderated list, but that's the appropriate venue. --Scott Thanks, I’ll revisit. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird.
Re: [GENERAL] ANN: Upscene releases Database Workbench 5.2.4
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2.4 " The 5.2 release includes support for PostgreSQL and adds several other features and bugfixes. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! I'm not sure announcements of commercial software updates belong on the pgsql-general email list. if every vendor of apackage with postgres support posted announcements of each incremental update, we'd be buried in spam. Yeah.. If it applies somewhere that would be pgsql-announce. For the record, it was my understanding pgsql-announce was by PostgreSQL only. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] ANN: Upscene releases Database Workbench 5.2.4
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2.4 " The 5.2 release includes support for PostgreSQL and adds several other features and bugfixes. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. The most recent version adds support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: [GENERAL] Graphical entity relation model
Hello Johannes, A new kid on the block – Database Workbench, a Windows application that works fine on Linux and Mac via Wine. http://www.upscene.com/database_workbench/ With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. On 1 October 2016 at 04:45, <kbran...@pwhome.com> wrote: > Does anybody know a Software for generating graphical entity relation models from existing postgresql databases? > > Best regards Johannes I use dbWrench (dbwrench.com). It's not free, but they do have a free trial version so you can see if you like it before you buy it. It's also not expensive compared to many of these sorts of tools. It also runs on all 3 major platforms (it's written in Java) and the developer is responsive if you find a problem. If money is no object, you can look at Power Designer (by Sybase). I used to use it years ago and liked it even if it was MS-Windows only, but the price has gone up so much only companies can really afford it now, IMO. HTH, Kevin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Test letter
It did. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and Firebird. From: Alex Sviridov Sent: Thursday, September 15, 2016 4:57 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Test letter Hi all, I have suspicions that my message don't get to pgsql-general mailing list. Please, someone, answer this message if this get the mailing list. Best regards, Alex
[GENERAL] ANN: Upscene releases Database Workbench 5.2.2
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: Database Workbench 5.2.2 " This release includes support for PostgreSQL and adds several other features and bugfixes. http://www.upscene.com/news/item/20160914 Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. The most recent version adds support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: [GENERAL] IDE for function/stored proc development.
Hi, For what it's worth, Database Workbench with PostgreSQL support was released Yesterday. http://www.upscene.com/database_workbench/whatsnew With regards, Martijn Tonies Upscene Productions [...] Hmm... exe's don't work natively on Linux... Of course they don't. Here's some guides for Wine - we have several customers using the product on Linux all the time. http://www.upscene.com/company/support Hope this helps. With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] ANN: Database Workbench 5.2 now includes PostgreSQL support
Upscene Productions is proud to announce the availability of the next version of the popular multi-DBMS development tool: " Database Workbench 5.2 " This release includes support for PostgreSQL and adds several other features. Database Workbench 5 comes in multiple editions with different pricing models, there's always a version that suits you! "Version 5 included many new features", says Martijn Tonies, founder of Upscene Productions. "It added code editor features, has diagramming improvements, multiple editions, is fully HiDPI aware and offers tunnelling for MySQL and MariaDB connections. The most recent version adds support for PostgreSQL, as requested by many of our customers." For more information, see What's new in Database Workbench 5? ( http://www.upscene.com/database_workbench/whatsnew ) Database Workbench supports MySQL, MariaDB, Firebird, Oracle, MS SQL Server, SQL Anywhere, NexusDB, PostgreSQL and InterBase, comes in multiple editions and is licensed based on selectable modules. It includes tools for database design, database maintenance, testing, data transfer, data import & export, database migration, database compare and numerous other tools. About Database Workbench Database Workbench is a database developer tool, over 12 years in the making and is being used by thousands of developers across the globe who have come to rely on it every day. From database design, implementation, to testing and debugging, it will aid you in your daily database work. About Upscene Productions Based in The Netherlands, Europe, this small but dedicated company has been providing database developers with useful tools for over 14 years. Slowly expanding the product portfolio and gaining recognition amongst InterBase and Firebird database developers, they now offer tools for a whole range of database systems, including Oracle and Microsoft SQL Server.
Re: [GENERAL] IDE for function/stored proc development.
Hi, For what it's worth, Database Workbench with PostgreSQL support was released Yesterday. http://www.upscene.com/database_workbench/whatsnew With regards, Martijn Tonies Upscene Productions -Original Message- From: Jim Nasby Sent: Thursday, September 08, 2016 1:33 AM To: Tim Uckun ; Pavel Stehule Cc: pgsql-general Subject: Re: [GENERAL] IDE for function/stored proc development. On 9/3/16 7:49 AM, Tim Uckun wrote: I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres. Keep in mind that workflow doesn't work well if you need to deploy to production on a regular basis. The workflow I generally use is sqitch[1] and a thin wrapper that runs my unit tests (you do write unit tests for your functions, right? :)). Something like: revert_to=`sqitch tag|tail -n2|head -n1` # Get second to last deployed tag sqitch rebase -y --onto $revert_to $DB && sqitch rebase -y --onto $revert_to $DB && db/run_test $DB Normally you won't be re-deploying that much, so that would be pretty fast. Note that you'll want to create a separate sqitch migration for each object. [1] http://sqitch.org/ -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) mobile: 512-569-9461 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pgadmin4 rc1 query tool performance
i testing the latest release of pgadmin4 (rc1) and noticed that the query tool is significantly slower than the query tool in pgadmin3. i am not sure if this occurs only on my computer or only under os x (10.10.5) or is this a known behavior. I don't know. You might get an answer quicker at the link below though: https://www.postgresql.org/list/pgadmin-hackers/ sorry for the noise, i posted this accidentally here instead of pgadmin-support. i got already an answer there. What was the answer? With regards, Martijn Tonies Upscene Productions -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] IDE for function/stored proc development.
Good morning, >I looked at your purchase, and did not see any Postgres version. Am I missing >(/misunderstanding) something here? It’s not yet available, please wait until the end of the week That being said, the pricing will be the same as for MySQL. With regards, Martijn Tonies Upscene Productions http://www.upscene.com
Re: [GENERAL] IDE for function/stored proc development.
Hello Tim, We will be releasing Database Workbench with PostgreSQL support later this week, it’s a Windows application but works fine on Linux/MacOS via Wine. Here’s the link to our website, feel free to check some screenshots http://www.upscene.com/database_workbench/ With regards, Martijn Tonies Upscene Productions From: Tim Uckun Sent: Saturday, September 03, 2016 2:49 PM To: Pavel Stehule Cc: pgsql-general Subject: Re: [GENERAL] IDE for function/stored proc development. I was hoping there was some IDE which made that process seamless. Something like PgAdmin but better editing features and features like "find definition" or "find usages" and such. The jetbrains products come close but as I said they are buggy and don't work very well with postgres. On Sat, Sep 3, 2016 at 11:03 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: Hi 2016-09-03 11:36 GMT+02:00 Tim Uckun <timuc...@gmail.com>: Does anybody use an IDE for doing heavy duty stored proc development? PGadmin is decent but I am looking for something better. I have tried jetbrains with the db browser plugin and on the surface it seems like a good choice but it's really buggy when working with procs. I also tried datagrip by jetbrains and that too seems to be all over the place. It has some amazing features for working with the database but some of the simplest stuff is lacking or half baked. I looked at atom and could not find any useful plugins for PG. Anybody have experience with something awesome? I am using the Emacs - but any editor should be ok. There is one rule - edit file first, and import to database as next step. PGadmin is pretty bad tool for maintaing stored procedures. Regards Pavel
[GENERAL] PgAdmin: debugging stored function in v9.4 instable?
Hi all, I’m testing the stored function debugger on PostgreSQL 9.4.5 on Windows. Quite often, the debugger just hangs, waiting for the target process. Is this a known issue? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!
Re: [GENERAL] How to convert firebird stored procedures into postgresql functions
Hello Elusai, I very much doubt there’s a tool for this, given that the procedural language isn’t the same, so you’re looking at converting syntax. As far as I’ve seen PLPgSQL, it’s similar and it should be quite easy to convert Firebird PSQL to this language. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird! From: Elusai Soares Sent: Tuesday, May 17, 2016 2:56 AM To: pgsql-general@postgresql.org Subject: [GENERAL] How to convert firebird stored procedures into postgresql functions Hi there :) I have an internship project that consists in migrate a Firebird structure and data to a PostgreSQL one. I have already gotten the migration of tables, primary and foreign keys (and other constraints), indexes and views to a PostgreSQL database. But now I have 140 Firebird stored procedures. I need to convert them into PostgreSQL functions. My question is: is there any tool that could do this conversion? I have tried some tools such as DBTools Manager Professional, Full Convert and PostgreSQL Database Converter, but none of them is able to convert stored procedures. I would like to find a tool because I have a little time to finish this activity manually, and I not even reached triggers... Thank you all and best regards from Brazil :)
Re: [GENERAL] Beta testers for database development tool wanted
Hello Steve, I’ll just get at it right away -- We’re developing a database development tool called Database Workbench, it currently supports MySQL, InterBase, Firebird, Oracle, SQL Server, >NexusDB and SQL Anywhere (see http://www.upscene.com/database_workbench/ ) Windows only, judging from the screenshots? Native Windows, but runs fine in Wine (Platinum status, says the AppDB of WhineHQ) https://appdb.winehq.org/objectManager.php?sClass=version=31080 With regards, Martijn Tonies Upscene Productions http://www.upscene.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] Beta testers for database development tool wanted
Hello everyone, I’ll just get at it right away -- We’re developing a database development tool called Database Workbench, it currently supports MySQL, InterBase, Firebird, Oracle, SQL Server, NexusDB and SQL Anywhere (see http://www.upscene.com/database_workbench/ ) We’re adding PostgreSQL support and the first beta is ready for testing. We would like to have people who: - would use this product on a daily basis, like they're using any other PostgreSQL tool (eg PgAdmin) now - work with larger databases, both data volume and meta data object count - are able to report bugs in a (reasonable) detailed manner - are able to discuss new features or enhancements - are able to regularly download updates and use them - don’t mind being put on a private e-mail list to report issues Limitations: - stored function overloading currently not supported - version 9.1 and up supported If anyone of you is interested is testing this tool, with a free license for the PostgreSQL module and a second module of your choice, drop me an e-mail at m.tonies @ upscene.com With regards, Martijn Tonies Upscene Productions http://www.upscene.com
