Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Qt does nothing for you to protect your data. You should focus in securing your RDBMS first. Of course you should code your Qt client application carefully to prevent unintended behavior by checking and sanitizing all inputs, etc. but if you're not going to distribute it, this shouldn't be your most immediate concern.</p> <p>If you plan to use PostgreSQL as the backend for your application, you can take some measures to mitigate the risks that comes with exposing any service to the internets. The most basic:</p> <ul> <li>Setup a firewall with proper rules. Allow inbound connections from trusted sources only.</li> <li>Accept SSL connections only, even with a self-signed certificate.</li> <li>Enforce strong passwords. Use client certificates if more appropriated.</li> <li>Set your <code>pg_hba.conf</code> file to only accept connections from known/trusted addresses.</li> </ul> <p>Debian/Ubuntu have excellent PostgreSQL packages. Right after installing you can easily setup PG to allow SSL connections without going on the hassle of generating certificates manually.</p> <p>Relevant PostgreSQL docs:</p> <ul> <li><a href="http://www.postgresql.org/docs/9.2/static/runtime-config-connection.html" rel="nofollow">Secure TCP/IP Connections with SSL</a></li> <li><a href="http://www.postgresql.org/docs/9.2/static/client-authentication.html" rel="nofollow">Client Authentication</a></li> <li><a href="http://www.postgresql.org/docs/9.2/static/runtime-config-client.html" rel="nofollow">Client Connection Defaults</a></li> </ul> <p>I can provide you a very basic example Qt application (unfinished) that was designed to work with PostgreSQL if you want. Just let me know.</p> <p><strong>Edit:</strong> uploaded the example app to GitHub: <a href="https://github.com/dschulz/exampleapp.git" rel="nofollow">exampleapp</a>. Tried to tidy up but there's still a mess with a lot of strings that were originally written in spanish. At any rate, you can still find a bit of useful code if you're starting with Qt. Oh, and I'm using Qt5 and had to compile my own PostgreSQL driver for Qt (not a big deal if you're on Linux). I mention this because the app might or might not compile with Qt4. Good luck!</p>
    singulars
    1. This table or related slice is empty.
    1. POQuerying a database via desktop application / security
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USdschulz
    1. USdschulz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POQuerying a database via desktop application / security
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload