[NFBCS] Question regarding SQL editors

[Lewis Wood]

They are typically called orm (Object relational Model) many of them offer column suggestions and a bit more.

 

vscode offers psql and other sql extensions you may be able to use.

 

I personally list the table structures and keys to a text file and use this to design my sql, but I am old school.

 

 

For example:

  I create a postGreSQL db using Docker.

 

I run it to get to a psql prompbt.

 

I then run my sql with simple commands and examine the results.

If I get an error I modify the script and rerun it.

 

If I need to restart, I simply run the restore script.

 

 

 

Here is my repository.  If you are unfamiliar with git clone, simply locate the code button menu and select download as a zip file.

 

 

https://github.com/lewislwood/postgresql-persistent-connect

 

 

You will have to install Docker in order to run this server.

 

 

 

 

Lewis Wood

lewislwood at gmail.com <mailto:lewislwood at gmail.com> 

 

From: NFBCS <nfbcs-bounces at nfbnet.org> On Behalf Of Purvi Contractor via NFBCS
Sent: Monday, July 29, 2024 8:20 PM
To: Peter via NFBCS <nfbcs at nfbnet.org>
Cc: Purvi Contractor <purvidc2 at gmail.com>
Subject: [NFBCS] Question regarding SQL editors

 

Hello,

I am  learning SQL. I was able to run queries on data frames using RStudio   and the sqldf library.

I tried to execute queries on  SQLite   as well as  BigQuery, but I am unable to access the menus using JAWS or NVDA. Can you please let me know if these editors have accessibility settings or what SQL editors are accessible? 

Thanks for your help. 

 

 

 

 

 

Thanks,

Purvi

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://nfbnet.org/pipermail/nfbcs_nfbnet.org/attachments/20240729/b24e856c/attachment.htm>