Skip to content

Instantly share code, notes, and snippets.

@baconcheese113
baconcheese113 / SIM7000_HTTPS_Requests_Bible.md
Last active October 30, 2025 15:18
HTTPS with SIMCOM modems has been a bit of a nightmare, this should help you avoid going through that yourself

"The fear of the AT Command is the beginning of wisdom

and the knowledge of the TLS handshake is understanding."

- Proverbs 9:10

This gist should help you troubleshoot your requests, leave a comment and star if it works (or doesn't) for you and see this thread for more background.

Uploading a certificate to the modem IS NOT REQUIRED TO USE HTTPS unless you're trying to host a domain from the modem

Here's the manual

@awright415
awright415 / graph_preload.ex
Created June 27, 2021 16:23
Recursively Preloading Children from Join Table w/ Elixir & Ecto
# Use a recursive CTE to turn the join table into a (partial) closure table,
# then join all of the child records for the provided parent(s)
query = """
WITH RECURSIVE traversal(depth, parent_id, child_id) AS (
SELECT
1 depth,
parent_id,
child_id
FROM rules_rules
WHERE parent_id = ANY($1)