Building a physics formula database -- Help please

In summary, I'm looking to compile a large online database of physics formulas*. I have yet to find any comprehensive "physics list" that isn't too domain specific or simply scalable. My attempt will be to build it here newtondb.com following and expanding on pldb.com. It will be built using a treebase language and will compile to a simple CSV.Thanks for your help!
  • #1
angrymonks
5
0
I'm looking to compile a large online database of physics formulas*. I have yet to find any comprehensive "physics list" that isn't too domain specific or simply scalable. My attempt will be to build it here newtondb.com following and expanding on pldb.com. It will be built using a treebase language and will compile to a simple CSV.

I'd love to hear feedback and looking to collaborate. Just shoot me a message.

*variables, objects, formulas, experiments and everything in between
 
Last edited:
Physics news on Phys.org
  • #3
jedishrfu said:
Have you seen this website?

https://phys.libretexts.org/Learning_Objects/A_Physics_Formulary/Physics

Its not comprehensive but may illustrate the difficulties you will face with some formulas being derived from other more general formulas and you would need to account for that.
Thanks!

I have come across that site. Physics.info is another good one as well. Yes, representing the variables in relation to each other is going to be a challenge but I suppose that the fun of it.
 
  • #5
This task reminds me of someone who suggested creating a database or lexicon for differential equation systems. After a quite short process of thinking I came to the conclusion that this would be a task for several volumes. Strictly speaking, your goal will be included in those books since formulas in physics are almost automatically differential equations or systems thereof. Long story short, I think this is a Sisyphus task.
 
  • Like
Likes Vanadium 50, angrymonks and jedishrfu
  • #6
jedishrfu said:
I looked at your two sites. They look pretty sweet.

Is pldb your site or someone else's project?

How did you find Mike Colishaw and Bill Ousterhout?

I was thinking if you want to get into more recent software language interviews there's the folks who designed Julia, Jeff Bezanson, Stefan Karpinski, Viral B. Shah, and Alan Edelman.

https://en.wikipedia.org/wiki/Julia_(programming_language)
Thank you 😊

pldb is the brainchild of my good friend Breck Yunits. I join him about a year ago. I simply reached out to a couple of the major programming language designers to get feedback and insight. I’d love do get the Julia folks involved.
 
  • #7
fresh_42 said:
This task reminds me of someone who suggested creating a database or lexicon for differential equation systems. After a quite short process of thinking I came to the conclusion that this would be a task for several volumes. Strictly speaking, your goal will be included in those books since formulas in physics are almost automatically differential equations or systems thereof. Long story short, I think this is a Sisyphus task.

That I agree with. Just trying to get the ball rolling is all (no pun intended). If the effort is open source and easily scalable then I believe it to be worth while.
 
  • #8
Another place to take inspiration from is MathWorld. Perhaps you could reach out and interview him as well. His name is Eric Weisstein.

https://en.wikipedia.org/wiki/Eric_W._Weisstein

https://mathworld.wolfram.com/

He had quite an experience building his site math site. One stumbling block was a deal he made with CRC that turned into a nightmare. Later Wolfram came to the rescue and now his site is maintained under their protective umbrella.
 
  • #9
This is another thought to be taken into consideration. Such an enterprise would have to basically almost copy the entire physics part of Wikipedia, across at least six languages (English, French, Russian, German, Spanish, Italian). These alone are really many, I mean, many formulas.
 
  • Like
Likes jedishrfu
  • #10
jedishrfu said:
Another place to take inspiration from is MathWorld. Perhaps you could reach out and interview him as well. His name is Eric Weisstein.

https://en.wikipedia.org/wiki/Eric_W._Weisstein

https://mathworld.wolfram.com/

He had quite an experience building his site math site. One stumbling block was a deal he made with CRC that turned into a nightmare. Later Wolfram came to the rescue and now his site is maintained under their protective umbrella.
Sweet! He'd be a perfect candidate to interview.
 

FAQ: Building a physics formula database -- Help please

What is the best way to structure a physics formula database?

The best way to structure a physics formula database is to organize it by categories such as mechanics, electromagnetism, thermodynamics, quantum mechanics, and relativity. Within each category, you can further divide the formulas by subtopics. Each entry should include the formula, a description, variables involved, and units. Using a relational database management system (RDBMS) like MySQL or PostgreSQL can help manage the data efficiently.

How can I ensure the accuracy of the formulas in the database?

To ensure accuracy, source the formulas from reputable physics textbooks, peer-reviewed journals, and educational websites. Cross-reference multiple sources to verify the correctness. Additionally, involve subject matter experts to review the formulas and their descriptions before adding them to the database.

What are some essential features to include in the database?

Essential features to include are a search function, categorization by topic and subtopic, detailed descriptions, variable explanations, unit conversions, and references to the original sources. User-friendly navigation and the ability to export or print formulas can also be beneficial.

How can I handle different units and unit conversions in the database?

Implement a standardized unit system, such as the International System of Units (SI), and provide conversions for other commonly used units. Include a utility or function within the database that can automatically convert units for the user. Clearly indicate the units for each variable in the formula descriptions.

What technologies should I use to build and maintain the database?

For building the database, you can use relational database management systems like MySQL, PostgreSQL, or SQLite. For the front-end, consider using HTML, CSS, and JavaScript frameworks like React or Angular for a responsive user interface. Backend technologies like Node.js, Django, or Ruby on Rails can help manage database interactions. Regular backups and updates are essential for maintaining the database.

Back
Top