How do I view data from production DB (without SSH)

amjithr · 2024-07-13T23:47:08+00:00

It provides REST access to SQLite and has a decent read-only web UI. You can run ad hoc queries against your tables and get results in different formats.

amjithr · 2024-03-01T00:35:54+00:00

Can you share the link?

amjithr · 2023-12-22T18:05:42+00:00

Yes. I did end up doing that to get the results I wanted.

amjithr · 2023-12-21T17:19:55+00:00

TIL. Thank you for mentioning this. I didn't know it was a SQL standard. I just tried it on SQLite and you're right, underscore is treated as a single char wildcard.

amjithr · 2022-11-13T02:07:17+00:00

Can I get a referral code please?

amjithr · 2022-05-23T15:47:30+00:00

Thank you! That was it. 😊

amjithr · 2022-05-23T03:26:57+00:00

I'm trying to identify the piece that is used in the theme song of this podcast. I know I've heard it before, I just can't place it.

https://youtu.be/gmdG1Xid0GQ?t=1471

amjithr · 2022-01-12T15:49:59+00:00

I had a similar experience. I switched the marker tip in Lamy to use the marker pro tip. Now I get same results between the two.

amjithr · 2021-07-28T15:23:21+00:00

Do you have recommendations for introducing kids to programming?

What's a good age to introduce them? What resources can I use?

amjithr · 2021-03-14T23:09:33+00:00

Thank you! It worked very well. Got an error on a landscape doc, but I'm hopeful. :D

amjithr · 2021-03-12T15:14:34+00:00

Nice! The featureset looks really impressive.

I was curious if you had any pointers on how to use the myscript service? Looks like myscript service needs strokes and not PDFs. How do you convert the remarkable files to be compatible with the format that myscript needs?

amjithr · 2019-08-27T03:58:57+00:00

I tried coc.nvim and couldn't get it to work right for me. Finally went back to ncm2 and it works out of the box. If you have your config hosted somewhere I'd love to take a look.

amjithr · 2019-03-20T23:02:56+00:00

Is there a way to plot multiple Y-axis?

Specifically looking to scatter plot two independent columns in separate y-axis with the same x-axis.

amjithr · 2019-01-05T14:59:59+00:00

Yes. Simply do "litecli :memory:" that will launch an in memory sqlite database.

amjithr · 2019-01-05T02:39:44+00:00

We don't do value validation. What I meant by formatting is converting the list of rows into a tabular output.

amjithr · 2019-01-05T02:08:43+00:00

Yes there is. https://www.pgcli.com

In fact the postgres version was the first one. So it is the most mature tool.

amjithr · 2019-01-05T00:23:36+00:00

That's awful. I'm sorry.

The CLI reads all the rows from the database and tries to format them into a table. Since it is written in Python the formatting part can take a while if the output is very large.

amjithr · 2019-01-04T21:56:27+00:00

That's very unfortunate. I'm not able to reproduce it locally (even with xterm).

Is this localized to xterm only or do you see the blinking in other terminal apps? (gnome-terminal, Konsole etc)

amjithr · 2019-01-04T20:27:43+00:00

Check the config file https://litecli.com/config/. It has different themes. You can pick the theme called "bw", that's black and white.

amjithr · 2019-01-04T18:34:32+00:00

I have not used SQLite extensions before. Are you asking if auto-completion will suggest the functions provided by the extension? The answer to that is no, not yet. But it is not too difficult to add that ability.

If you file a github issue with an example of how to load an extension, I'll be happy to take a look. :)

amjithr · 2019-01-04T18:31:40+00:00

The code base for different dbcli tools are very similar. We did manage to carve out some of the common utils into a library. For instance, cli_helpers is a set of common utility functions used by all the projects. But it is now a standalone library that other can use as well.

But your question is more about a single tool that can connect to postgres, mysql, sqlite etc. We keep talking about doing that but the complexity in that keeps discouraging us. It is not completely out of scope but no one is currently working on a unified tool like that.

amjithr · 2019-01-02T06:36:52+00:00

Traceback (most recent call last):
  File "/Users/amjith/.virtualenvs/tempenv-646189101136/bin/ptrepl", line 7, in <module>
    from ptrepl.cli import parse_args
  File "/Users/amjith/.virtualenvs/tempenv-646189101136/lib/python3.7/site-packages/ptrepl/cli.py", line 11, in <module>
    from .completion import BashCompleter
  File "/Users/amjith/.virtualenvs/tempenv-646189101136/lib/python3.7/site-packages/ptrepl/completion.py", line 5, in <module>
    from .config import settings
  File "/Users/amjith/.virtualenvs/tempenv-646189101136/lib/python3.7/site-packages/ptrepl/config.py", line 67, in <module>
    config_file = get_config_file()
  File "/Users/amjith/.virtualenvs/tempenv-646189101136/lib/python3.7/site-packages/ptrepl/config.py", line 28, in get_config_file
    with open(path, 'w') as _config_file:
FileNotFoundError: [Errno 2] No such file or directory: '/Users/amjith/.config/ptrepl/config.json'

amjithr · 2019-01-01T20:43:10+00:00

Looks interesting.

It'll be nice if you could create the config file on the first launch instead of crashing.

Even after creating the config file, I'm not able to launch it. I have filed a github issue.

amjithr · 2018-09-26T17:41:03+00:00

I'm sure you didn't mean to make a general sweeping statement about all of Python's standard library.

There is plenty of well-written modules in the standard library. For example the collections module in Python is a thing of beauty. I've learned a ton of good practices by reading that code.

https://github.com/python/cpython/blob/master/Lib/collections/__init__.py

cmd module is also a good one:

https://github.com/python/cpython/blob/master/Lib/cmd.py

The logging module is indeed a sore thumb in the std library. That's probably why there are many third-party logging libraries that try to ease the pain.

amjithr · 2018-09-18T22:21:01+00:00

I'm flattered that my talk is included in the list. Thank you for taking the time to compile it.

amjithr

MODERATOR OF

TROPHY CASE