API on top of postgresqlOptimizing PostgreSQL for transient dataTool to synchronize PostgreSQL DDL and data...
What am I? I am in theaters and computer programs
How can atoms be electrically neutral when there is a difference in the positions of the charges?
Why proton concentration is divided by 10⁻⁷?
How to mitigate "bandwagon attacking" from players?
Whom do I have to contact for a ticket refund in case of denied boarding (in the EU)?
Exponential growth/decay formula: what happened to the other constant of integration?
How to avoid being sexist when trying to employ someone to function in a very sexist environment?
Find the next monthly expiration date
Casually inserting sexuality
What is this waxed root vegetable?
How would we write a misogynistic character without offending people?
What to do when being responsible for data protection in your lab, yet advice is ignored?
Equivalent to "source" in OpenBSD?
Contradiction with Banach Fixed Point Theorem
Understanding Kramnik's play in game 1 of Candidates 2018
Auto Insert date into Notepad
I am on the US no-fly list. What can I do in order to be allowed on flights which go through US airspace?
Use comma instead of & in table
Does music exist in Panem? And if so, what kinds of music?
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Compare four integers, return word based on maximum
What's the difference between a cart and a wagon?
How to tighten battery clamp?
Can you 'upgrade' leather armor to studded leather armor without purchasing the new armor directly?
API on top of postgresql
Optimizing PostgreSQL for transient dataTool to synchronize PostgreSQL DDL and data databasesJSONB with indexing vs. hstoreCan I find all JSON scalars in PostgreSQL 9.3?Create multi-key JSON object with integers or floats as valuesWhich is more efficient for searches on JSON data in Postgres: GIN or multiple indexed columns?search subkey inside array inside keyStoring a symmetric matrix in postgresqlMake custom aggregate function easier to use (accept more input types without creating variants)PostgreSQL- user-defined types: note sure what internallength/alignment is for linked list type
I'm looking for one or several API's that can be put on top of postgres to make data input more dynamic.
What I'm looking for is something that can handle a wider range of protocols and differently structured data, for example cURL, HTTP, protobuf and JSON (I know they are not of equivalent type). Are there any solutions built for this?
postgresql
asked Aug 28 '14 at 11:16
spydonspydon
1012
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
|
show 1 more comment
I'm looking for one or several API's that can be put on top of postgres to make data input more dynamic.
What I'm looking for is something that can handle a wider range of protocols and differently structured data, for example cURL, HTTP, protobuf and JSON (I know they are not of equivalent type). Are there any solutions built for this?
postgresql
asked Aug 28 '14 at 11:16
spydonspydon
1012
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - thelibpqAPI for C,JDBCviaPgJDBC;ODBCviapsqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.
– Craig Ringer
Aug 28 '14 at 13:32
1
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
1
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56
|
show 1 more comment
I'm looking for one or several API's that can be put on top of postgres to make data input more dynamic.
What I'm looking for is something that can handle a wider range of protocols and differently structured data, for example cURL, HTTP, protobuf and JSON (I know they are not of equivalent type). Are there any solutions built for this?
postgresql
asked Aug 28 '14 at 11:16
spydonspydon
1012
I'm looking for one or several API's that can be put on top of postgres to make data input more dynamic.
What I'm looking for is something that can handle a wider range of protocols and differently structured data, for example cURL, HTTP, protobuf and JSON (I know they are not of equivalent type). Are there any solutions built for this?
postgresql
postgresql
asked Aug 28 '14 at 11:16
spydonspydon
1012
asked Aug 28 '14 at 11:16
spydonspydon
1012
asked Aug 28 '14 at 11:16
spydonspydon
1012
asked Aug 28 '14 at 11:16
spydonspydon
1012
asked Aug 28 '14 at 11:16
spydonspydon
1012
1012
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 18 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - thelibpqAPI for C,JDBCviaPgJDBC;ODBCviapsqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.
– Craig Ringer
Aug 28 '14 at 13:32
1
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
1
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56
|
show 1 more comment
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - thelibpqAPI for C,JDBCviaPgJDBC;ODBCviapsqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.
– Craig Ringer
Aug 28 '14 at 13:32
1
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
1
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - the
libpq API for C, JDBC via PgJDBC; ODBC via psqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.– Craig Ringer
Aug 28 '14 at 13:32
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - the
libpq API for C, JDBC via PgJDBC; ODBC via psqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.– Craig Ringer
Aug 28 '14 at 13:32
1
1
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
1
1
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56
|
show 1 more comment
1 Answer
1
active
oldest
votes
If you are looking for a REST API, there is pg-manati a Nodejs package to automatically manipulate your data in PostgreSQL via the API.
Disclaimer: I am the author of the project.
answered May 18 '16 at 6:40
SylvainSylvain
1276
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f75193%2fapi-on-top-of-postgresql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
If you are looking for a REST API, there is pg-manati a Nodejs package to automatically manipulate your data in PostgreSQL via the API.
Disclaimer: I am the author of the project.
answered May 18 '16 at 6:40
SylvainSylvain
1276
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
add a comment |
If you are looking for a REST API, there is pg-manati a Nodejs package to automatically manipulate your data in PostgreSQL via the API.
Disclaimer: I am the author of the project.
answered May 18 '16 at 6:40
SylvainSylvain
1276
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
add a comment |
If you are looking for a REST API, there is pg-manati a Nodejs package to automatically manipulate your data in PostgreSQL via the API.
Disclaimer: I am the author of the project.
answered May 18 '16 at 6:40
SylvainSylvain
1276
If you are looking for a REST API, there is pg-manati a Nodejs package to automatically manipulate your data in PostgreSQL via the API.
Disclaimer: I am the author of the project.
answered May 18 '16 at 6:40
SylvainSylvain
1276
answered May 18 '16 at 6:40
SylvainSylvain
1276
answered May 18 '16 at 6:40
SylvainSylvain
1276
answered May 18 '16 at 6:40
SylvainSylvain
1276
1276
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
add a comment |
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
1
1
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
"REST for PostGres" - it's either Postgres or PostgreSQL but never PostGres - you might want to change that
– a_horse_with_no_name
May 18 '16 at 6:57
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f75193%2fapi-on-top-of-postgresql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
When you say "API" you mean "Web service API" right?
– Craig Ringer
Aug 28 '14 at 11:37
Not only, it should be possible to use it as a web service, but it should also be possible to connect to it through other protocols than HTTP. So as Web Service is a subset of API, I actually mean API.
– spydon
Aug 28 '14 at 12:43
My point is that "API" is just "Application Programming Interface". PostgreSQL has several - the
libpqAPI for C,JDBCviaPgJDBC;ODBCviapsqlODBC; many more. You seem to want some specific subset of web-oriented web-service APIs, some over HTTP, and perhaps things like XML-RPC or SOAP. Right? These aren't "APIs" - they're web services or (in the case of XML-RPC) remote procedure calls.– Craig Ringer
Aug 28 '14 at 13:32
1
Somewhat understandable given the lazy use of "API" by many web-focused javascript coders to mean "web service API". Just worth being specific about when talking about things like this, it can get confusing. Thanks. Anyway: some design work was done here: wiki.postgresql.org/wiki/HTTP_API but I never saw any implementation. I suggest writing a wrapper with something like Tomcat and JAX-RS.
– Craig Ringer
Aug 28 '14 at 14:06
1
Hibernate Tools Reverse Engineering + Spring Data JPA + Spring Data REST would get you a JSON REST API in several minutes.
– Neil McGuigan
Aug 28 '14 at 17:56