I want to use hugo to render content from a different data source than textfiles. To be more concrete, i have existing entries in a sqlite database which i want to render with hugo. Is there a way (with a plugin?) to accomplish this and are there maybe examples already out there?

Currently, you would have to dump it to an intermediary format (CSV, JSON …), then read that. And the “dump operation” would have to be scripted outside of Hugo.

I’ve recently been experimenting with data and different formats for a current project. I don’t know how you would directly bring in Sqlite, but I decided to work with CSV files using the getCSV function. if data conversion before Hugo is an option, you could convert each Sqllite table to csv file.…

thanks for the replies. i want to use an existing book database (which has a few thousand entries in an sqlite db) and display content such as title, image, description with hugo. regarding the getcsv function: where are you using this exactly? can you maybe post a code snippet? i basically though…

The getCSV function works in a range. I copied (almost verbatim) code from here which loops through the CSV file. An example is {{ range $key, value := getCSV $seperator $filepath }}, but better to find the info I used originally (which I guess was here or I googled it). About this: [image] foo…

Content from different data source (database, sqlite)

support

Topic		Replies	Views
How to make content pages from JSON or DB? feature	3	2852	May 16, 2020
How to access data from database? support	8	10229	February 11, 2015
Generate from mysql data to Hugo support	4	2014	October 6, 2019
MySQl Data access from hugo templates support	1	645	January 21, 2021
Integrate hugo templates with Mysql database data feature	3	3141	January 21, 2021

Content from different data source (database, sqlite)

Related topics