Bug 451981

Summary:	Support Rainbow (coloured) Visualization for CSV files for Rainbow Plugin
Product:	[Applications] kate	Reporter:	fredygamez <fredygamez>
Component:	general	Assignee:	KWrite Developers <kwrite-bugs-null>
Status:	RESOLVED FIXED
Severity:	wishlist	CC:	waqar.17a
Priority:	NOR
Version First Reported In:	19.12.3
Target Milestone:	---
Platform:	Other
OS:	Linux
Latest Commit:	https://invent.kde.org/utilities/kate/-/commit/b14f6b1c467d3719332e7e8278ea3102a8a09c41	Version Fixed/Implemented In:
Sentry Crash Report:
Attachments:	Enable an option to see CSV files in colours by columns (Rainbow mode)

Description fredygamez 2022-03-28 03:07:49 UTC

Created attachment 147780 [details]
Enable an option to  see CSV files in colours by columns (Rainbow mode)

SUMMARY
***
Support a new visualization for CSV files like Rainbow project (coloured).  Visualization for CSV files for Rainbow Plugin is available for VI and VScode, however still not a version for Kate/Kwrite. Kate/Kwrite are excellent alternatives to open and edit really fast big CSV files, and some visual improvements can always make a big difference. 
***


STEPS TO REPRODUCE
1. Open a CSV file 
2. Go to status bar , change normal for CSV
3. Visual highlighting change to several colors by each column, like rainbow mode (https://rbql.org/)



EXPECTED RESULT
See the CSV files with different color by columns 

SOFTWARE/OS VERSIONS
All versions

ADDITIONAL INFORMATION
Suggestion to use the Rainbow Query Language https://rbql.org/

Here links with add-ons examples on other editors. 
- Vim: https://github.com/mechatroner/rainbow_csv
- VSCode: https://marketplace.visualstudio.com/items?itemName=mechatroner.rainbow-csv
- Sublime: https://packagecontrol.io/packages/rainbow_csv
- Atom: https://atom.io/packages/rainbow-csv

Comment 1 Bug Janitor Service 2024-03-28 22:12:42 UTC

A possibly relevant merge request was started @ https://invent.kde.org/utilities/kate/-/merge_requests/1437

Comment 2 Waqar Ahmed 2024-03-29 15:53:32 UTC

Git commit b14f6b1c467d3719332e7e8278ea3102a8a09c41 by Waqar Ahmed.
Committed on 29/03/2024 at 12:57.
Pushed by cullmann into branch 'master'.

Add Rainbow CSV plugin

Rainbow CSV plugin allows one to run SQL like queries on CSV data using
RBQL https://github.com/mechatroner/RBQL

Currently it has only one feature:
- Run RBQL queries on the file

The plugin automatically detects the separator of the file using the
highlightingMode information provided by the document.

Note that we already support rainbow style highlighting of the CSV files
via ksyntax-highlighting, though I haven't tested it with csv files that
have a lot of columns

A  +4    -0    3rdparty/rbql/README-kate
A  +21   -0    3rdparty/rbql/rbql-LICENSE
A  +2012 -0    3rdparty/rbql/rbql.js
M  +1    -0    addons/CMakeLists.txt
A  +15   -0    addons/rbql/CMakeLists.txt
A  +2    -0    addons/rbql/Messages.sh
A  +46   -0    addons/rbql/RBQLPlugin.cpp     [License: GPL(v2.0+)]
A  +36   -0    addons/rbql/RBQLPlugin.h     [License: LGPL(v2.0+)]
A  +9    -0    addons/rbql/RBQLPlugin.json
A  +312  -0    addons/rbql/RBQLWidget.cpp     [License: GPL(v2.0+)]
A  +49   -0    addons/rbql/RBQLWidget.h     [License: GPL(v2.0+)]
A  +7    -0    addons/rbql/plugin.qrc

https://invent.kde.org/utilities/kate/-/commit/b14f6b1c467d3719332e7e8278ea3102a8a09c41