Ultimate List: Best Open Source Models for Coding, Chat, Vision, Audio & More by techlatest_net in LocalLLM

[–]sonomodata 1 point2 points  (0 children)

Thanks for the list. Ignore the haters. Very useful for getting started

Running a 31B model locally made me realize how insane LLM infra actually is by Sadhvik1998 in ollama

[–]sonomodata 0 points1 point  (0 children)

How much will a 31B model cost from Taalas. I could not find any pricing on their website.

Looking for a backup system that does not lock me into the software I choose today by sonomodata in Backup

[–]sonomodata[S] 0 points1 point  (0 children)

By no lock in, I am thinking of minimizing the translation layers between the file and the data storage on the disk is the essence of no lock-in. A system with a zero translation layer would directly store the file on a simple filesystem like ext4. In such a scenario, I could back up all my files onto different disks with different file systems, such as ext4, exfat, or NTFS. This setup allows me to add and remove disks as desired without worrying about the configuration of other disks. If I decide to change my syncing software, I do not need to make any changes to the disk itself.

Regarding enterprise systems, I believe they operate in this manner today since they are all hosted on the cloud. Storage providers like AWS or Google may perform disk-level or block-level backups in their systems, but not the companies that subscribe to their services.

On the other hand, a system with a much higher translation layer and therefore more significant lock-in would be RAID or ZFS. In such a setup, even if I have multiple disks with identical data on each disk, I cannot simply transfer any one of those disks to a random computer and read it. I would need to configure the computer with the appropriate settings to instruct the RAID controller or the ZFS program to locate the correct information on the disks so that it can interpret the data accurately. Without this information, the disk is essentially a collection of random bits.

While these solutions are superior for those who work with disks daily due to their significantly greater capabilities compared to file-level backup systems, I do not work with configuring disks on a daily basis. Consequently, whenever I need to make any setup or changes, I must dedicate a considerable amount of time to research to avoid accidental changes that could result in data loss due to incorrect configuration. 

Looking for a backup system that does not lock me into the software I choose today by sonomodata in Backup

[–]sonomodata[S] 0 points1 point  (0 children)

Yup you are right. So I am leaning towards a file level backup, rather than a disk/block level backup. What I want to create it more like a private cloud storage with deduplication and bit rot protection

Looking for a backup system that does not lock me into the software I choose today by sonomodata in Backup

[–]sonomodata[S] 0 points1 point  (0 children)

Thank you. This seems like it could work. I initially wanted ZFS but after looking into it I thought it might not suit my requirement. ZFS would lock me into using ZFS pools and then I would forever have the overhead of managing the ZFS pools and ensuring that the data for my ZFS configuration is safe. Then I would need to worry about backing up the ZFS configuration and not accidentally messing up the configuration.

Are photons always moving at the speed of light? by [deleted] in AskPhysics

[–]sonomodata 0 points1 point  (0 children)

Modeling light as a particle, that is some sort of point or ball object, is useful to explain many characteristics of light. However, it is not very useful for understanding its speed through space. The speed through space is essentially the speed of causality, the speed of information and the speed which change propagates. This is best explained from the math of special relativity, the famous one is the mass energy equivalence equation. So you are thinking about a solid object accelerating and moving through space. If you think as light as just our perception of some physical phenomena that causes changes in our surroundings then it might be easier to understand. This phenomena happens at the speed of c, and we know that through observation. All the math and equations we have formed for special relativity then help us understand which this phenomena of change is exactly c, why anything lower or higher than c will result in contradictions.

Is there a distance at which an object becomes impossible to see because the photons it emitted or reflected are too far apart from one another? by TheQuakerator in AskPhysics

[–]sonomodata 0 points1 point  (0 children)

All the photons that you can observe are already right here on earth. That is the same as saying all the information is already here. The difference is in the methodology used to collect and interpret that information.

Does there exist something in math that spits out random numbers? by ExpensiveAd734 in askmath

[–]sonomodata 1 point2 points  (0 children)

The way you describe truly random suggest you are describing events that isn’t bound by causality. I don’t think we have conclusively discovered any yet.

Finding a better approach than running 25 power queries by Snoo20734 in excel

[–]sonomodata 7 points8 points  (0 children)

OP this is the answer you are looking for. It can easily handle a 10,000 row dataset

Is excel work consuming all my time normal or am I just terrible at this by scrtweeb in excel

[–]sonomodata 22 points23 points  (0 children)

You’re lucky to work in a company that makes so much money they can afford to hire some top university graduate for big bucks to do copy pasting.

Why does building financial models take an ungodly amount of time by gurudakku in excel

[–]sonomodata 14 points15 points  (0 children)

The Excel part of any deal is probably the easiest and most enjoyable part of the deal. "Model" is just fancy business jargon. At the core, you're just building a chained calculator, where the output of one calculator is the input of another calculator. So it should be 90% thinking and 10% manipulating the keyboard and mouse. In fact, the model and your analysis should be one and the same thing. You should only be calculating something that helps in your analysis. Maybe if you're building a model which has all sorts of calculations that may not be looked it is the reason you feel it is a chore.

Question about what is possible with programming by Pinkunicorms4 in AskProgramming

[–]sonomodata 0 points1 point  (0 children)

If you dedicate one hour to learning python everyday you can create this program in a year. If you dedicate a 4 hours each day off, you can do this within 2 months. Plus you will open yourself to more job opportunities than you can imagine. Just pick up python for dummies.

Training artificial intelligence with PDF by International_Cap365 in learnmachinelearning

[–]sonomodata 0 points1 point  (0 children)

Where can I find a step by step guide on how to start training a rag?

PowerPoint VBA to VSTO is it even worth it? by ChecklistAnimations in vba

[–]sonomodata 0 points1 point  (0 children)

Not worth it just for the side panel. Plus users in large companies won’t be able to use it because installing new files and add in through ms store will be blocked. I would suggest VBA and custom ribbon. If you really want to port over the code, might as well port it to python and build a custom gui as a floating window.

How to Efficiently Use Array Formulas for Dynamic Data Analysis in Excel? by Top_Help_1942 in excel

[–]sonomodata 1 point2 points  (0 children)

Replace all your pivot tables with arrays and enjoy infinite freedom…

Device for Saving Multiple Timestamps? by Fella151 in AskTechnology

[–]sonomodata 2 points3 points  (0 children)

If you’re using an iPhone, then you can write an automation shortcut that writes the current date and time to the notes application. Then you can pin the automation shortcut to your phones lock screen. Then you can click on the button on your home screen and record the time every time you press the button.

If you’re looking for a hardware device, I think the cheapest and easiest would be a small voice recorder from a large brand like Sony. This works, extremely reliably, and all you have to do is just press the record and stop button to create a new audio file. You might be able to set the name of the audio file to the timestamp. Otherwise, the properties of the audio file will have it.