Skip to Content

PostgreSQL Query Deluxe

by
Odoo
v 14.0 Third Party 10312
Download for v 14.0 Deploy on Odoo.sh
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 375
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/query_deluxe/
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Lines of code 375
Technical Name query_deluxe
LicenseAGPL-3
Websitehttps://github.com/YvanDotet/query_deluxe/
Versions 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0

The complete app for making easy queries in PostgreSQL

Explore your PostgreSQL database with query into an Odoo interface

You can use SELECT, UPDATE, DELETE, CREATE, INSERT, ALTER and DROP statements.

Find examples

Remember useful queries

Get a description of what the query does.

Memorize your own example

Save repetitive query

You can store your own query to re-use it quickly.

Print your result

PDF format

Print your table's result in a PDF format, landscape or portrait orientation.

History

History of your previous queries

You can retrieve the last queries you have typed.

query_deluxe

This module is usefull to make postgreSQL's queries directly from an Odoo interface.

You can type queries involving SELECT statement and many clauses like WHERE, AND, etc ...

The result is correctly presented in a table form.

You can also make UPDATE, DELETE, CREATE, INSERT, ALTER and DROP statements.

Usage

Go to "Apps" menu and type "query_deluxe" into the search box.

Odoo version 14

Credits

Authors

  • Yvan Dotet

Maintainers

  • This module is maintained by Yvan Dotet.

Contact

  • Mail address of Yvan Dotet : Yvandotet@yahoo.fr
  • website :
    1. https://github.com/YvanDotet/query_deluxe
    2. https://be.linkedin.com/in/yvan-dotet-19ba67135

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.
Great App
by
Dieter Reinert
on 3/17/22, 9:46 AM

Great application, just a note that horizontal overflow is still a issue. But the biggest issue is Odoo bugging out whenever you query the following:

SELECT * from ir_ui_view

Re: Great App
by
Yvan Dotet
on 3/17/22, 11:18 AM Author


Resulting Table view doesn't fit into the screen
by
Utsav Sedani
on 11/19/20, 12:16 AM

Hello,
There's a bug in your app. When I am executing the query in your app the resulting table view doesn't fit in the screen as the table contains large number of columns and there's no option for horizontal scrolling to view the columns.

Re: Resulting Table view doesn't fit into the screen
by
Yvan Dotet
on 11/19/20, 12:51 PM Author

Dear Mr Sedani,

Can you give me the name of the browse you use to work with this module ?

It's work well for chrome and firefox with windows and ubuntu.

Sincerely,

Dotet Yvan.

yvandotet@yahoo.fr

by
Yvan Dotet
on 3/18/22, 11:40 AM Author

Dear Mr Reinert,

The command 

"SELECT * from ir_ui_view"

load a lots of record (2579 rows on my exemple) with many colums (more than 29 columns) and it can take time.

You can load less lines with a limit argument "limit=100" or to select particular fields in the select.

Sincerely,

Dotet Yvan.

yvandotet@yahoo.fr

So good！
by
AYSP
on 12/11/20, 5:17 AM


Re: So good！
by
Yvan Dotet
on 12/11/20, 3:18 PM Author

Dear AYSP,

Thanks for your return.

If you have any ideas to improve this app, don't hesitate to ask.

   
Sincerely,

Dotet Yvan.

Reply to previous comment
by
Utsav Sedani
on 11/19/20, 11:31 PM

Dear Yvan,

I have tested in chrome browser as well as Firefox, I can share the screenshot in your mail if you want.

Otherwise the module is perfect.

Thanks and Regards, 

US

Re: Reply to previous comment
by
Yvan Dotet
on 11/20/20, 4:06 PM Author

Dear Mr Sedani,

Yes I will be great if you email me the bug.

Thanks to send the bug at " yvandotet@yahoo.fr ".

I have check that the table in Safari (ios apple) don't show a scrollable bar if the overflow is too big. It only display if the mouse is on over the table.


Thank you.

Sincerely,

Dotet Yvan.

Perfect app for querying a Postgresql database.
by
Yvan Dotet
on 11/17/20, 7:04 PM Author

Please leave a comment, thank you.

Perfect app for querying an Postgresql database
by
Yvan Dotet
on 11/17/20, 7:01 PM Author

Perfect app for querying an Postgresql database