Mixing
How to use connection string with sequel for postgresql
I wanted to connect to postgresql database using connection string in form of
host=localhost user=x password=y dbname=z
this works fine when passed to psql
$ psql "host=localhost user=x password=y dbname=z"
and when passed to the PG gem
> PG.connect("host=localhost user=x password=y dbname=z")
however it fails when I try to pass it into sequel
> Sequel.postgres(constr)
Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory
How can I make sequel connect to my database?
ruby postgresql sequel
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
add a comment |
I wanted to connect to postgresql database using connection string in form of
host=localhost user=x password=y dbname=z
this works fine when passed to psql
$ psql "host=localhost user=x password=y dbname=z"
and when passed to the PG gem
> PG.connect("host=localhost user=x password=y dbname=z")
however it fails when I try to pass it into sequel
> Sequel.postgres(constr)
Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory
How can I make sequel connect to my database?
ruby postgresql sequel
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19
add a comment |
I wanted to connect to postgresql database using connection string in form of
host=localhost user=x password=y dbname=z
this works fine when passed to psql
$ psql "host=localhost user=x password=y dbname=z"
and when passed to the PG gem
> PG.connect("host=localhost user=x password=y dbname=z")
however it fails when I try to pass it into sequel
> Sequel.postgres(constr)
Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory
How can I make sequel connect to my database?
ruby postgresql sequel
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
I wanted to connect to postgresql database using connection string in form of
host=localhost user=x password=y dbname=z
this works fine when passed to psql
$ psql "host=localhost user=x password=y dbname=z"
and when passed to the PG gem
> PG.connect("host=localhost user=x password=y dbname=z")
however it fails when I try to pass it into sequel
> Sequel.postgres(constr)
Sequel::DatabaseConnectionError: PG::ConnectionBad: could not connect to server: No such file or directory
How can I make sequel connect to my database?
ruby postgresql sequel
ruby postgresql sequel
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
asked Nov 19 '18 at 19:31
graywolfgraywolf
2,50642752
2,50642752
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19
add a comment |
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19
add a comment |
1 Answer
1
active
oldest
votes
You could use a string with the connection information, for example:
conn_str = 'postgres://localhost/database_name?user=user&password=password'
DB = Sequel.connect(conn_str)
Check the Sequel's documentation of how to open connections with a hash
DB = Sequel.connect(
adapter: 'postgres',
host: 'localhost',
database: 'database_name',
user: 'database_user',
password: 'password'
)
Then you should be able to run:
DB[:table_name].where(:attribute => 5000..10000)
Or you could use the postgres method directly:
DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost')
Check devhints open connection shortcuts
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53381429%2fhow-to-use-connection-string-with-sequel-for-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
You could use a string with the connection information, for example:
conn_str = 'postgres://localhost/database_name?user=user&password=password'
DB = Sequel.connect(conn_str)
Check the Sequel's documentation of how to open connections with a hash
DB = Sequel.connect(
adapter: 'postgres',
host: 'localhost',
database: 'database_name',
user: 'database_user',
password: 'password'
)
Then you should be able to run:
DB[:table_name].where(:attribute => 5000..10000)
Or you could use the postgres method directly:
DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost')
Check devhints open connection shortcuts
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
add a comment |
You could use a string with the connection information, for example:
conn_str = 'postgres://localhost/database_name?user=user&password=password'
DB = Sequel.connect(conn_str)
Check the Sequel's documentation of how to open connections with a hash
DB = Sequel.connect(
adapter: 'postgres',
host: 'localhost',
database: 'database_name',
user: 'database_user',
password: 'password'
)
Then you should be able to run:
DB[:table_name].where(:attribute => 5000..10000)
Or you could use the postgres method directly:
DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost')
Check devhints open connection shortcuts
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
add a comment |
You could use a string with the connection information, for example:
conn_str = 'postgres://localhost/database_name?user=user&password=password'
DB = Sequel.connect(conn_str)
Check the Sequel's documentation of how to open connections with a hash
DB = Sequel.connect(
adapter: 'postgres',
host: 'localhost',
database: 'database_name',
user: 'database_user',
password: 'password'
)
Then you should be able to run:
DB[:table_name].where(:attribute => 5000..10000)
Or you could use the postgres method directly:
DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost')
Check devhints open connection shortcuts
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
You could use a string with the connection information, for example:
conn_str = 'postgres://localhost/database_name?user=user&password=password'
DB = Sequel.connect(conn_str)
Check the Sequel's documentation of how to open connections with a hash
DB = Sequel.connect(
adapter: 'postgres',
host: 'localhost',
database: 'database_name',
user: 'database_user',
password: 'password'
)
Then you should be able to run:
DB[:table_name].where(:attribute => 5000..10000)
Or you could use the postgres method directly:
DB = Sequel.postgres('my_db', :user => 'user', :password => 'password', :host => 'localhost')
Check devhints open connection shortcuts
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
edited Nov 19 '18 at 22:29
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
answered Nov 19 '18 at 22:00
hernanvicentehernanvicente
664615
664615
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
add a comment |
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Yeah I know about this way, but I get connection string formatted as in my question from the environment and wanted to avoid having to parse it :/
– graywolf
Nov 19 '18 at 22:20
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
Ok, I'll update my answer
– hernanvicente
Nov 19 '18 at 22:31
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fstackoverflow.com%2fquestions%2f53381429%2fhow-to-use-connection-string-with-sequel-for-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
Is your app a rails application?
– hernanvicente
Nov 19 '18 at 21:52
combination of hanami and grape if it helps
– graywolf
Nov 19 '18 at 22:19