SQL Apps and/or connections

[Nathan McArthur]

Hi all,

I am about to jump head-first into SQL and wanted some advice about iOS apps that I can use to manage my queries for reuse and edits.

I am also looking for a DB visualizer or connection (it doesn't have to be live or even contain actual student data) to PS to visualize the tables that we have. That will help me write the queries. 

I have looked at DBvisualizer and SQL Developer, but I wanted your collective experience before I jump in. I suppose this is my look-before-I-leap moment. 

Thanks,

Nate McArthur

EdTech LPSD

[Kyle Schneider]

I can’t give you a ton of advice on your exact questions - I’ve never been able to extensively work on iOS, I use my Mac.

I keep a lot of my queries in a Github repository. I use an app called Working Copy that will pull my Github repos down to iOS or iPad if needed, but again, I haven’t attempted serious work on iOS.

For visualization… you might want to look at Enterprise Reporting in PowerSchool. Their query builder would be useful. To be truthful, I’m not even sure if there’s a definitive guide the way you’re thinking about it - you can join things in SQL on wildly incorrect things and just get no results (or weird results), because all the relationships aren’t formally defined in the database.

—
Kyle Schneider
GSD Educational Services
Desk: 907-917-4149
Cell: 802-281-8430
ky...@gsded.com

--
You received this message because you are subscribed to the Google Groups "AK PSUG" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ak-psug+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ak-psug/ed701b38-9dbe-46a0-acad-fddbb94bee20n%40googlegroups.com.

[Nathan McArthur]

That's my fault i mean MacOS (native Windows user learning mac lingo hahaha) 

anything for MacOS

Thanks,

Nathan McArthur

EdTech

LPSD/BBRCTE

Alaska

To view this discussion on the web visit https://groups.google.com/d/msgid/ak-psug/2FE553B0-F7E8-4932-89F2-C90F0C604D02%40gsded.com.

[The Chad]

VS Code is my personal go to for writing SQL. It has a MacOS version, an Oracle Developer Extension, and can connect directly to my DB for viewing tables (requires a VPN or being on the same network - We're self hosted).

I have also tried SQL Developer and DBeaver, but didn't really care for the UI in either. VS Code keeps things simple. List of tables on the left, space for code on the right.

I also keep the code I write in Github, but I use Github Desktop to sync. It requires pushing / pulling the code manually, but that has been good for me to learn.

To view this discussion on the web visit https://groups.google.com/d/msgid/ak-psug/CAFg702XTWvhWoFuXA7WUuTdPq8%2BistDNzv935DOeoZdbxm5fvg%40mail.gmail.com.

[Kyle Schneider]

NaviCat is a really nice program for working with SQL. It is a paid application though.

--

Kyle Schneider

GSD Educational Services

Phone: 907-917-4149

Fax: 802-281-3272

Ky...@gsded.com

Sent from my iPhone

On Apr 19, 2024, at 11:07 AM, The Chad <chad....@k21schools.org> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/ak-psug/CAB5OjTyMz%3DvDVHphBV8NiRq7QFNH0CYZGjrOdzmkVvH-1Jor5w%40mail.gmail.com.