- May 2023
-
-
Discussing the documentary system of surveillance, Foucault points toa “partly official, partly secret hierarchy” in Paris that had been using a card index to managedata on suspects and criminals at least since 1833.
source apparently from: “Apparition de la fiche et constitution des sciences humaines: encore une invention que les historiens célèbrent peu.” Michel Foucault, Surveillir et punir. Naissance de la prison (Paris: Gallimard, 1975), 287, referring to A. Bonneville, De la recidive (Paris, 1844), 92–93.
-
-
www.reddit.com www.reddit.com
-
Note taking can also be done to create a database (a la Beatrice Webb's scientific note taking).
-
- Apr 2023
-
-
Memindex Phondex Office Phone Number Organizer Styrene NOS
Memindex, Inc. of Rochester, NY manufactured a plastic "Phonedex" in the mid-20th century. It was made of Dow Chemical Styrene and sat underneath a standard rotary dial telephone and contained index cards with one's lists of phone numbers on them.
-
- Mar 2023
-
www.icoderzsolutions.com www.icoderzsolutions.com
-
AWS offers a range of database services, including relational databases, NoSQL databases, and in-memory databases. Each service has its unique features, capabilities, and pricing structures. In this blog, We will discuss the benefits and drawbacks of each database option and guide how to choose the right one for your business.
-
-
www.youtube.com www.youtube.com
-
Basic statistics regarding the TLL: - ancient Latin vocabulary words: ca. 55,000 words - 10,000,000 slips - ca. 6,500 boxes - ca. 1,500 slips per box - library 32,000 volumes - contributors: 375 scholars from 20 different countries - 12 Indo-European specalists - 8 Romance specialists - 100 proof-readers - ca. 44,000 words published - published content: 70% of the entire vocabulary - print run: 1,350 - Publisher: consortium of 35 academies from 27 countries on 5 continents
Longest remaining words: - non / 37 boxes of ca 55,500 slips - qui, quae, quod / 65 boxes of ca. 96,000 slips - sum, esse, fui / 54.5 boxes of ca. 81,750 slips - ut / 35 boxes of ca 52,500 slips
Note that some of these words have individual zettelkasten for themselves approaching the size of some of the largest personal collections we know about!
[18:51]
-
-
aaew.bbaw.de aaew.bbaw.de
-
en.wikipedia.org en.wikipedia.org
-
The Wörterbuch der ägyptischen Sprache was an international collaborative zettelkasten project begun in 1897 and finally published as five volumes in 1926.
https://en.wikipedia.org/wiki/W%C3%B6rterbuch_der_%C3%A4gyptischen_Sprache
-
-
web.archive.org web.archive.org
-
Ausgangspunkt und Zentrum der Arbeit am Altägyptischen Wörterbuch ist die Anlage eines erschöpfenden Corpus ägyptischer Texte.
In the early twentieth century one might have created a card index to study a large textual corpus, but in the twenty first one is more likely to rely on a relational database instead.
-
-
www.oldhatrecords.com www.oldhatrecords.com
-
I love the fact that the image for "Research & History" here is a six drawer card index!
-
- Feb 2023
-
Local file Local file
-
Lustig, Jason. “‘Mere Chips from His Workshop’: Gotthard Deutsch’s Monumental Card Index of Jewish History.” History of the Human Sciences, vol. 32, no. 3, July 2019, pp. 49–75. SAGE Journals, https://doi.org/10.1177/0952695119830900
Cross reference preliminary notes from https://journals.sagepub.com/doi/abs/10.1177/0952695119830900
Finished reading 2023-02-21 13:04:00
urn:x-pdf:6053dd751da0fa870cad9a71a28882ba
-
-
guides.rubyonrails.org guides.rubyonrails.org
-
If you already have an instance of your model, you can start a transaction and acquire the lock in one go using the following code: book = Book.first book.with_lock do # This block is called within a transaction, # book is already locked. book.increment!(:views) end
-
-
www.martinfowler.com www.martinfowler.com
-
As our needs become more sophisticated we steadily move away from that model. We may want to look at the information in a different way to the record store, perhaps collapsing multiple records into one, or forming virtual records by combining information for different places. On the update side we may find validation rules that only allow certain combinations of data to be stored, or may even infer data to be stored that's different from that we provide.
Tags
Annotators
URL
-
- Jan 2023
-
Local file Local file
-
Since 2015 a digitalized card index of Greek functionwords in Coptic is available online (as part of the DDGCL)
A digitized version of Gertrud Bauer's zettelkasten has been available online since 2015.
-
-
refubium.fu-berlin.de refubium.fu-berlin.de
-
https://refubium.fu-berlin.de/handle/fub188/24570
Some interesting programming and structured data with relationship to the Gertrud Bauer Zettelkasten Online.
-
-
Local file Local file
-
Richter, Tonio Sebastian. “Whatever in the Coptic Language Is Not Greek, Can Wholly Be Considered Ancient Egyptian”: Recent Approaches towards an Integrated View of the Egyptian-Coptic Lexicon.” Journal of the Canadian Society for Coptic Studies. Journal de La Société Canadienne Pour Les Études Coptes 9 (2017): 9–32. https://doi.org/10.11588/propylaeumdok.00004673.
Skimmed for the specifics I was looking for with respect to Gertrud Bauer's zettelkasten.
-
Tami Gottschalk,
As a complete aside I can't help but wonder if Tami Gottschalk is related to Louis R. Gottschalk, the historian who wrote Understanding history; a primer of historical method?
-
The DDGLC data are not accessible online as of yet. A migration of the database and the data into aMySQL target system is underway and will allow us to offer an online user interface by the end of 2017 Whatwe can already offer now is a by-product of our work, the Gertrud Bauer Zettelkasten Online.6'
61 Available online at http://research.uni-leipzig.de/ddglc/bauerindex.html. The Work on this parergon to the lexicographical labors of the DDGLC project was funded by the Gertrud-und Alexander Böhlig-Stiftung. The digitization of the original card index was conducted by temporary collaborators and volunteers in the DDGLC project: Jenny Böttinger, Claudia Gamma, Tami Gottschalk, Josephine Hensel, Katrin John, Mariana Jung, Christina Katsikadeli, and Elen Saif. The IT concept and programming were carried out by Katrin John and Maximilian Moller.
Digitization of Gertrud Bauer's zettelkasten was underway in 2017 to put the data into a MySQL database with the intention of offering it as an online user interface sometime in 2017.
Tags
- Tonio Sebastian Richter
- MySQL
- Gertrud Bauer's zettelkasten
- Gertrud Bauer Zettelkasten Online
- Louis R. Gottschalk
- loanwords
- relationships
- references
- historical method
- Tami Gottschalk
- Greek
- Coptic
- open questions
- Database and Dictionary of Greek Loanwords in Coptic (DDGLC)
- zettelkasten as database
Annotators
-
-
userpage.fu-berlin.de userpage.fu-berlin.de
-
After browsing through a variety of the cards in Gertrud Bauer's Zettelkasten Online it becomes obvious that the collection was created specifically as a paper-based database for search, retrieval, and research. The examples and data within it are much more narrowly circumscribed for a specific use than those of other researchers like Niklas Luhmann whose collection spanned a much broader variety of topics and areas of knowledge.
This particular use case makes the database nature of zettelkasten more apparent than some others, particularly in modern (post-2013 zettelkasten of a more personal nature).
I'm reminded here of the use case(s) described by Beatrice Webb in My Apprenticeship for scientific note taking, by which she more broadly meant database creation and use.
-
-
www.geschkult.fu-berlin.de www.geschkult.fu-berlin.de
-
In summer 2010, Professor Peter Nagel of Bonn forwarded seven cardboard boxes full of lexicographical slips to the DDGLC office, which had been handed over to him in the early '90s by the late Professor Alexander Böhlig.
In the 1990s Professor Alexander Böhlig of the University of Tuebingen gave Gertrud Bauer's zettelkasten to Professor Peter Nagel of Bonn. He in turn forwardd the seven cardboard boxes of slips to the Database and Dictionary of Greek Loanwords in Coptic (DDGLC) office for their use.
-
The original slips have been scanned and slotted into a database replicating the hierarchical structure of the original compilation. It is our pleasure to provide a new lexicographical tool to our colleagues in Coptology, Classical Studies, and Linguistics, and other interested parties.
The Database and Dictionary of Greek Loanwords in Coptic (DDGLC) has scanned and placed the original slips from Gertrud Bauer's zettelkasten into a database for scholarly use. The database allows the replication of the hierarchical structure of Bauer's original compilation.
-
-
Local file Local file
-
Until the development of new digital tools, Goitein’s index cards providedthe most extensive database for the study of the documentary Geniza.
Goitein's index cards provided a database not only for his own work, but for those who studied documentary Geniza after him.
-
- Dec 2022
-
genizalab.princeton.edu genizalab.princeton.edu
-
Goitein accumulated more than 27,000 index cards in his research work over the span of 35 years. (Approximately 2.1 cards per day.)
His collection can broadly be broken up into two broad categories: 1. Approximately 20,000 cards are notes covering individual topics generally making of the form of a commonplace book using index cards rather than books or notebooks. 2. Over 7,000 cards which contain descriptions of a single fragment from the Cairo Geniza.
A large number of cards in the commonplace book section were used in the production of his magnum opus, a six volume series about aspects of Jewish life in the Middle Ages, which were published as A Mediterranean Society: The Jewish communities of the Arab World as Portrayed in the Documents of the Cairo Geniza (1967–1993).
-
https://genizalab.princeton.edu/resources/goiteins-index-cards
<small><cite class='h-cite via'>ᔥ <span class='p-author h-card'>u/Didactico</span> in Goitein's Index Cards : antinet (<time class='dt-published'>12/15/2022 23:12:33</time>)</cite></small>
-
-
www.codecademy.com www.codecademy.com
-
Postgres itself is a database “server.” There are several ways to connect to Postgres via “clients,” including GUIs, CLIs, and programming languages often via ORMs
-
- Nov 2022
-
discourse.devontechnologies.com discourse.devontechnologies.com
-
I work primarily on Windows, but I support my kids who primarily use Mac for their college education. I have used DT on Mac, IPOS, IOS for about a year. On Windows, I have been using Kinook’s UltraRecall (UR) for the past 15 years. It is both a knowledge outliner and document manager. Built on top of a sql lite database. You can use just life DT and way way more. Of course, there is no mobile companion for UR. The MS Windows echo system in this regard is at least 12 years behind.
Reference for UltraRecall (UR) being the most DEVONthink like Windows alternative. No mobile companion for UR. Look into this being paired with Obsidian
-
- Oct 2022
-
natto.dev natto.dev
-
Natto https://natto.dev<br /> built by Paul Shen https://twitter.com/_paulshen
-
-
www.loom.com www.loom.com
-
https://www.loom.com/share/a05f636661cb41628b9cb7061bd749ae
Synopsis: Maggie Delano looks at some of the affordances supplied by Tana (compared to Roam Research) in terms of providing better block-based user interface for note type creation, search, and filtering.
These sorts of tools and programmable note implementations remind me of Beatrice Webb's idea of scientific note taking or using her note cards like a database to sort and search for data to analyze it and create new results and insight.
It would seem that many of these note taking tools like Roam and Tana are using blocks and sub blocks as a means of defining atomic notes or database-like data in a way in which sub-blocks are linked to or "filed underneath" their parent blocks. In reality it would seem that they're still using a broadly defined index card type system as used in the late 1800s/early 1900s to implement a set up that otherwise would be a traditional database in the Microsoft Excel or MySQL sort of fashion, the major difference being that the user interface is cognitively easier to understand for most people.
These allow people to take a form of structured textual notes to which might be attached other smaller data or meta data chunks that can be easily searched, sorted, and filtered to allow for quicker or easier use.
Ostensibly from a mathematical (or set theoretic and even topological) point of view there should be a variety of one-to-one and onto relationships (some might even extend these to "links") between these sorts of notes and database representations such that one should be able to implement their note taking system in Excel or MySQL and do all of these sorts of things.
Cascading Idea Sheets or Cascading Idea Relationships
One might analogize these sorts of note taking interfaces to Cascading Style Sheets (CSS). While there is the perennial question about whether or not CSS is a programming language, if we presume that it is (and it is), then we can apply the same sorts of class, id, and inheritance structures to our notes and their meta data. Thus one could have an incredibly atomic word, phrase, or even number(s) which inherits a set of semantic relationships to those ideas which it sits below. These links and relationships then more clearly define and contextualize them with respect to other similar ideas that may be situated outside of or adjacent to them. Once one has done this then there is a variety of Boolean operations which might be applied to various similar sets and classes of ideas.
If one wanted to go an additional level of abstraction further, then one could apply the ideas of category theory to one's notes to generate new ideas and structures. This may allow using abstractions in one field of academic research to others much further afield.
The user interface then becomes the key differentiator when bringing these ideas to the masses. Developers and designers should be endeavoring to allow the power of complex searches, sorts, and filtering while minimizing the sorts of advanced search queries that an average person would be expected to execute for themselves while also allowing some reasonable flexibility in the sorts of ways that users might (most easily for them) add data and meta data to their ideas.
Jupyter programmable notebooks are of this sort, but do they have the same sort of hierarchical "card" type (or atomic note type) implementation?
Tags
- CSS
- card index as database
- Maggie Delano
- Boolean algebra
- Tana
- Roam Research
- category theory
- building blocks
- programmable notes
- watch
- Jupyter
- user interface
- integrated development environment
- super tags
- integrated thinking environments
- types of notes
- scientific note taking
- cascading idea sheets
- idea links
- Beatrice Webb
Annotators
URL
-
-
journals.sagepub.com journals.sagepub.com
-
Gotthard Deutsch (1859–1921) taught at Hebrew Union College in Cincinnati from 1891 until his death, where he produced a card index of 70,000 ‘facts’ of Jewish history.
Gotthard Deutsch (1859-1921) had a card index of 70,000 items relating to Jewish history.
-
-
archive.org archive.org
-
There is a difference between various modes of note taking and their ultimate outcomes. Some is done for learning about an area and absorbing it into one's own source of general knowledge. Others are done to collect and generate new sorts of knowledge. But some may be done for raw data collection and analysis. Beatrice Webb called this "scientific note taking".
Historian Jacques Goutor talks about research preparation for this sort of data collecting and analysis though he doesn't give it a particular name. He recommends reading papers in related areas to prepare for the sort of data acquisition one may likely require so that one can plan out some of one's needs in advance. This will allow the researcher, especially in areas like history or sociology, the ability to preplan some of the sorts of data and notes they'll need to take from their historical sources or subjects in order to carry out their planned goals. (p8)
C. Wright Mills mentions (On Intellectual Craftsmanship, 1952) similar research planning whereby he writes out potential longer research methods even when he is not able to spend the time, effort, energy, or other (financial) resources to carry out such plans. He felt that just the thought experiments and exercise of doing such unfulfilled research often bore fruit in his other sociological endeavors.
-
- Sep 2022
-
-
Google Forms and Sheets allow users toannotate using customizable tools. Google Forms offers a graphicorganizer that can prompt student-determined categorical input andthen feeds the information into a Sheets database. Sheetsdatabases are taggable, shareable, and exportable to other software,such as Overleaf (London, UK) for writing and Python for coding.The result is a flexible, dynamic knowledge base with many learningapplications for individual and group work
Who is using these forms in practice? I'd love to see some examples.
This sort of set up could be used with some outlining functionality to streamline the content creation end of common note taking practices.
Is anyone using a spreadsheet program (Excel, Google Sheets) as the basis for their zettelkasten?
Link to examples of zettelkasten as database (Webb, Seignobos suggestions)
-
-
Local file Local file
-
arranged according to their subject-matter ;" that" epigraphic monuments belonging to the sameterritory mutually explain each other when placedside by side ;" and, lastly, that " while it is all butimpossible to range in order of subject-matter ahundred thousand inscriptions nearly all of whichbelong to several categories ; on the other hand,each monument has but one place, and a verydefinite place, in the geographical order."
Similar to the examples provided by Beatrice Webb in My Apprenticeship, the authors here are talking about a sort of scientific note taking method that is ostensibly similar to that of the use of a modern day computer database or spreadsheet function, but which had to be effected in index card form to do the sorting and compiling and analysis.
Do the authors here use the specific phrase scientific note taking? It appears that they do not.
-
the method of slips is the only one mechanicallypossible for the purpose of forming, classifying, andutiUsing a collection of documents of any greatextent. Statisticians, financiers, and men of letterswho observe, have now discovered this as well asscholars.
Moreover
A zettelkasten type note taking method isn't only popular and useful for scholars by 1898, but is useful to "statisticians, financiers, and men of letters".
Note carefully the word "mechanically" here used in a pre-digital context. One can't easily keep large amounts of data in one's head at once to make sense of it, so having a physical and mechanical means of doing so would have been important. In 21st century contexts one would more likely use a spreadsheet or database for these types of manipulations at increasingly larger scales.
-
- Jul 2022
-
Local file Local file
-
It wasnot until we had completely re-sorted all our innumerable sheets ofpaper according to subjects, thus bringing together all the facts relatingto each, whatever the trade concerned, or the place or the date—andhad shuffled and reshuffled these sheets according to various tentativehypotheses—that a clear, comprehensive and verifiable theory of theworking and results of Trade Unionism emerged in our minds; tobe embodied, after further researches by way of verification, in ourIndustrial Democracy (1897).
Beatrice Webb was using her custom note taking system in the lead up to the research that resulted in the publication of Industrial Democracy (1897).
Is there evidence that she was practicing this note taking/database practice earlier than this?
-
- May 2022
-
mongoosejs.com mongoosejs.com
-
Validation
Mongoose Validation. This is essential.
-
- Apr 2022
-
www.nature.com www.nature.com
-
Chawla, D. S. (2021). Hundreds of ‘predatory’ journals indexed on leading scholarly database. Nature. https://doi.org/10.1038/d41586-021-00239-0
-
-
github.com github.com
-
after_commit { puts "We're all done!" }
Notice the order: this is printed last, after the outer (real) transaction is committed, not when the inner "transaction" block finishes without error.
-
-
evilmartians.com evilmartians.com
-
These callbacks are smart enough to run after the final (outer) transaction* is committed. * Usually, there is one real transaction and nested transactions are implemented through savepoints (see, for example, PostgreSQL).
important qualification: the outer transaction, the (only) real transaction
-
-
github.com github.com
-
These callbacks are focused on the transactions, instead of specific model actions.
At least I think this is talking about this as limitation/problem.
The limitation/problem being that it's not good/useful for performing after-transaction code only for specific actions.
But the next sentence "This is beneficial..." seems contradictory, so I'm a bit confused/unclear of what the intention is...
Looking at this project more, it doesn't appear to solve the "after-transaction code only for specific actions" problem like I initially thought it did (and like https://github.com/grosser/ar_after_transaction does), so I believe I was mistaken. Still not sure what is meant by "instead of specific model actions". Are they claiming that "before_commit_on_create" for example is a "specific model action"? (hardly!) That seems almost identical to the (not specific enough) callbacks provided natively by Rails. Oh yeah, I guess they do point out that Rails 3 adds this functionality, so this gem is only needed for Rails 2.
-
-
rails-bestpractices.com rails-bestpractices.com
-
In this case, the worker process query the newly-created notification before main process commits the transaction, it will raise NotFoundError, because transaction in worker process can't read uncommitted notification from transaction in main process.
-
-
stackoverflow.com stackoverflow.com
-
Generates the following sql in sqlite3: "SELECT \"patients\".* FROM \"patients\" INNER JOIN \"users\" ON \"users\".\"id\" = \"patients\".\"user_id\" WHERE (\"users\".\"name\" LIKE '%query%')" And the following sql in postgres (notice the ILIKE): "SELECT \"patients\".* FROM \"patients\" INNER JOIN \"users\" ON \"users\".\"id\" = \"patients\".\"user_id\" WHERE (\"users\".\"name\" ILIKE '%query%')" This allows you to join with simplicity, but still get the abstraction of the ARel matcher to your RDBMS.
-
- Mar 2022
-
-
Data integrity is a good thing. Constraining the values allowed by your application at the database-level, rather than at the application-level, is a more robust way of ensuring your data stays sane.
-
-
-
-
# Optionally, you can write a description for the migration, which you can use for # documentation and changelogs. describe 'The _id suffix has been removed from the author property in the Articles API.'
-
-
rom-rb.org rom-rb.org
-
Object hierarchies are very different from relational hierarchies. Relational hierarchies focus on data and its relationships, whereas objects manage not only data, but also their identity and the behavior centered around that data.
-
-
github.com github.com
-
-
If you need to ensure migrations run in a certain order with regular db:migrate, set up Outrigger.ordered. It can be a hash or a proc that takes a tag; either way it needs to return a sortable value: Outrigger.ordered = { predeploy: -1, postdeploy: 1 } This will run predeploys, untagged migrations (implicitly 0), and then postdeploy migrations.
-
-
railsguides.net railsguides.net
-
The code will work without exception but it doesn’t set correct association, because the defined classes are under namespace AddStatusToUser. This is what happens in reality: role = AddStatusToUser::Role.create!(name: 'admin') AddStatusToUser::User.create!(nick: '@ka8725', role: role)
-
-
github.com github.com
-
this gem promotes writing tests for data migrations providing a way allows to write code that migrates data in separate methods.
-
having the code migrates data separately covered by proper tests eliminates those pesky situations with outdated migrations or corrupted data.
-
-
-
-
There are three keys to backfilling safely: batching, throttling, and running it outside a transaction. Use the Rails console or a separate migration with disable_ddl_transaction!.
-
Active Record creates a transaction around each migration, and backfilling in the same transaction that alters a table keeps the table locked for the duration of the backfill. class AddSomeColumnToUsers < ActiveRecord::Migration[7.0] def change add_column :users, :some_column, :text User.update_all some_column: "default_value" end end
-
-
-
www.sbgnbricks.org www.sbgnbricks.org
- Feb 2022
-
seths.blog seths.blog
-
Okay, so what’s the blockchain? It’s a database. Unlike most databases, it’s not controlled by one entity and it’s not easily rewritten. Instead, it’s a ledger, a permanent, examinable, public database. One can use it to record transactions of various sorts. It would be a really good way to keep track of property records, for example. Instead, we have title insurance, unsearchable folders of deeds in City Hall and often dusty tax records.
This wrongly assumes that
- Permanent records are always desirable
- Accountability undermines corporations
-
-
github.com github.com
-
Delegated types newly introduced here looks like a Class Table Inheritance (CTI).
-
-
martinfowler.com martinfowler.com
-
A very visible aspect of the object-relational mismatch is the fact that relational databases don't support inheritance. You want database structures that map clearly to the objects and allow links anywhere in the inheritance structure. Class Table Inheritance supports this by using one database table per class in the inheritance structure.
-
-
twitter.com twitter.com
-
Tyler Black, MD. (2022, January 4). /1 =-=-=-=-=-=-=- Thread: Mortality in 2020 and myths =-=-=-=-=-=-=- 2020, unsurprisingly, came with excess death. There was an 18% increase in overall mortality, year on year. But let’s dive in a little bit deeper. The @CDCgov has updated WONDER, its mortality database. Https://t.co/DbbvvbTAZQ [Tweet]. @tylerblack32. https://twitter.com/tylerblack32/status/1478501508132048901
-
- Jan 2022
-
www.nature.com www.nature.com
-
Singh Chawla, D. (2022). Massive open index of scholarly papers launches. Nature. https://doi.org/10.1038/d41586-022-00138-y
-
- Dec 2021
-
www.science.org www.science.org
-
Antivaccine activists use a government database on side effects to scare the public. (n.d.). Retrieved December 7, 2021, from https://www.science.org/content/article/antivaccine-activists-use-government-database-side-effects-scare-public
-
- Sep 2021
-
sciencebasedmedicine.org sciencebasedmedicine.org
-
Dumpster diving in the VAERS database to find more COVID-19 vaccine-associated myocarditis in children | Science-Based Medicine. (n.d.). Retrieved September 14, 2021, from https://sciencebasedmedicine.org/dumpster-diving-in-vaers-doctors-fall-into-the-same-trap-as-antivaxxers/
-
- Jun 2021
-
www.economist.com www.economist.com
-
See how age and illnesses change the risk of dying from covid-19 | The Economist. (n.d.). Retrieved June 29, 2021, from https://www.economist.com/graphic-detail/covid-pandemic-mortality-risk-estimator
-
-
www.bmj.com www.bmj.com
-
Li, X., Ostropolets, A., Makadia, R., Shoaibi, A., Rao, G., Sena, A. G., Martinez-Hernandez, E., Delmestri, A., Verhamme, K., Rijnbeek, P. R., Duarte-Salles, T., Suchard, M. A., Ryan, P. B., Hripcsak, G., & Prieto-Alhambra, D. (2021). Characterising the background incidence rates of adverse events of special interest for covid-19 vaccines in eight countries: Multinational network cohort study. BMJ, 373, n1435. https://doi.org/10.1136/bmj.n1435
-
-
evilmartians.com evilmartians.com
-
For example, Database Cleaner for a long time was a must-have add-on: we couldn’t use transactions to automatically rollback the database state, because each thread used its own connection; we had to use TRUNCATE ... or DELETE FROM ... for each table instead, which is much slower. We solved this problem by using a shared connection in all threads (via the TestProf extension). Rails 5.1 was released with a similar functionality out-of-the-box.
-
-
naildrivin5.com naildrivin5.com
-
It’s easy to create bugs because the environment is a somewhat degenerate settings database.
-
-
dba.stackexchange.com dba.stackexchange.com
-
I suggest to make it UNIQUE because it seems like the column should be unique
-
- May 2021
-
www.sciencemag.org www.sciencemag.org
-
Wadman, M. (2021). Antivaccine activists use a government database on side effects to scare the public. Science. https://doi.org/10.1126/science.abj6981
Tags
- public
- is:article
- vaccine-safety
- science
- anti-vaxxer
- activism
- VAERS
- USA
- government
- side-effects
- false
- misinterpretation
- antivaccine
- COVID-19
- misleading
- Centers for Disease Control and Prevention
- lang:en
- misinformation
- bad science
- Fox News
- Vaccine Adverse Events Reporting System
- CDC
- data
- vaccine
- blood clots
- database
Annotators
URL
-
-
blog.frontiersin.org blog.frontiersin.org
-
Early government intervention is key to reducing the spread of COVID-19. (2020, May 6). Science & Research News | Frontiers. https://blog.frontiersin.org/2020/05/06/early-government-intervention-is-key-to-reducing-the-spread-of-covid-19/
-
-
opportunityinsights.org opportunityinsights.org
-
The Economic Impacts of COVID-19: Evidence from a New Public Database Built Using Private Sector Data. (2020, May 7). Opportunity Insights. https://opportunityinsights.org/paper/tracker/
-
-
twitter.com twitter.comTwitter1
-
Robert Colvile. (2021, February 16). The vaccine passports debate is a perfect illustration of my new working theory: That the most important part of modern government, and its most important limitation, is database management. Please stick with me on this—It’s much more interesting than it sounds. (1/?) [Tweet]. @rcolvile. https://twitter.com/rcolvile/status/1361673425140543490
-
- Mar 2021
-
twitter.com twitter.com
-
COVID-19 Living Evidence. (2020, October 23). Weekly update of COAP As of 23.10.2020, we have indexed 80588 publications: 8902 pre-prints 71686 peer-reviewed publications Pre-prints: BioRxiv, MedRxiv Peer-reviewed: PubMed, EMBASE https://t.co/RaDy1Wm4Hq https://t.co/FYRaYPe8oG [Tweet]. @evidencelive. https://twitter.com/evidencelive/status/1319578431848353793
-
- Feb 2021
-
www.nature.com www.nature.com
-
Else, H. (2020). How a torrent of COVID science changed research publishing—In seven charts. Nature, 588(7839), 553–553. https://doi.org/10.1038/d41586-020-03564-y
-
-
philosophyideas.com philosophyideas.com
-
-
However, sometimes actions can't be rolled back and it is unfortunately unavoidable. For example, consider when we send emails during the call to process. If we send before saving a record and that record fails to save what do we do? We can't unsend that email.
-
-
stackoverflow.com stackoverflow.com
-
I prefer not to duplicate the name of the table in any of the columns (So I prefer option 1 above).
So do I.
-
-
www.youtube.com www.youtube.com
-
Gen3 Data Commons overview/explained.
-
-
www.youtube.com www.youtube.com
-
GDC purpose/summary: https://youtu.be/LY5SkHJplxc?t=118
Tags
Annotators
URL
-
- Jan 2021
-
momentjs.com momentjs.com
-
IANA Time Zone Database Main time zone database. This is where Moment TimeZone sources its data from.
every place has a history of different Time Zones because of the geographical, economical, political, religious reasons .These rules are present in IANA Time Zone database. Also it contains rules for Daylight Saving Time (DST) . Checkout the map on this page: https://en.wikipedia.org/wiki/Daylight_saving_time
Tags
Annotators
URL
-
- Dec 2020
-
saveriomiroddi.github.io saveriomiroddi.github.io
-
Databases If databases data is stored on a ZFS filesystem, it’s better to create a separate dataset with several tweaks: zfs create -o recordsize=8K -o primarycache=metadata -o logbias=throughput -o mountpoint=/path/to/db_data rpool/db_data recordsize: match the typical RDBMSs page size (8 KiB) primarycache: disable ZFS data caching, as RDBMSs have their own logbias: essentially, disabled log-based writes, relying on the RDBMSs’ integrity measures (see detailed Oracle post)
-
-
www.inkandswitch.com www.inkandswitch.com
- Nov 2020
-
www.usenix.org www.usenix.org
-
Interaction with stable storage in the modern world isgenerally mediated by systems that fall roughly into oneof two categories: a filesystem or a database. Databasesassume as much as they can about the structure of thedata they store. The type of any given piece of datais known (e.g., an integer, an identifier, text, etc.), andthe relationships between data are well defined. Thedatabase is the all-knowing and exclusive arbiter of ac-cess to data.Unfortunately, if the user of the data wants more di-rect control over the data, a database is ill-suited. At thesame time, it is unwieldy to interact directly with stablestorage, so something light-weight in between a databaseand raw storage is needed. Filesystems have traditionallyplayed this role. They present a simple container abstrac-tion for data (a file) that is opaque to the system, and theyallow a simple organizational structure for those contain-ers (a hierarchical directory structure)
Databases and filesystems are both systems which mediate the interaction between user and stable storage.
Often, the implicit aim of a database is to capture as much as they can about the structure of the data they store. The database is the all-knowing and exclusive arbiter of access to data.
If a user wants direct access to the data, a database isn't the right choice, but interacting directly with stable storage is too involved.
A Filesystem is a lightweight (container) abstraction in between a database and raw storage. Filesystems are opaque to the system (i.e. visible only to the user) and allow for a simple, hierarchical organizational structure of directories.
-
-
news.ycombinator.com news.ycombinator.com
-
I've spent the last 3.5 years building a platform for "information applications". The key observation which prompted this was that hierarchical file systems didn't work well for organising information within an organisation.However, hierarchy itself is still incredibly valuable. People think in terms of hierarchies - it's just that they think in terms of multiple hierarchies and an item will almost always belong in more than one place in those hierarchies.If you allow users to describe items in the way which makes sense to them, and then search and browse by any of the terms they've used, then you've eliminated almost all the frustrations of a file system. In my experience of working with people building complex information applications, you need: * deep hierarchy for classifying things * shallow hierarchy for noting relationships (eg "parent company") * multi-values for every single field * controlled values (in our case by linking to other items wherever possible) Unfortunately, none of this stuff is done well by existing database systems. Which was annoying, because I had to write an object store.
Impressed by this comment. It foreshadows what Roam would become:
- People think in terms of items belonging to multiple hierarchies
- If you allow users to describe items in a way that makes sense to them and allow them to search and browse by any of the terms they've used, you've solved many of the problems of existing file systems
What you need to build a complex information system is:
- Deep hierarchies for classifying things (overlapping hierarchies should be possible)
- Shallow hierarchies for noting relationships (Roam does this with a flat structure)
- Multi-values for every single field
- Controlled values (e.g. linking to other items when possible)
-
- Oct 2020
-
-
Image a situation wherein you have just launched your app. But the data of your app is not being properly displayed or you are not able to fetch the data that is being entered by the users. What will be the impression of your app in the user’s mind?
Many businesses get confused when it comes to choosing the right database for their application. In fact, it is quite crucial to choose the one between SQLite and Realm.
-
-
github.com github.com
-
I too have been confused by behavior like this. Perhaps a clearly defined way to isolate atomic units with synchronous reactivity would help those of us still working through the idiosyncrasies of reactivity.
-
- Sep 2020
-
www.thelancet.com www.thelancet.com
-
Wilkinson, Jack, Kellyn F. Arnold, Eleanor J. Murray, Maarten van Smeden, Kareem Carr, Rachel Sippy, Marc de Kamps, et al. ‘Time to Reality Check the Promises of Machine Learning-Powered Precision Medicine’. The Lancet Digital Health 0, no. 0 (16 September 2020). https://doi.org/10.1016/S2589-7500(20)30200-4.
Tags
- lang:en
- challenges
- improved diagnosis
- machine learning powered precision medicine
- clinical science
- machine learning
- prediction of individual responses
- personalised medical approach
- clinical practice
- algorithmic complexity
- collaboration
- revolution
- electronic health database
- is:report
Annotators
URL
-
-
medium.com medium.com
-
The Realm is a new database module that is improving the way databases are used and also supports relationships between objects. If you are part of the SQL development world, then you must be familiar with the Realm.
-
-
www.imperial.ac.uk www.imperial.ac.uk
-
COVID-19 reports. (n.d.). Imperial College London. Retrieved September 17, 2020, from http://www.imperial.ac.uk/medicine/departments/school-public-health/infectious-disease-epidemiology/mrc-global-infectious-disease-analysis/covid-19/covid-19-reports/
-
-
digitalhumanities.org digitalhumanities.org
-
So Memex was first and foremost an extension of human memory and the associative movements that the mind makes through information: a mechanical analogue to an already mechanical model of memory. Bush transferred this idea into information management; Memex was distinct from traditional forms of indexing not so much in its mechanism or content, but in the way it organised information based on association. The design did not spring from the ether, however; the first Memex design incorporates the technical architecture of the Rapid Selector and the methodology of the Analyzer — the machines Bush was assembling at the time.
How much further would Bush have gone if he had known about graph theory? He is describing a graph database with nodes and edges and a graphical model itself is the key to the memex.
-
-
outbreaksci.prereview.org outbreaksci.prereview.org
-
Outbreak Science Rapid PREreview • Dashboard. (n.d.). Retrieved September 11, 2020, from https://outbreaksci.prereview.org/dashboard?q=COVID-19&q=Coronavirus&q=SARS-CoV-2
-
-
www.excellentwebworld.com www.excellentwebworld.com
-
In this writeup, we will be discussing one such important prerequisite that is React Native database. We can call it the backbone of React Native applications.
-
- Aug 2020
-
www.nature.com www.nature.com
-
Zheng, Q., Jones, F. K., Leavitt, S. V., Ung, L., Labrique, A. B., Peters, D. H., Lee, E. C., & Azman, A. S. (2020). HIT-COVID, a global database tracking public health interventions to COVID-19. Scientific Data, 7(1), 286. https://doi.org/10.1038/s41597-020-00610-2
-
-
riskhomeostasis.org riskhomeostasis.orgHome1
-
Home. (n.d.). Retrieved June 14, 2020, from http://riskhomeostasis.org/
-
-
final-form.org final-form.org
-
Allows batch updates by silencing notifications while the fn is running. Example: form.batch(() => { form.change('firstName', 'Erik') // listeners not notified form.change('lastName', 'Rasmussen') // listeners not notified }) // NOW all listeners notified
-
-
www.edsurge.com www.edsurge.com
-
Preprint Servers Have Changed Research Culture in Many Fields. Will a New One for Education Catch On? - EdSurge News. (2020, August 20). EdSurge. https://www.edsurge.com/news/2020-08-20-preprint-servers-have-changed-research-culture-in-many-fields-will-a-new-one-for-education-catch-on
-
-
zika.ispm.unibe.ch zika.ispm.unibe.ch
-
Living Evidence on COVID-19. (n.d.). Retrieved August 24, 2020, from https://zika.ispm.unibe.ch/assets/data/pub/search_beta/
-
-
www.tandfonline.com www.tandfonline.com
-
Arqoub, O. A., Elega, A. A., Özad, B. E., Dwikat, H., & Oloyede, F. A. (2020). Mapping the Scholarship of Fake News Research: A Systematic Review. Journalism Practice, 0(0), 1–31. https://doi.org/10.1080/17512786.2020.1805791
-
-
public.tableau.com public.tableau.com
-
Roll over each school to find out more information on their respective plans. (n.d.). Tableau Software. Retrieved August 2, 2020, from https://public.tableau.com/views/NESCACFallPlansMap/Dashboard1
-
- Jul 2020
-
dl.acm.org dl.acm.org
-
Panda, A., Gonawela, A., Acharyya, S., Mishra, D., Mohapatra, M., Chandrasekaran, R., & Pal, J. (2020). NivaDuck—A Scalable Pipeline to Build a Database of Political Twitter Handles for India and the United States. International Conference on Social Media and Society, 200–209. https://doi.org/10.1145/3400806.3400830
-
-
marketplace.digitalocean.com marketplace.digitalocean.com
-
-
Follow the money: See where $380B in Paycheck Protection Program money went. (n.d.). Retrieved July 27, 2020, from https://www.cnn.com/projects/ppp-business-loans/
-
-
-
Stathoulopoulos, K. (2020, March 17). Orion: An open-source tool for the science of science. Medium. https://medium.com/@kstathou/orion-an-open-source-tool-for-the-science-of-science-4259935f91d4
-
-
lucy.shinyapps.io lucy.shinyapps.io
-
Submit a COVID 19 Dashboard. (n.d.). Google Docs. Retrieved July 19, 2020, from https://docs.google.com/forms/d/e/1FAIpQLSdcq-I98VZeA7NjUxBvqMGmdg5ahRucDVwxo057E-x9BmeM-Q/viewform?embedded=true&usp=embed_facebook
-
-
www.nationalgeographic.com www.nationalgeographic.com
-
Coronavirus News and Coverage. (n.d.). Science. Retrieved July 18, 2020, from https://www.nationalgeographic.com/science/coronavirus-coverage/
-
-
covid-19.iza.org covid-19.iza.org
-
COVID-19 and the Labor Market. (n.d.). IZA – Institute of Labor Economics. Retrieved July 18, 2020, from https://covid-19.iza.org/publications/dp13500/
-
-
admin.nber.org admin.nber.org
-
Research Search Results for “Covid.” (n.d.). Retrieved July 18, 2020, from https://admin.nber.org/custom?q=Covid&restrict_papers=yes&client=test3_fe&proxystylesheet=test3_fe&site=default_collection&entqr=0&ud=1&output=xml_no_dtd&oe=UTF-8&ie=UTF-8&btnG=Search
-