How to get the result of a sql query in go in parts?

Question

SQL

I'm trying to query a database that returns a lot of data. How can you process them as they are received, let's say 1000 rows each? Allows such standard database/sql?

Answer 1

Allows by default, but not by a thousand rows, but in the form of a cursor that moves with each call to rows.Next(), which you can read more about in the database/sql documentation:
https://golang.org/pkg/database/sql /#Rows
There is also an example that illustrates this:

rows, err := db.Query("SELECT ...")
...
defer rows.Close()
for rows.Next() {
    var id int
    var name string
    err = rows.Scan(&id, &name)
    ...
}
err = rows.Err() // get any error encountered during iteration
...

Only Go has different drivers written for specific databases: https://github.com/golang/go/wiki/SQLDrivers
for example, immediately all in a slice and gives out elements from it one by one.

Answer 2

www.stackoverflow.com/a/9261762/2840001