Simple example of de-duplicating contacts (SQLite)

I must first excuse myself. I haven't been working on Rye for a while. It's not that I forgot about it, far from it, but my regular projects took over for a while. I needed to make major updates at the end of the year at some project, and also re-started a SaaS project for compact support teams that I created in Rebol more than 10 years ago, used ever since, but haven't found time to finalize and offer to others yet.

I was also struck a little by ChatGPT demos, and took some time to familiarize myself with GPT, BERT and similar techologies. This was all Python based, so I had no chance to inject it with Rye.

This period is unfortunately not over yet, but last week I needed to make a simple script on one of the servers, to de-duplicate some data. Users entered the same contacts multiple times and assigned tasks to them.

Script needed to find the duplicates (triplicates, etc.), assign all tasks from the older one to the newer one, and remove the older contact. For the simplicity and debug-ability I made it interactive, using the Rye shell itself ...

It's simple, mostly uses the SQL dialect, which creates prepared SQL statements (no string concatenation) out of pure Rye blocks. Query returns the Rye specific Spreadsheet datatype that I wrote about here not long ago.

Komentarji

Priljubljene objave iz tega spletnega dnevnika

Less variables, more flows example vs Python

In the last blogpost ( Less variables, more flows ) I wrote a quick practical script I needed. It was an uncommon combination of CGI, two GET requests with Cookies and a POST request with Authorization header. I really like practical random/dirty problems, rather than ideal - made up problems to test the language. To get a sense of comparison I rewrote the example 2 times while removing specific Rye features. But that comparison is meaningless to a person that doesn't know Rye or at least Rebol already. So I went on fiverr and made a request for a Python script with these requirements. I got a nicely written Python script that uses functions for each step. To be more comparable, I rewrote the Rye code to a similar structure. Below is the result ... For a next step, it would be interesting, to extract a little simpler example out and add error handling. With Rye-s specific failure handling, I think the difference would become even greater. You can find Rye on github .

Preberite več

Ryelang - controlled file serving example and comparison to Python

This is as anecdotal as it gets, but basic HTTP serving functions in Rye seem to be working quite OK. They do directly use the extremely solid Go 's HTTP functions, so that should be somewhat expected. I made a ryelang.org web-server with few lines of Rye code 3 months ago and the process was running ever since and served more than 30.000 pages. If not else, it seems there are no inherent memory leaks in Rye interpreter. Those would probably show up in a 3 month long running process? And now I got another simple project. I needed to make a HTTP API for some mobile app. API should accept a key, and return / download a binary file in response if the key is correct. Otherwise it should return a HTTP error. So I strapped in and created Rye code below. I think I only needed to add generic methods stat and size? , all other were already implemented, which is a good sign. Of course, we are in an age of ChatGPT, so I used it to generate the equivalent Python code. It used the ele...

Preberite več

Receiving emails with Go's smtpd and Rye

This goes a while back. At some project for user support, we needed to receive emails and save them to appropriate databases. The best option back in the day seemed project Lamson . And it worked well ever since. It was written in Python by then quite known programmer Zed Shaw. It worked like a Python based SMTP server, that called your handlers when emails arrived. It was sort of Ruby on Rails for email. We were using this ever since. Now our system needs to be improved, there are still some emails or attachments that don't get parsed correctly. That isn't the problem of Lamson, but of our code that parses the emails. But Lamson development has been passive for more than 10 years. And I am already moving smaller utilities to Rye. Rye uses Go, and Go has this nice library smtpd , which seems like made for this task. I integrated it and parsemail into Rye and tested it in the Rye console first. Interesting function here is enter-console , that can put you into Rye console any...

Preberite več

ryelang

Preišči ta spletni dnevnik