A site devoted mostly to everything related to Information Technology under the sun - among other things.

Showing posts with label Open-Source Sofware. Show all posts
Showing posts with label Open-Source Sofware. Show all posts

Monday, February 17, 2020

Useful Tools for PostgreSQL

DBweaver:
The community edition is free. It will address most of the common functionality one may need.

Microsoft Excel:
Note: Before you can connect to a PostgreSQL database in Power Query, you need the Ngpsql data provider for PostgreSQL installed on your computer. Select the driver that matches your Office version (32-bit or 64-bit). See: Which version of Office am I using? for more information. Also make sure you have the provider registered in the machine configuration that matches the most recent .NET version on your device.

1. Click the Data tab, then Get Data > From Database > From PostgreSQL Database. If you don't see the Get Data button, then click on New Query > From Database > From PostgreSQL Database.
2. In the PostgreSQL Database dialog box, specify the PostgreSQL Database Server you want to connect to in the Server Name section.
3. If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.
4. Select OK.
5. If the PostgreSQL server requires database user credentials:
a. In the Access a Database dialog box, enter your username and password.
b. Select Connect.

Microsoft MS SQL Server Management Studio:
Using Management Studio to connect to PostgreSQL - https://www.devart.com/odbc/postgresql/docs/microsoft_sql_server_manager_s.htm
It is a free download from:

pgAdmin:
Depending on whether one mostly needs to perform admin. or query/script development, it may not have everything one requires … but one should certainly check it out.
Available from https://www.pgadmin.org/

Sunday, February 19, 2017

PIXEL - for MAC & PC

PIXEL is the desktop OS (PC & MAC) from Raspberry Pi Foundation.  It is a version of GNU/Linux with a modern user interface; a curated suite of productivity software and programming tools, both free and proprietary; and the Chromium web browser with useful plugins, including Adobe Flash, pre-installed.

Find it @ https://www.raspberrypi.org/blog/pixel-pc-mac/.

Some additional information @ https://www.raspberrypi.org/blog/introducing-pixel/

Wednesday, September 21, 2016

PowerShell @ GitHub

Microsoft open sourced PowerShell:

GitHub - PowerShell/PowerShell: PowerShell for every system!



Sunday, January 31, 2016

REBOUND

REBOUND is a new multi-purpose N-body code which is freely available under an open-source license. It was designed for collisional dynamics such as planetary rings but can also solve the classical N-body problem.  It is described in a paper @ http://arxiv.org/pdf/1110.4876v2.pdf


Find it @ https://pypi.python.org/pypi/rebound/0.2.2

Tuesday, September 22, 2015

SIVO Python Distribution (SIVO-PyD)

IVO-PyD (from NASA) is a self-contained Python distribution that includes a set of Python related packages for scientific computing. It attempts to provide a simple and but robust alternative to the Enthought Python Distribution.  Find it @ https://modelingguru.nasa.gov/docs/DOC-2109.



Monday, August 17, 2015

Open-Source Development Platforms for Drones

If you are looking for mature open-source software development tools for drones , look no further than OpenPilot and Dronecode.


Check them out!


Please note that a commercial pilot's license is required to control a drone.



About Me

My photo
I had been a senior software developer working for HP and GM. I am interested in intelligent and scientific computing. I am passionate about computers as enablers for human imagination. The contents of this site are not in any way, shape, or form endorsed, approved, or otherwise authorized by HP, its subsidiaries, or its officers and shareholders.

Blog Archive