Personal Blog about anything - mostly programming, cooking and random thoughts
I'm currently in the same process. I've just retrieved and sent my first webmentions two weeks ago. I really like the way you integrated the mentions into you blog, my implementation is still very basic in that regard.
Micropub is also high on my list, after attending the Homebrew Website Club this week, as I'm still missing a convenient and fast method to create new post. Especially shorter once, like replies to post.
only() and defer() to optimise performance
only has issues with related objects and prefetch_related
User.objects.all().prefetch_related("post_set").only("name", "post_set") will result in an error. Use defer instead to exclude data you don't need.only or defer to a queryset based on the SerializerThis is a pretty common task in frontend; you already have some data (retrieved from an API) and want to offer the same data as a CSV.
The problem: most of the top answers you find on Google and StackOverflow are wrong.
They will break in the presence of , or " in the data.
Additionally all I found are vulnerable to CSV injections.
yourData is the data you want to convert to CSV.data you have to change two things
csvStr will be the finished CSV content. You can use this to construct a download for the user.const yourData = [
{value_a: 12, value_b: "some data"},
{value_a: null, value_b: "no data"},
]
const escape = (str) => {
// handle empty cell
if(str == null || str == '') return '""'
// ensure string
str = `${str}`
// prevent CSV Injection https://owasp.org/www-community/attacks/CSV_Injection
const forbidden = new Set(["=", "+", "-", "@", "\t", "\n", "\r"])
if (forbidden.has(str[0])) {
str = `'${str}`
}
// escape double quotes
str = str.replace(/"/g, '""')
return `"${str}"`
};
const data = [
// header
[
"Header A",
"Header B",
].map(escape),
// body
...yourData.map(
row => [
row["value_a"],
row["value_b"],
].map(escape)
)
]
const csvStr = data.map(x => x.join(",")).join("\n")
console.log(csvStr);
The naive assumption about CSV (comma separated values) is just appending data with commas as separators in between. This works in some special cases, but for general data this scheme will quickly break. When you have data which includes commas it will break your CSV.
In [1, 2, 'hello, world']
CSV 1,2,hello, world
Out [1, 2, 'hello', ' world']
To avoid this quotes are used. Either all or only the values where it is needed are put into quotes. The reader will ignore all commas if they are inside quotes. This way we can represent data that includes commas.
In [1, 2, 'hello, world']
CSV "1","2","3","hello, world"
Out [1, 2, 'hello, world']
But this only shifts the problem. What happens if our quote character is used in our data?
In [1, 2, 'hello", John," what?']
CSV "1","2","3","hello", John," what?"
Out [1, 2, 'hello', ' John', ' what?']
To avoid this an escape character is used.
The escape character is placed in front of every quote char, which is part of the data.
This indicates to the reader that the following quote is part of the data.
The most common format of CSV uses the quotechar itself as the escapechar.
Every " in the data is simply doubled to "".
In [1, 2, 'hello", John", what?']
CSV "1","2","3","hello"", John"", what?"
Out [1, 2, 'hello", John", what?']
The combination of "separator", "quotechar" and "escapechar" allows us to encode arbitrary data as CSV, without breaking the format of our data.
In principle anything can be chosen for these three characters.
One common variation is to use a semicolon (;) as the separator.
If a tab (\t) is used, the files are called "TSV" (Tab separated values).
app:
logging:
options:
max-size: "10m"
max-file: "3"
pubDate to be specified in RFC822. When using the Go time format time.RFC822 , the rss validator will complain. Using time.RFC1123Z (RFC1123 updates RFC822) will yield accepted dates.\o/struct for rss, channel and items.Ctrl+Shift+P for Command Palette (instead of Ctrl+P)Ctrl+P for Open File (instead of Ctrl+O)get_object_or_404:user_comment = get_object_or_404(
self.user.comments,
pk=self.kwargs["comment_pk"],
)
isolatedModules: true reduced the memory consumption, but didn't solve the problem. https://github.com/kulshekhar/ts-jest/issues/1967#issuecomment-1017510990@typescript-eslint/no-floating-promises to find promises which were not awaited.--logHeapUsage showed that each test suite increased the heap size by ~50 MB
node --expose-gc ./node_modules/.bin/jest --runInBand --forceExit --logHeapUsage@swc/jest instead of jest-ts
Ein schneller veganer Auflauf mit Gnocchi und Brokkoli. Kann eingefroren oder backfertig im Kühlschrank gelagert werden, für Tage wenn man keine Lust hat zu kochen.