The latest articles on DEV Community by Kulogun Samuel (@ayoola24). https://dev.to/ayoola24 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F867625%2Fb727229b-00ea-4eb3-b933-b3662a4b39ce.jpeg https://dev.to/ayoola24 en Kulogun Samuel Wed, 25 May 2022 12:48:08 +0000 https://dev.to/ayoola24/using-postgresql-and-valentina-studio-through-cli-1b5g https://dev.to/ayoola24/using-postgresql-and-valentina-studio-through-cli-1b5g <h2> <strong>POSTGRESQL is a Database Managing System DBMS while VALENTINA is a multi data-management-tool.</strong> </h2> <p>After complete and proper installation of PostgreSQL on <a href="https://www.postgresql.org/download/">https://www.postgresql.org/download/</a> and valentina Studio on <a href="https://www.valentina-db.com/en/all-downloads/current">https://www.valentina-db.com/en/all-downloads/current</a>, I have a database to work on.<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--rlM42H4v--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kwg2p3m3kx2jw1t7grck.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--rlM42H4v--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/kwg2p3m3kx2jw1t7grck.png" alt="A picture of my available database" width="497" height="111"></a><br> Extracting the zip file into a folder you have the following files:<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--ogEu2kRA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jot7832qsdgu589oxn7g.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--ogEu2kRA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jot7832qsdgu589oxn7g.png" alt="Content of the extracted folder right here" width="880" height="196"></a><br> Next, databases are created for each file to work on Valentino Studio. First I create an Employee database for the employees SQL source file in the extracted folder. This is done by clicking "create database" on valentina and titling it accordingly, in my case "Employee".<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--DFQBsSNr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5mh7dg2jvie4aygphh1c.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--DFQBsSNr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/5mh7dg2jvie4aygphh1c.png" alt='A view of the "create database" on valentina' width="880" height="151"></a><br> Click on create<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--PDkb6jPR--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z9w8ryydxnbb3gsmytep.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--PDkb6jPR--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/z9w8ryydxnbb3gsmytep.png" alt="the pop up page for create" width="880" height="422"></a><br> Next is to upload our 'employees' sql source present in our extracted database file to the created 'Employee' database on our valentina studio through the Command Line Interface CLI. You can easily reach your command line on windows pressing 'cmd' on your search. This is highlighted below:<br> Step1: Locate the directory of the sql source file in my case 'employee' from the extracted folder. Copy the directory, <br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--03Vjn_Au--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iv8f4vbbmahmhxsq5fe9.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--03Vjn_Au--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/iv8f4vbbmahmhxsq5fe9.png" alt="View of my directory being copied" width="880" height="146"></a></p> <p>go to the CLI and press 'cd' meaning 'changing directory' then paste the copied directory,<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--WGYc5MnW--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6pnhnh0md7t7likx998t.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--WGYc5MnW--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6pnhnh0md7t7likx998t.png" alt="Changing directory of my command line" width="880" height="29"></a><br> tap enter and you have this:<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--zTeSkSjU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mzah95kesanlukw8cos8.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--zTeSkSjU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/mzah95kesanlukw8cos8.png" alt="View of my command line in the employee folder" width="880" height="68"></a><br> Step2: Locate your 'psql' file in your program files on your 'pgAdmin4' folder and copy the directory <br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--Iw0QubQe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/szge05745c8nn6hhebk5.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Iw0QubQe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/szge05745c8nn6hhebk5.png" alt="View of my directory being copied" width="880" height="132"></a><br> add psql.exe while having all the code in quote<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--x9IkhPIj--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7sd17ithhzq3gb3vicph.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--x9IkhPIj--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/7sd17ithhzq3gb3vicph.png" alt="Image description" width="880" height="34"></a><br> 'add -U postgres -d Employee&lt;employees.sql' to upload the employees.sql to the pgAdmin4 and the -d to upload to the database on valentina. You have something of this nature:<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--gi1tasd7--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bq1x903px37gv9do4zfo.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--gi1tasd7--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/bq1x903px37gv9do4zfo.png" alt="View of how the code" width="880" height="39"></a><br> tap enter and it demands for your postgres password <br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--VvQ4zbLq--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/edivp3pn8xtl6k9moqg9.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--VvQ4zbLq--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/edivp3pn8xtl6k9moqg9.png" alt="Inputting your password" width="307" height="29"></a><br> You input your password and schema is created in the Employee folder in your database. A Schema is what contains tables and the details in your valentino.</p> <p>We can now return to our valentina click on the public to see the tables present in our uploaded database.<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--ooBUIuSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b8w09jponq2tigqlysj1.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--ooBUIuSn--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b8w09jponq2tigqlysj1.png" alt="Schema in our valentina studio showing us the tables" width="880" height="305"></a></p> <p>To query your database, you click on the sql employee beside the Schema editor and the codes can be executed.<br> <a href="https://res.cloudinary.com/practicaldev/image/fetch/s--W10zpZ57--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zw2t0djjxrapu5aw0z71.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--W10zpZ57--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zw2t0djjxrapu5aw0z71.png" alt="Using the Schema editor for query" width="880" height="343"></a></p> sql tutorial writing postgres