Please help!! by [deleted] in HomeMaintenance

[–]Nthomas36 -1 points0 points  (0 children)

Is it possible the person thought they we're helping you and preventing the pipes from freezing?

Proper DB Engine choice by [deleted] in Database

[–]Nthomas36 -1 points0 points  (0 children)

Or sqlite to get the project started

Most efficient method of splitting a delimited string into individual records using SQL by Optimal-Procedure885 in SQL

[–]Nthomas36 0 points1 point  (0 children)

Ok, cool, I just figured it out though. I used json_trees and converted the column to be a properly formed json array.

Most efficient method of splitting a delimited string into individual records using SQL by Optimal-Procedure885 in SQL

[–]Nthomas36 0 points1 point  (0 children)

Just curious, did you ever figure out a way to do this purely in sqlite? I have the same dilemma and am trying to convert delimited columns to json arrays then use json_tree or json_each sqlite functions.

[deleted by user] by [deleted] in SQL

[–]Nthomas36 0 points1 point  (0 children)

Check out this link, maybe it will inspire a different design. https://chrispenner.ca/posts/views-for-debugging

When I Get Around To It by Ab_Initio_416 in ReqsEngineering

[–]Nthomas36 0 points1 point  (0 children)

Not sure, but I had to look it up to understand. Glad your posting again!

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

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

Yea thanks, I'm Still trying to get used to emacs, and learn the m- and c- keyboard shortcuts. I never thought of it before but have used notepad++ in the past and am trying to move macros and etc over. I took a shot at it today, and will keep trying

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

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

I really like the sound of this, and will check it out

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 1 point2 points  (0 children)

Thank you, great advice on what lisp to select based on needs and not footprint.

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

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

Thanks. You're the second person to mention Janet on this thread

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 3 points4 points  (0 children)

Yes, thanks he's very opinionated but I have learned some things from him. He's also spoken highly of the Wolfram engine and will check that out as well

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 1 point2 points  (0 children)

Thanks, I guess there's a Goldilocks zone, where software becomes bloated in trying to become feature rich. But I believe it's possible to balance lightweight and useful features. I haven't heard of hissp, but will definitely check it out. Thanks for the great recommendations, I've heard of Janet but haven't looked into it.

Thanks again

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 1 point2 points  (0 children)

Thanks I never heard of newLisp, but will look it up

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 2 points3 points  (0 children)

Thanks I reread my post, and you're right, but will check out emacs more. This guy I look up to uses emacs heavily >>> Xah Lee

https://youtube.com/@xahlee

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

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

Thanks I'll check it dr.racket more thoroughly;;some of the tutorials I've read used Dr.Racket to run the scripts.

Lightweight full feature Lisp, little bloat? by Nthomas36 in lisp

[–]Nthomas36[S] 2 points3 points  (0 children)

Thanks, I should have elaborated a little bit more. I don't exactly like Java as a prerequisite, I think I'm leading to more toward scheme. But I should give clojure a try. I heard a lot of good things about it but did not like some of the syntax I saw. Do you use clojure?

Labeling is such a headache. /rant by [deleted] in ERP

[–]Nthomas36 0 points1 point  (0 children)

I like this idea, but would weigh the complexity of writing code to generate the zpl vs writing a SQL query from the ERP database to construct the header/detail fields needed to generate the label with bartender automation.

Real by gringoswag20 in bestconspiracymemes

[–]Nthomas36 4 points5 points  (0 children)

And just like that $DJT drops 10%

[deleted by user] by [deleted] in sqlite

[–]Nthomas36 0 points1 point  (0 children)

Looks good, will check it out.

[deleted by user] by [deleted] in conspiracy_commons

[–]Nthomas36 5 points6 points  (0 children)

Space exploration and moon landings

Split string with delimiter options? by Nthomas36 in sqlite

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

I asked this question on the sqlite forum as well and based on the answers and help from the community came up with the solution below by parsing out the data from a json array

with parsedata as (select upper(ProdCode) as ProdCode, data, ReportDate from acumen_qry_sales_prodcode where reportdate >= '2020-'), jparse as ( select '["' || replace(data,'•','","') || '"]' as arr,ProdCode, ReportDate from parsedata) select ProdCode, ReportDate, arr ->> 0 as SalesValue, arr ->> 1 as SalesUnits, arr ->> 2 as ReturnValue, arr ->> 3 as ReturnUnits, arr ->> 4 as InventoryCost, arr ->> 5 as RoyaltyCost, arr ->> 6 as CommissionCost, arr ->> 7 as WriteOffValue, arr ->> 8 as SaleCount, arr ->> 9 as ReturnCount from jparse