Golumn
======
Golumn is a desktop CSV viewer to replace the ``column`` command. Think ``column`` with a "g". It behaves similar to the ``column`` command, but with a graphic user interface. It bridges the command line and desktop divide by allowing us to present tabular data outside the confines of the terminal.
.. class:: no-web
.. image:: https://raw.githubusercontent.com/ddrscott/golumn/dev/docs/screenshot.png
:alt: screenshot
:width: 100%
:align: center
It is challenging without this tool to manage a bunch of tabular output within only a terminal window. It's difficult to maintain context when long scrolling text and we're often executing the same statements to bring up previous results.
A typical workflow without this tool is chain together commands:
.. code:: sh
# psql
# -X :: ignore ~/.psqlrc
# -A :: remove whitespace
# -c :: run the SQL statement
# column
# -t :: table-ize
# -s :: set delimiter
# less
# -S :: Scroll horizontally (enables left/right arrows)
psql -X -A --pset footer -c 'select * from actors_list' dvdrental | column -ts '|' | less -S
When you're done viewing the data it disappears. Leaving you to remember what you saw as you're building the next statement. We could (and probably should) manage our terminal windows better with splits and tabs, but there's limits which desktop GUI's have solved. Enter ``golumn``.
Usage
-----
.. code:: sh
# Open a CSV file:
golumn data.csv &
# Pipe in the data:
cat data.csv | golumn &
# Show Query Results:
psql -X -A --pset footer -c 'select * from actors_list' dvdrental | golumn &
Installation
------------
Requires Python3. Please makes sure it's installed property on target OS with Pip package manager.
This package is available via https://pypi.python.org/pypi. To install on the target system try:
.. code:: sh
pip3 install golumn --upgrade --user
# --upgrade ensures you get the latest version
# --user install only for your user
On OSX Python with GUI support is required. Install using the following:
.. code:: sh
conda install python.app
For more info on install pip packages see:
https://pip.pypa.io/en/stable/quickstart/
Make sure ``pip3`` binaries are available in your ``$PATH``:
Contributing
------------
Bug reports and pull requests are welcome on GitHub at
https://github.com/ddrscott/golumn
License
-------
The gem is available as open source under the terms of the `MIT License <https://opensource.org/licenses/MIT>`__.
Raw data
{
"_id": null,
"home_page": "https://github.com/ddrscott/golumn",
"name": "golumn",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3",
"maintainer_email": null,
"keywords": "csv development desktop wxWidgets",
"author": "Scott Pierce",
"author_email": "ddrscott@gmail.com",
"download_url": null,
"platform": null,
"description": "Golumn\n======\n\nGolumn is a desktop CSV viewer to replace the ``column`` command. Think ``column`` with a \"g\". It behaves similar to the ``column`` command, but with a graphic user interface. It bridges the command line and desktop divide by allowing us to present tabular data outside the confines of the terminal.\n\n.. class:: no-web\n\n .. image:: https://raw.githubusercontent.com/ddrscott/golumn/dev/docs/screenshot.png\n :alt: screenshot\n :width: 100%\n :align: center\n\nIt is challenging without this tool to manage a bunch of tabular output within only a terminal window. It's difficult to maintain context when long scrolling text and we're often executing the same statements to bring up previous results.\n\nA typical workflow without this tool is chain together commands:\n\n.. code:: sh\n\n # psql\n # -X :: ignore ~/.psqlrc \n # -A :: remove whitespace\n # -c :: run the SQL statement\n # column\n # -t :: table-ize\n # -s :: set delimiter\n # less\n # -S :: Scroll horizontally (enables left/right arrows)\n psql -X -A --pset footer -c 'select * from actors_list' dvdrental | column -ts '|' | less -S\n\nWhen you're done viewing the data it disappears. Leaving you to remember what you saw as you're building the next statement. We could (and probably should) manage our terminal windows better with splits and tabs, but there's limits which desktop GUI's have solved. Enter ``golumn``.\n\nUsage\n-----\n\n.. code:: sh\n\n # Open a CSV file:\n golumn data.csv &\n\n # Pipe in the data:\n cat data.csv | golumn &\n\n # Show Query Results:\n psql -X -A --pset footer -c 'select * from actors_list' dvdrental | golumn &\n\nInstallation\n------------\n\nRequires Python3. Please makes sure it's installed property on target OS with Pip package manager.\n\nThis package is available via https://pypi.python.org/pypi. To install on the target system try:\n\n.. code:: sh\n\n pip3 install golumn --upgrade --user\n # --upgrade ensures you get the latest version\n # --user install only for your user\n\n\nOn OSX Python with GUI support is required. Install using the following:\n\n.. code:: sh\n\n conda install python.app\n\nFor more info on install pip packages see:\nhttps://pip.pypa.io/en/stable/quickstart/\n\nMake sure ``pip3`` binaries are available in your ``$PATH``:\n\nContributing\n------------\n\nBug reports and pull requests are welcome on GitHub at\nhttps://github.com/ddrscott/golumn\n\nLicense\n-------\n\nThe gem is available as open source under the terms of the `MIT License <https://opensource.org/licenses/MIT>`__.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Graphical CSV viewer. `column` with a \"g\"",
"version": "0.22.3",
"project_urls": {
"Homepage": "https://github.com/ddrscott/golumn"
},
"split_keywords": [
"csv",
"development",
"desktop",
"wxwidgets"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "d54f5509f5a6908484af21c2a895deac63432b8b6fa649eb90bed48210350834",
"md5": "35ee06785d0a035fa83c79f66065103b",
"sha256": "ca2510ca720bc1d76a68ba3783dfce83d86b887a5b3765dc8ce5a176139b11c1"
},
"downloads": -1,
"filename": "golumn-0.22.3-py3-none-any.whl",
"has_sig": false,
"md5_digest": "35ee06785d0a035fa83c79f66065103b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3",
"size": 22064,
"upload_time": "2024-12-16T15:05:06",
"upload_time_iso_8601": "2024-12-16T15:05:06.090241Z",
"url": "https://files.pythonhosted.org/packages/d5/4f/5509f5a6908484af21c2a895deac63432b8b6fa649eb90bed48210350834/golumn-0.22.3-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-16 15:05:06",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "ddrscott",
"github_project": "golumn",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "golumn"
}
JSON
