SQL - any and all
- When you're asked to write a custom query to be used in crystal reports
I got this as a reaction to this post and I just felt it in my soul.
https://lemmy.world/comment/4795320
- NoSQL keeps rising, but relational databases still dominate big datawww.techrepublic.com NoSQL keeps rising, but relational databases still dominate big data
Even though MongoDB and Cassandra keep winning converts, enterprises are keeping their RDBMSes around, and will do so for quite some time.
As an RDBMS professional - I found this article quite engaging, although a bit old.
- Graphical SQL Editor with auto-complete for Relational Tables?
Hi!
I'm looking at manually entering quite a bit of relational data and I am wondering whether anyone knows of a nice GUI tool to do it?
What I'm looking at doing is something like matching up names with addresses. I have a table with a list of people, and I have a list of properties. I want to create a table where I could pair up people with properties. I would like the ID's to be entered into the Database, but I would like to see names and addresses on the front-end. Preferably when I click into the new relational table's columns it would give me an auto-complete list of possible values as I type. (So offer suggestions for names / addresses).
I'm looking for something web-based or MacOS / Linux compatible.
Does anyone know of such a tool?
- Create an advanced search engine with PostgreSQLxata.io Create an advanced search engine with PostgreSQL
PostgreSQL provides the necessary building blocks for you to combine and create your own search engine for full-text search. Let's see how far we can take it.
- Are there patterns one learns to solve SQL interview questions (or tasks in general)?
I recently tried my hand at an advanced online SQL test for a io position. Time-trial, non-autocompleting IDE, no human interaction. I failed miserably (0%) and I am fine with it. I have prepared myself with StrataScratch and the Mode tutorial, on top of my experience in querying GA4 data in BQ and other data for finance, sales and operations. . Although the resources are good to familiarize with SQL functions and structuring queries, I still feel that I am missing some kind of mindset that would enable me to tackle SQL questions irrespective of complexity. I don't want to know necessarily the details, if it is hard for you to explain, but I would like to know if there is such a state of mind to achieve. Of course, any description and resource is welcome.
- Your favorite database engine?
Obviously Microsoft Access is the best but it would be cool to hear your opinion.
- Best practices for writing SQL (according to metabase)www.metabase.com Best practices for writing SQL queries
SQL best practices: a brief guide to writing better SQL queries.
Who doesn't love a good discussion about best practices? Here is an article from metabase on their recommended best practices for writing SQL. Share you opinion and recommendations.
- Ask complex questions of high-volume real-time data streamsgithub.com GitHub - ArroyoSystems/arroyo: Distributed stream processing engine in Rust
Distributed stream processing engine in Rust. Contribute to ArroyoSystems/arroyo development by creating an account on GitHub.
Use SQL to query live data streams. Similar to Apache Fink and Kafka Streams.
- SQL:2023 is finished: Here is what's new (Peter Eisentraut)peter.eisentraut.org SQL:2023 is finished: Here is what’s new
SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Central Secretariat, and it’s now up to the ISO gods when it will be published. Based on past experience, it could be between a few weeks and a few months.
New SQL 2023 - Per Peter, here are the main three topics:
- Various smaller changes to the existing SQL language
- New features related to JSON
- A new part for property graph queries
- Announcing SQL Community
Hi Everyone:
The SQL community has been created where we can discuss anything related to SQL, regardless of dialect or version.
Please share your posts and questions for the community to discuss or answer.