go-sqlite3 | sqlite3 driver for go using database/sql | Database library

In Go, I'm trying to pass an interface{} to the statement.Exec() function from go-sqlite3. I'm sure this is a solved problem, but I cannot figure it out.

Basically I have a struct with the row data which I want to pass to a function that will insert it to a sqlite db. The thing is I want to be able to programmatically control what goes into the statement.Exec() function

Here is an excerpt:

I'm trying to connect a Go application with postgresql.

The app import postgresql driver:

I've got the TDM-GCC-64 distribution installed, and set to the PATH variable. I still can't install the cgo distribution github.com/mattn/go-sqlite3. I had CygWin installed before I read the most relevant answer to the question (This). However, installing the tdm distrubution has made no difference.

I get the following error on trying to run the application:

I have a SQLite query which returns expected results in the shell. However, when I run the same query in my Go program, no values are scanned.

Here is my query:

I'm writing some Go software that is responsible for downloading and parsing a large number of JSON files and writing that parsed data to a sqlite database. My current design has 10 go routines simultaneously downloading/parsing these JSONs and communicating them to another go routine whose sole job is to listen on a specific channel and write the channel contents to the DB.

The system does some additional read operations after all writing should have been completed, which leads to an issue where queries return incorrect results because not all of the data has been written to the table. Because the JSON data I'm pulling is dynamic, I have no easy way to know when all the data has been written.

I've considered two possibilities for solving this, though I'm not super happy with either solution:

1. Listen on the channel and wait for it to be empty. This should work in principle, however, it does not ensure that the data has been written, all it ensures is it's been received on the channel.
2. Synchronize access to the DB. This again should work in principle, however, I would still need to order the query operation to be after all the write operations.

Are there any other design decisions I should consider to rectify this issue? For reference the libraries I'm using to pull this data are go-colly and the go-sqlite3. Appreciate all the help!

I have this code which works as intended as long as I use sqlite3 driver. When I switch to sqlserver, somehow, the map which clearly contains values returns 0 for each key.

When I clone GoAdminGroup/go-admin projectin github and run the project by the steps of README.MD file , I get this error

I want to use "telegram bot" with "echo framework" (When the server started, echo and telegram bot work together). I used the below code, but when I ran that, the telegram bot didn't start.

My main.go:

I want to use sqlite3 in Golang project. But run it in docker container has some error.Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

this is my build script