#fulltext — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #fulltext, aggregated by home.social.
-
"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
-
"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
-
"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
-
"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
-
"Full-Text Search in SQLite: A Practical Guide"
> #FullText Search (FTS) in #SQLite is a powerful feature that enables efficient searching through large amounts of text data. Unlike traditional SQL LIKE queries that perform linear scans, #FTS uses sophisticated indexing techniques to deliver lightning-fast search results with ranking capabilities.
-
"MiniSearch, a client-side full-text search engine"
by @lucaong> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
-
"MiniSearch, a client-side full-text search engine"
by @lucaong> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
-
"MiniSearch, a client-side full-text search engine"
by @lucaong> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
-
"MiniSearch, a client-side full-text search engine "
> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
-
"MiniSearch, a client-side full-text search engine "
> This blog post is to introduce #MiniSearch, a #JavaScript library that provides client-side #FullText #search capabilities. It has zero runtime dependencies, and uses a space optimized index to support memory constrained environments like mobile browsers.
-
Für Anton haben wir ein sehr simples Open Source Paket geschrieben (pure PHP ohne weitere Abhängigkeiten). Nun werden nicht nur PDFs volltextindexiert, sondern auch Office Dokumente: MS- und LibreOffice Dokumente, Tabellen und Präsentationen. Mal sehen wie gut es in der Praxis klappt.
https://github.com/ottosmops/office2text #anton #office #archives #fulltext -
Für Anton haben wir ein sehr simples Open Source Paket geschrieben (pure PHP ohne weitere Abhängigkeiten). Nun werden nicht nur PDFs volltextindexiert, sondern auch Office Dokumente: MS- und LibreOffice Dokumente, Tabellen und Präsentationen. Mal sehen wie gut es in der Praxis klappt.
https://github.com/ottosmops/office2text #anton #office #archives #fulltext -
Für Anton haben wir ein sehr simples Open Source Paket geschrieben (pure PHP ohne weitere Abhängigkeiten). Nun werden nicht nur PDFs volltextindexiert, sondern auch Office Dokumente: MS- und LibreOffice Dokumente, Tabellen und Präsentationen. Mal sehen wie gut es in der Praxis klappt.
https://github.com/ottosmops/office2text #anton #office #archives #fulltext -
Für Anton haben wir ein sehr simples Open Source Paket geschrieben (pure PHP ohne weitere Abhängigkeiten). Nun werden nicht nur PDFs volltextindexiert, sondern auch Office Dokumente: MS- und LibreOffice Dokumente, Tabellen und Präsentationen. Mal sehen wie gut es in der Praxis klappt.
https://github.com/ottosmops/office2text #anton #office #archives #fulltext -
Быстрый алгоритм fulltext-поиска без токенизации
Меня зовут Дмитрий Ольшанский, я ведущий инженер Т-Банка. Расскажу о новом (насколько мне известно) алгоритме поиска текста по шаблону. Такая задача возникла в рамках проекта Sage — observability-платформы от Т-Банка, для которой мы строим новый бэкэнд для структурированных логов, SageDB.
-
Быстрый алгоритм fulltext-поиска без токенизации
Меня зовут Дмитрий Ольшанский, я ведущий инженер Т-Банка. Расскажу о новом (насколько мне известно) алгоритме поиска текста по шаблону. Такая задача возникла в рамках проекта Sage — observability-платформы от Т-Банка, для которой мы строим новый бэкэнд для структурированных логов, SageDB.
-
Быстрый алгоритм fulltext-поиска без токенизации
Меня зовут Дмитрий Ольшанский, я ведущий инженер Т-Банка. Расскажу о новом (насколько мне известно) алгоритме поиска текста по шаблону. Такая задача возникла в рамках проекта Sage — observability-платформы от Т-Банка, для которой мы строим новый бэкэнд для структурированных логов, SageDB.
-
Быстрый алгоритм fulltext-поиска без токенизации
Меня зовут Дмитрий Ольшанский, я ведущий инженер Т-Банка. Расскажу о новом (насколько мне известно) алгоритме поиска текста по шаблону. Такая задача возникла в рамках проекта Sage — observability-платформы от Т-Банка, для которой мы строим новый бэкэнд для структурированных логов, SageDB.
-
Extension for full-text browser history search
https://rearview-ai.vercel.app/
#HackerNews #Extension #fulltext #browser #history #search #RearviewAI #productivity
-
Extension for full-text browser history search
https://rearview-ai.vercel.app/
#HackerNews #Extension #fulltext #browser #history #search #RearviewAI #productivity
-
Extension for full-text browser history search
https://rearview-ai.vercel.app/
#HackerNews #Extension #fulltext #browser #history #search #RearviewAI #productivity
-
Extension for full-text browser history search
https://rearview-ai.vercel.app/
#HackerNews #Extension #fulltext #browser #history #search #RearviewAI #productivity
-
A Sense of Doubt blog post #3707 - SoD Reprint of #1780 - "God is an Iron" by Spider Robinson. https://sensedoubt.blogspot.com/2025/04/a-sense-of-doubt-blog-post-3707-sod.html #Irony #NotAlanisMorrissetteIrony #Ironic #sciencefiction #ShortStory #FullText
-
A Sense of Doubt blog post #3707 - SoD Reprint of #1780 - "God is an Iron" by Spider Robinson. https://sensedoubt.blogspot.com/2025/04/a-sense-of-doubt-blog-post-3707-sod.html #Irony #NotAlanisMorrissetteIrony #Ironic #sciencefiction #ShortStory #FullText
-
- advanced search operators prototype. status: not quite ready for prime time.
- has a bunch of goofy operators nobody but me will ever use, such as
is:article - still missing some classics like
lang:,domain:,before:, andafter:, and some oddballs likeis:bot(would require extra join) andsort:(would break ID-based paging) - needs docs, although i know where Past Vyr basically already wrote them: https://github.com/VyrCossont/mastodon/pull/8 😇
- has a bunch of goofy operators nobody but me will ever use, such as
- indexed full text search prototype. status: heretical.
- only works on PostgreSQL: SQLite's full-text search is much fussier and requires using a "virtual table" and frankly i can't be bothered, at least tonight
- direct port of https://github.com/VyrCossont/mastodon/pull/3 and has the same limitations: HTML isn't stripped, and media alt text and poll options aren't indexed
- fixing that would start by adding a
tsvectorcolumn that concatenates (with record separators? as an array?) the contents offilterableFieldsfor a status, updates it every time the status or its attachments are edited, and GIN-indexes that column - ignores the whole issue of matching posts to language tags and language tags to PG text search configurations by assuming that everything is English
- still massively faster than unindexed
ILIKEthat vanilla GTS uses
edit: fixed a backwards flag in
has:mediaand related operators - advanced search operators prototype. status: not quite ready for prime time.
-
- advanced search operators prototype. status: not quite ready for prime time.
- has a bunch of goofy operators nobody but me will ever use, such as
is:article - still missing some classics like
lang:,domain:,before:, andafter:, and some oddballs likeis:bot(would require extra join) andsort:(would break ID-based paging) - needs docs, although i know where Past Vyr basically already wrote them: https://github.com/VyrCossont/mastodon/pull/8 😇
- has a bunch of goofy operators nobody but me will ever use, such as
- indexed full text search prototype. status: heretical.
- only works on PostgreSQL: SQLite's full-text search is much fussier and requires using a "virtual table" and frankly i can't be bothered, at least tonight
- direct port of https://github.com/VyrCossont/mastodon/pull/3 and has the same limitations: HTML isn't stripped, and media alt text and poll options aren't indexed
- fixing that would start by adding a
tsvectorcolumn that concatenates (with record separators? as an array?) the contents offilterableFieldsfor a status, updates it every time the status or its attachments are edited, and GIN-indexes that column - ignores the whole issue of matching posts to language tags and language tags to PG text search configurations by assuming that everything is English
- still massively faster than unindexed
ILIKEthat vanilla GTS uses
edit: fixed a backwards flag in
has:mediaand related operators - advanced search operators prototype. status: not quite ready for prime time.
-
- advanced search operators prototype. status: not quite ready for prime time.
- has a bunch of goofy operators nobody but me will ever use, such as
is:article - still missing some classics like
lang:,domain:,before:, andafter:, and some oddballs likeis:bot(would require extra join) andsort:(would break ID-based paging) - needs docs, although i know where Past Vyr basically already wrote them: https://github.com/VyrCossont/mastodon/pull/8 😇
- has a bunch of goofy operators nobody but me will ever use, such as
- indexed full text search prototype. status: heretical.
- only works on PostgreSQL: SQLite's full-text search is much fussier and requires using a "virtual table" and frankly i can't be bothered, at least tonight
- direct port of https://github.com/VyrCossont/mastodon/pull/3 and has the same limitations: HTML isn't stripped, and media alt text and poll options aren't indexed
- fixing that would start by adding a
tsvectorcolumn that concatenates (with record separators? as an array?) the contents offilterableFieldsfor a status, updates it every time the status or its attachments are edited, and GIN-indexes that column - ignores the whole issue of matching posts to language tags and language tags to PG text search configurations by assuming that everything is English
- still massively faster than unindexed
ILIKEthat vanilla GTS uses
edit: fixed a backwards flag in
has:mediaand related operators - advanced search operators prototype. status: not quite ready for prime time.
-
- advanced search operators prototype. status: not quite ready for prime time.
- has a bunch of goofy operators nobody but me will ever use, such as
is:article - still missing some classics like
lang:,domain:,before:, andafter:, and some oddballs likeis:bot(would require extra join) andsort:(would break ID-based paging) - needs docs, although i know where Past Vyr basically already wrote them: https://github.com/VyrCossont/mastodon/pull/8 😇
- has a bunch of goofy operators nobody but me will ever use, such as
- indexed full text search prototype. status: heretical.
- only works on PostgreSQL: SQLite's full-text search is much fussier and requires using a "virtual table" and frankly i can't be bothered, at least tonight
- direct port of https://github.com/VyrCossont/mastodon/pull/3 and has the same limitations: HTML isn't stripped, and media alt text and poll options aren't indexed
- fixing that would start by adding a
tsvectorcolumn that concatenates (with record separators? as an array?) the contents offilterableFieldsfor a status, updates it every time the status or its attachments are edited, and GIN-indexes that column - ignores the whole issue of matching posts to language tags and language tags to PG text search configurations by assuming that everything is English
- still massively faster than unindexed
ILIKEthat vanilla GTS uses
edit: fixed a backwards flag in
has:mediaand related operators - advanced search operators prototype. status: not quite ready for prime time.
-
ok, here you go, updated GTS search patches for 0.18.0rc1. notice how they're on my repo? these are completely unofficial. do not bug anyone but me about them.
- improved hashtag search. status: upstreamable, mostly.
- doesn't require # prefix to search hashtags
- searches for matches anywhere in a hashtag:
Macnow matchesVintageMacas well asMacOS - includes hashtags when not specifically searching for accounts or statuses, like most Mastodon-compatibles
- doesn't change existing tag sorting. popularity and/or recency might be more useful
- offset paging for searches. status: not upstreamable yet.
- more compatible: many clients can't do ID paging
- allows paging hashtag search results: Mastodon API has no concept of IDs for hashtags, so ID paging can't work for those anyway
- possible performance issues: see comments on why
maindoesn't have it already. personally, i haven't noticed and i run this instance on a tiny VPS
- remove search restrictions. status: heretical.
- searches any post on your instance (except other accounts' private/direct posts, and accounts that have you blocked)
- includes public, unlisted, your own private and DM posts, and private and DM posts that are replies to you
- expanded search is default: revert to standard GTS behavior by adding
scope:classicorin:libraryoperator to search query - definite performance issues: this means searching more posts! GTS does not use either PG full-text indexes/operators or SQLite full-text virtual tables, and this patch doesn't change that.
- doesn't include alt text of media attachments, or polls, because
maindoesn't
i may add more patches to this list in the medium future as i add more functionality to my own instance, for example, date range operators (
before:date,after:date), post property operators (has:image,has:poll,has:cw,is:sensitive,visibility:public), threading operators (to:[email protected],is:reply,-is:reply), sort operators (sort:oldest,sort:newest,sort:favs) and maybe PG full-text indexing if i have a really good day (i really don't wanna figure out SQLite's weird shit! someone else do it!)randos don't debate me about Fedi search. my clients can't set per-post interaction controls yet so i'll just block you.
- improved hashtag search. status: upstreamable, mostly.
-
ok, here you go, updated GTS search patches for 0.18.0rc1. notice how they're on my repo? these are completely unofficial. do not bug anyone but me about them.
- improved hashtag search. status: upstreamable, mostly.
- doesn't require # prefix to search hashtags
- searches for matches anywhere in a hashtag:
Macnow matchesVintageMacas well asMacOS - includes hashtags when not specifically searching for accounts or statuses, like most Mastodon-compatibles
- doesn't change existing tag sorting. popularity and/or recency might be more useful
- offset paging for searches. status: not upstreamable yet.
- more compatible: many clients can't do ID paging
- allows paging hashtag search results: Mastodon API has no concept of IDs for hashtags, so ID paging can't work for those anyway
- possible performance issues: see comments on why
maindoesn't have it already. personally, i haven't noticed and i run this instance on a tiny VPS
- remove search restrictions. status: heretical.
- searches any post on your instance (except other accounts' private/direct posts, and accounts that have you blocked)
- includes public, unlisted, your own private and DM posts, and private and DM posts that are replies to you
- expanded search is default: revert to standard GTS behavior by adding
scope:classicorin:libraryoperator to search query - definite performance issues: this means searching more posts! GTS does not use either PG full-text indexes/operators or SQLite full-text virtual tables, and this patch doesn't change that.
- doesn't include alt text of media attachments, or polls, because
maindoesn't
i may add more patches to this list in the medium future as i add more functionality to my own instance, for example, date range operators (
before:date,after:date), post property operators (has:image,has:poll,has:cw,is:sensitive,visibility:public), threading operators (to:[email protected],is:reply,-is:reply), sort operators (sort:oldest,sort:newest,sort:favs) and maybe PG full-text indexing if i have a really good day (i really don't wanna figure out SQLite's weird shit! someone else do it!)randos don't debate me about Fedi search. my clients can't set per-post interaction controls yet so i'll just block you.
- improved hashtag search. status: upstreamable, mostly.
-
ok, here you go, updated GTS search patches for 0.18.0rc1. notice how they're on my repo? these are completely unofficial. do not bug anyone but me about them.
- improved hashtag search. status: upstreamable, mostly.
- doesn't require # prefix to search hashtags
- searches for matches anywhere in a hashtag:
Macnow matchesVintageMacas well asMacOS - includes hashtags when not specifically searching for accounts or statuses, like most Mastodon-compatibles
- doesn't change existing tag sorting. popularity and/or recency might be more useful
- offset paging for searches. status: not upstreamable yet.
- more compatible: many clients can't do ID paging
- allows paging hashtag search results: Mastodon API has no concept of IDs for hashtags, so ID paging can't work for those anyway
- possible performance issues: see comments on why
maindoesn't have it already. personally, i haven't noticed and i run this instance on a tiny VPS
- remove search restrictions. status: heretical.
- searches any post on your instance (except other accounts' private/direct posts, and accounts that have you blocked)
- includes public, unlisted, your own private and DM posts, and private and DM posts that are replies to you
- expanded search is default: revert to standard GTS behavior by adding
scope:classicorin:libraryoperator to search query - definite performance issues: this means searching more posts! GTS does not use either PG full-text indexes/operators or SQLite full-text virtual tables, and this patch doesn't change that.
- doesn't include alt text of media attachments, or polls, because
maindoesn't
i may add more patches to this list in the medium future as i add more functionality to my own instance, for example, date range operators (
before:date,after:date), post property operators (has:image,has:poll,has:cw,is:sensitive,visibility:public), threading operators (to:[email protected],is:reply,-is:reply), sort operators (sort:oldest,sort:newest,sort:favs) and maybe PG full-text indexing if i have a really good day (i really don't wanna figure out SQLite's weird shit! someone else do it!)randos don't debate me about Fedi search. my clients can't set per-post interaction controls yet so i'll just block you.
- improved hashtag search. status: upstreamable, mostly.
-
ok, here you go, updated GTS search patches for 0.18.0rc1. notice how they're on my repo? these are completely unofficial. do not bug anyone but me about them.
- improved hashtag search. status: upstreamable, mostly.
- doesn't require # prefix to search hashtags
- searches for matches anywhere in a hashtag:
Macnow matchesVintageMacas well asMacOS - includes hashtags when not specifically searching for accounts or statuses, like most Mastodon-compatibles
- doesn't change existing tag sorting. popularity and/or recency might be more useful
- offset paging for searches. status: not upstreamable yet.
- more compatible: many clients can't do ID paging
- allows paging hashtag search results: Mastodon API has no concept of IDs for hashtags, so ID paging can't work for those anyway
- possible performance issues: see comments on why
maindoesn't have it already. personally, i haven't noticed and i run this instance on a tiny VPS
- remove search restrictions. status: heretical.
- searches any post on your instance (except other accounts' private/direct posts, and accounts that have you blocked)
- includes public, unlisted, your own private and DM posts, and private and DM posts that are replies to you
- expanded search is default: revert to standard GTS behavior by adding
scope:classicorin:libraryoperator to search query - definite performance issues: this means searching more posts! GTS does not use either PG full-text indexes/operators or SQLite full-text virtual tables, and this patch doesn't change that.
- doesn't include alt text of media attachments, or polls, because
maindoesn't
i may add more patches to this list in the medium future as i add more functionality to my own instance, for example, date range operators (
before:date,after:date), post property operators (has:image,has:poll,has:cw,is:sensitive,visibility:public), threading operators (to:[email protected],is:reply,-is:reply), sort operators (sort:oldest,sort:newest,sort:favs) and maybe PG full-text indexing if i have a really good day (i really don't wanna figure out SQLite's weird shit! someone else do it!)randos don't debate me about Fedi search. my clients can't set per-post interaction controls yet so i'll just block you.
- improved hashtag search. status: upstreamable, mostly.
-
Nouveau is the new #fulltext search for @couchdb that makes fuzzy search, facets, counts, and ranges even more flexible.
In our latest guide, we show you how to install, set up, and use Nouveau to find, well, all the things!
We also cover disk usage and performance. You’ll love how much faster it is 🐇
Check it out on our blog: https://neighbourhood.ie/blog/2024/10/24/first-steps-with-nouveau
-
Nouveau is the new #fulltext search for @couchdb that makes fuzzy search, facets, counts, and ranges even more flexible.
In our latest guide, we show you how to install, set up, and use Nouveau to find, well, all the things!
We also cover disk usage and performance. You’ll love how much faster it is 🐇
Check it out on our blog: https://neighbourhood.ie/blog/2024/10/24/first-steps-with-nouveau
-
Nouveau is the new #fulltext search for @couchdb that makes fuzzy search, facets, counts, and ranges even more flexible.
In our latest guide, we show you how to install, set up, and use Nouveau to find, well, all the things!
We also cover disk usage and performance. You’ll love how much faster it is 🐇
Check it out on our blog: https://neighbourhood.ie/blog/2024/10/24/first-steps-with-nouveau
-
Nouveau is the new #fulltext search for @couchdb that makes fuzzy search, facets, counts, and ranges even more flexible.
In our latest guide, we show you how to install, set up, and use Nouveau to find, well, all the things!
We also cover disk usage and performance. You’ll love how much faster it is 🐇
Check it out on our blog: https://neighbourhood.ie/blog/2024/10/24/first-steps-with-nouveau
-
Nouveau is the new #fulltext search for @couchdb that makes fuzzy search, facets, counts, and ranges even more flexible.
In our latest guide, we show you how to install, set up, and use Nouveau to find, well, all the things!
We also cover disk usage and performance. You’ll love how much faster it is 🐇
Check it out on our blog: https://neighbourhood.ie/blog/2024/10/24/first-steps-with-nouveau
-
Wouldn't it be nice if pdf files could contain unhyphenated words even when the word is hypenated? leader-<newline>ship vs. leaderhip as an example.
Regardless, I praise OCR (Optical character recognition) which makes photocopied pages searchable, or if the text is not OCR'd yet are not you can run the #OCR and make PDF searchable! Several online tools, and several #MacOS commandline tools via #Homebrew, too.
-
Wouldn't it be nice if pdf files could contain unhyphenated words even when the word is hypenated? leader-<newline>ship vs. leaderhip as an example.
Regardless, I praise OCR (Optical character recognition) which makes photocopied pages searchable, or if the text is not OCR'd yet are not you can run the #OCR and make PDF searchable! Several online tools, and several #MacOS commandline tools via #Homebrew, too.
-
Wouldn't it be nice if pdf files could contain unhyphenated words even when the word is hypenated? leader-<newline>ship vs. leaderhip as an example.
Regardless, I praise OCR (Optical character recognition) which makes photocopied pages searchable, or if the text is not OCR'd yet are not you can run the #OCR and make PDF searchable! Several online tools, and several #MacOS commandline tools via #Homebrew, too.
-
Wouldn't it be nice if pdf files could contain unhyphenated words even when the word is hypenated? leader-<newline>ship vs. leaderhip as an example.
Regardless, I praise OCR (Optical character recognition) which makes photocopied pages searchable, or if the text is not OCR'd yet are not you can run the #OCR and make PDF searchable! Several online tools, and several #MacOS commandline tools via #Homebrew, too.
-
Wouldn't it be nice if pdf files could contain unhyphenated words even when the word is hypenated? leader-<newline>ship vs. leaderhip as an example.
Regardless, I praise OCR (Optical character recognition) which makes photocopied pages searchable, or if the text is not OCR'd yet are not you can run the #OCR and make PDF searchable! Several online tools, and several #MacOS commandline tools via #Homebrew, too.
