Relational Databases for Behavior Science
Store your behavioral data in a free relational database so you can find, share, and rerun analyses without Excel chaos.
01Research in Context
What this study did
PL (2025) wrote a how-to paper. It tells behavior analysts to stop using Excel sheets. Instead, store data in a relational database like SQLite or MySQL.
The paper shows simple code. You can run the code on any computer. The goal is cleaner data that anyone can check and reuse.
What they found
The paper does not test kids or staff. It shows that a good database keeps numbers safe. You can search, share, and repeat analyses with one click.
No more lost files or typos. The same query gives the same result every time.
How this fits with other research
Moeyaert et al. (2016) and Aydin et al. (2022) also push free tech. They checked how well tools pull numbers from graphs. PL (2025) moves one step back: lock the numbers in a safe place before graphing.
Cariveau et al. (2021) teach cheap iPad tricks. PL (2025) adds cheap data tricks. Together they show you can run solid studies without costly software.
Parry‐Cruwys et al. (2022) prove short online lessons work. Their idea pairs well with PL (2025): teach students to store data right from day one.
Why it matters
If you run single-case studies, a free database keeps every trial safe. You can share your raw file with a journal in minutes. New staff can rerun your analysis without hunting through messy folders. Start with SQLite this week: one file, no install, and you are future-proof.
Want CEUs on This Topic?
The ABA Clubhouse has 60+ free CEUs — live every Wednesday. Ethics, supervision & clinical topics.
Join Free →Download DB Browser for SQLite, import this week’s session CSV, and run one SELECT query to list all correct responses.
02At a glance
03Original abstract
Data collection and analysis are central to scientific research, including in applied and basic behavior analysis. A substantial amount of attention has been given to how to rigorously collect and analyze data. Less attention has been paid to storing and maintaining research data, which becomes a critical step in the data analysis pipeline as the complexity and amount of data increase. Relational databases provide an efficient, reliable, and flexible method to store, maintain, and explore behavioral research data. The current article argues for the utility of relational databases in behavioral research, presents a brief introduction to relational databases, and uses some real-world examples to illustrate how relational databases have been used by the author and colleagues. Adopting relational databases to store and maintain research data would improve data integrity, facilitate data sharing between researchers, and contribute to transparency and reproducibility of analyses.
, 2025 · doi:10.1007/s40614-025-00486-w