[NFBCS] Question regarding SQL editors
Lewis Wood
lewislwood at gmail.com
Tue Jul 30 02:31:43 UTC 2024
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>
More information about the NFBCS
mailing list