Hacker News .hnnew | past | comments | ask | show | jobs | submit | djsnoopy's commentslogin

The sp500 did 20%+ over 12 months. Hardly worth trusting the llm


Well, it’s harder then you’re letting on if your leverage costs 20%+.


Apple is up 40% this year, VOO is up 27%.

20% cost and you’re still ahead


Yes if the market goes up a lot you win. That's generally how leverage works. The problem is when it goes down. Or, if you're borrowing at high interest, doesn't go up quite as much. (Which leads to many people selling, which drives the price down, which leads to selling, and so on).


And what if Apple is not up 40% this year?

Apple was down 24% during Dec 2021-Dec 2022. It could have happened this year, could happen next year. Nobody knows.

By comparison, VOO was down 18% during that period. If you put money in Treasury bonds, you come out positive.

My point is that there is a reason behind many practical, reasonable financial advice instead of "cash advance at 20%, and if you are lucky, you could still be ahead".


Dear reader: do not take financial advice from this person's comments.


The percentage share of personal domains doesn’t tell you everything. More and more consumers probably are buying personal domains just by the nature of it getting cheaper and easier to host and there being more people on the internet year over year. Could be proven wrong though because I don’t know how to get the numbers.


What does this have that the SQLite command line program doesn’t? Because every time I try one of these I go back to the cli.


Here's one use case: while I don't use this particular GUI, it really does help when you have some columns containing RTL text such as Arabic and you want to browse through a table. RTL handling in most terminal emulators I've used is really lacking, though I can't blame them.


That's actually a really interesting case I had never considered. I actually just took it for granted that RTL in the console was a solved problem


Not just in consoles. While RTL is solved for most cases, I generally avoid writing Arabic in code for example (hard-coded strings, regex, etc) and just use Unicode escape sequences. Some issues include ASCII punctuation appearing (visually) in the wrong order and very awkward text selection


One day I set out to resolve this, though I can not find in my notes' files what the solution was (for MySQL). It might have been to simply use MyCLI instead of the standard MySQL CLI. Have you tried it?

https://github.com/dbcli/mycli


Lots of things! It gives you sqlite superpowers. It makes you more productive and saves you lots if time. You can edit several databases at the same time. And editing them is far easier. For example, it generates and executes the sql code to add new columns for you. You can edit the data of several rows directly on a query response, as if It was a spreadsheet, just by clicking on a column value (or you can use a column value editor). Super handy. You can view and edit blobs. The sql editor has autocompletition and you can execute a statement just by having the cursor on this statement, so you can quickly test multiple independent queries in a single editor window. It shows the execution times, so you can easely compare the speed of several query strategies. You can view the query optimizer info by clicking a button. It supports several scripting lenguajes, and the list goes on and on. Check the features here: https://sqlitestudio.pl/features/


All the benefits of a normal GUI-based DB manager. So "too many things to list, have a look at the website, it should be pretty self-explanatory" =D


This interface is similar to Toad from Quest Software, or SQL Developer from Oracle.

If you don't like either of those, then you likely won't like this.

After a quick search it is possible to load a JDBC driver into SQL Developer.

https://www.reddit.com/r/sqlite/comments/ci1wd2/sqlite_conne...


I went from company F to company V, used Toad at F all the time. I was told at V that Toad was not approved nor money for it. So I bought my own copy. Within 6 months all of the DBA team owned copies of Toad, a few months later V bought it for Developers and paid back all the DBA team for their copies.


I am stuck with stubborn developers who are holding on to Oracle 8-era Toad. Everybody else is on SQL Developer.

I wish I could erase it.


Maybe if a) Oracle did upgrades to SQL-D and b) Didn't charge for SQL-D like it was made of spun Unicorn horn you would have better luck.


UI is quite useful to me


Allows people who are not versed in SQL to interact with and edit sqlite files as if it was a spreadsheet (for better or worse)


For example it has context-aware syntax autocompletion, easy D&D for tables between databases, and many more - you can see longer list at https://sqlitestudio.pl/features/


Maybe UI


A good alternative to the sqlite cli is litecli [1]. I've been a happy user for quite some time.

[1] https://litecli.com


Agreed, rip the band-aid off folks. You will be so glad you did.


Ridiculously niche comments from experts like this is why HN is so special. Thank you.


No problem. It’s also why I love HN.


Cell phones, distracted drivers


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: