https://preview.redd.it/41zd22gx3kge1.png?width=1363&format=png&auto=webp&s=4513eed049ca0b53fb87c2508ee69640cd3e1c88

https://preview.redd.it/b1n4je614kge1.png?width=364&format=png&auto=webp&s=2ad9ea4dd449d7f575ae36b63a1f86d7af67f7e5

https://preview.redd.it/ga9hjsx64kge1.png?width=910&format=png&auto=webp&s=ed465cf63d5526cd9bc9591f820f73e7f7daff1f

https://preview.redd.it/t56qjhb94kge1.png?width=641&format=png&auto=webp&s=4205ff0e4caa74cbaa77acb2f7460c1921bc90af

As you can see the file saved got nothing inside , its not saving ! i need to export sql so i can save packup incase some players lose their score or when i want to move to another database server .

Hello everyone does someone knows a database listing the sold items on eBay, Amazon, FB marketplace whatever but I need a real database please. Have a nice day

For about 15 years I've been using SQLyog free edition to pull backups, and occasionally diddle my home-rolled blog engine database directly, on shared hosting services. I know SQLyog was never exactly dominant in its SQL remote-client niche, as I think it's Windows-only?

So, I've been out of touch with the trends in remote DB management tools for a while now, and wondering what the leading GUI tools are on Windows for remotely operating on MySQL databases. -Not phpMyAdmin, I do have that on my current shared hosting servicer and hate having to drill down through their layers of account portal login, domain dashboard, oh look we moved the database dashboard link again, etc.

Need some advice on a database application / platform on MacOS. Context: I’m a solo practitioner consultant. I want to track the work that I do for clients that result from review work — third-party independent investment governance reviews. I’ve designed a DB schema in dbDesigner. Basically five main tables (plus a couple others) — Clients have Projects (1-Many), their Projects link to my Engagements (1-Many), my Reviews are linked to my Engagements (1-1) (not every engagement is a review), and each Review has Findings (1-Many) linked to it. The meat of the information is in the Findings db, with the need for long text fields as well as be able to handle images / files. Reviews outcomes can run from maybe a half dozen findings & recommendations to many dozens of findings and a couple dozen recommendations.

I’ve prototyped the tables and relations in Notion and I can continue to use Notion (or Airtable), though perhaps not super smooth or elegant. As I’m the only user I can get away with a bit in this regard. I use Notion as a bit of a hub for my business. I do want better control / functionality for input and be able to output in a way that could be used with clients. Years back I’d do this in Paradox or MSAccess. I’m pretty handy, but looking at DataVerse / Power Apps looks like a bit of a steep learning curve, not so much with Dataverse, but on the Power Apps interface, etc.

TIA

Hi friends!

I'm a bit of a noob to the technical world of databases. I've used databases lots in my career (as an end consumer) but never thought too much about the architecture of them.

Currently I am interviewing with Yugabyte about a non-technical role. Yugabyte has said there are two tailwinds that will drive growth:

1. Accelerating adoption of postgres as a mission critical DB
2. Migration to cloud and distribugted DB.

I've asked a few trusted friends who are more technically skilled and knowledgeable than me if those are true and if those would actually be tailwinds for Yugabyte. The reactions have been less than enthusiastic. Some of the things they've said:

-..."We aren’t at a scale or anywhere close to it where moving from postgres to a more specialized provider than the AWS solution seems like it makes sense. I agree the TAM will continue to grow for cloud DB’s but find it hard to believe that whole market won’t get swallowed by AWS/GCP/Azure outside of niche use cases."

-"Don’t think so. I guess depends on the customer but for almost all applications, most people are using one of the cloud providers for something. The cloud providers have their own hosted postgresql option that natively integrates into their other services. I use Supabase, which is a hosted version not on the cloud providers for POCs but move to the cloud providers for anything after that."

-Probably some opportunity. How they make money? Generally speaking folks want to host data same place they host apps infra wise. Database SaaS doesn’t make sense on its own. So would dig into that and the monetization lens given its open source.

-Haven’t heard of them. Distributed DB has a large usecase so I buy that. But I don’t know how they compete given it’s open source. Also how do they monetize on cloud?Is it an appliance? Ah it’s multi node write capable. That’s interesting, but not sure what the demand is. Also I am generally very skeptical of oss companies.

For folks who are more knowledgeable about this space:

-Your thoughts on the long-term growth potential of Yugabyte?

-What questions should I be asking to better understand the growth potential?

-What should I call BS on?

Hi all

I work in marketing and need to interact with very large files, currently csv on excel.

As our customer sets are growing, these files are now creeping up to 1million records each. I often need to do INDEX or V Lookups of one file againt another with... disatrous results. One file might have the purchasing data and another the payment data and I need to find patterns, solve problems etc.

I am not a technical user (hence Excel) and can't go directly against the database.

I've looked at things like Airtable, but the large number of rows and columns make this a non-starter for me.

All of the searching I've done has recommended Microsft Access, but as we work on Macs, this is not an option for me (since it's still a Windows only desktop app).

My idea solution would be something akin to Excel that runs on my Mac as a desktop application, where I can import all of the many spreadsheets I have and then interact with the data.

Since these are customer files, there are usually common indentifiers like username or email address.

I can't use anything cloud based, since I can't upload customer data.

TBH - I don't know if the thing I'm looking for exists, and the closest alternative I have found right now if FileMaker. I've used it in the past and remember it not being great, but if that's what there is, I guess I would live with it. I

Thanks in advance!

I miss my "dot prompt" interpreter for quick and dirty database manipulation and lists - it's what I'm most familiar with having used dBase II since the Radio Shack TRS-80 model II dayz up thorugh Foxpro for SCO Unix/Openserver and Unixware (I'm SCO alumni. And yes, I'm fairly old).

I can certainly write xbase code as well if there's a compiler. I don't care about the underlying database format, just so's that I can create, import, manipulate, and list using xbase in any dialect (Ashton-Tate, Fox, Borland, Recital, Clipper, etc....) - just using WINDOWS 10/11.

I have binaries (and the source to build) Foxbase+ 2.x on SCO Openserver, but I'm looking for a more convenient solution for Windows 10/11.

Looking to create a conference discovery engine for my marketing team with information on thousands of conferences including sponsors, speakers, locations, topics, sponsorships and more. I’ve built out the notional database structure for a relational database but the joins are exhaustive and so started thinking about a graph database but I’m not as familiar with these structures or coding in cypher. It looks like using existing machines I can use PostgreSQL and PGAdmin for free but getting the information I want out is complex. I was looking at Neo4J but the interwebs seem to hate on their pricing and business model? Anyway - looking for any recommendations for someone pretty new to databases. Most important for me is scalability if this grows into millions of conferences plus associated data, long term support for a platform, price reasonableness, ability to move workloads into a new platform if needed for some reason and then performance.

Hello,

Has anyone experienced data loss (partial or full) in a managed database (e.g., database solutions from DigitalOcean, AWS and so on) caused by the provider?

I want to emphasize that I am not referring to human error (e.g., accidentally dropping or truncating a database/table) but to a situation where the provider is 100% responsible.

I’m asking to understand how common additional backup implementations are for managed databases (especially using another provider for the backup. e.g. managed db on digitalocean and backup on AWS S3)

Thanks!

I am new to erd logic and need some help with an assignment. Is anyone willing to add me on discord and walk me through it? I don't want the answer but the steps to getting the answer.

Where I work, there is a web page with a very basic SQL console to for a MySQL database. It has dozens of tables and does not have autocompletion, requiring typing out full table and column names for any query.

If there's an existing JavaScript SQL console (for any database) with autocompletion, it would be a good start of improving this.

I have a large number (~40) of small (32GB) USB thumb drives and a small number (8) of large USB housed NVMe drives (2TB). All are offline most of the time.

I would like to create a database or use an app that would allow me to type part of a file name and return the drive name with files that match that criteria. Ideally, I'd like to mount the drive and click "GO", but alternatively, I could create a text file of file names for input.

Linux solution preferred, Windows not out of the question.

Any thoughts? Thanks to all that reply.

I need to create a database in sql and visual basic and the topic is free it just has to has the buttons, Insert Delete and Select. Please please help

The significance of open computing ability from the perspective of SPL · SPLWare/esProc Wiki (github.com)

which dont perish after time

Hello,

I've a relational database which I am trying to convert into a graph database.

I've three vertices:

EMPLOYEE:  Contains personal details like name, surname, address, and employee ID.

https://preview.redd.it/yq9p0pjywzee1.png?width=407&format=png&auto=webp&s=55bdaec3d9a8f7afaf5055d0b4617d27b2cdc97c

BONUS: Provides information for different Bonuses.

https://preview.redd.it/i1xcw3xvwzee1.png?width=680&format=png&auto=webp&s=5489f6b20c039db16fe762f8154884d6e3e37aa9

REASON_FOR_BONUS: Provides information on different types of reason an employee can get a bonus.

https://preview.redd.it/arztt88hwzee1.png?width=1225&format=png&auto=webp&s=c33918d36607397dfb7eb25c4e7c55e9145addea

I've a table which details on which employee got what bonus and information related to it like the date they received, amount and reason why they received.

EMPLOYEE_BONUS

Now I want to create a graph relationship between Employee and bonus.

CURRENT RELATIONSHIP

The problem that I am facing is that REASON_CODE_FOR_BONUS is the ID of the entity BONUS_REASON which have other properties like description. While creating the relationship I want to connect all the vertices together so that when I query the graph it will return me all the information like explained in the table but as a relationship in the graph can be only between two vertices it's confusing for me on how to add all the properties in one edge. One idea I had was to add REASON_CODE_FOR_BONUS as a property in BONUS edge but if I do that I would be missing out on the properties of the entity BONUS_REASON like description and stuff.

If you have a better design, do suggest!! THANKS!!

Think query generation, asking questions about the schema and attributes, a collaborative repository (being able to work on a query with a colleague) and auto saving the queries in a catalogue based on certain tags and usages

Would you like to use something like this? Let me know what must-have features you would need to use something like this and please let me know if you have any ideas / advices / anything that you would like to have in a modern SQL IDE

Im new. I have a private key - 1secretkey- that is needed to generate public keys - 1pubkey, 2pubkey etc-. I am using javascript for front and firebase for backend. Please tell me how to set this up in the rules. I am clueless. Thank you.

I have a Products table, 2 options:

1. Let the user type the PK because some users can input Barcodes or no (in this case, the app will let to user free to input anything for example his own code conventions like Oreo Icecream IC-O) obviously, i need to add some validations to avoid PK with thousends of characteres and more.
2. Use the autoincrement PK and create another field for a "SecondaryCode" but for user this will be the primary key, some validations for SecondaryCode here too and this feels weird using a SecondaryCode like a PK.

Is there any very bad reason not to choose the first option? Theorically is good and more easy to manage but i don't feel comfortable exposing something important as a primary key. Maybe I'm missing something obvious.

Hey everyone, my prof isnt responding to me and me exam is tomorrow.

Can anyone explain to me why C is wrong here?

In my opinion it should be right, because while we can not record every time we saw a bird, if for example the bird was seen twice that day.

Aren't we able to save every single date a bird was seen, so technically C is correct or am I missing something here?

In the solution it says A, B, E,F are correct, does anyone agree with me here that C should be as well? Thanks for the help!

Hi, so currently in my database I have this table called Activity that has a TEXT field to indicate the type of the activity and a JSONB column that represent that activity's details. In the beginning, I thought this was a reasonable approach. However, I found myself need to write trigger functions to check the structure of each activity depending on its type, which was a little bit cumbersome but still tolerable(we had 6ish activity type). However, recently I needed to create activity types that needed to use image and therefore needed to reference the image table in our database, so the foreign key need to store inside the JSONB. While this could work, I would need to manually maintain the foreign key constraint myself using in either trigger function or the application-level code as JSONB column does not support it. I saw someone facing the same issue and other people's advice was to simply ditch the JSONB field and give each activity their own tables. As it was getting more and more cumbersome, I am really in favor of normalizing our data and ditch the JSONB approach, giving each activity their own table schemas. But the idea of using JSONB was not mine, it was my PM's. I am relatively junior so I am not sure how I could persuade him. Could you guys list me some benefits of giving each activity type a table instead of just using a single JSONB field to store them? Thanks.

I want to efficiently design the graph schema and relationships to query scenarios like:

"What is the complete history of all job titles an employee has held in the company?"

Currently, I'm matching the DTDEBUT, DTEND, and STATUS fields to align the relationships between EMPLOYEE, POSITION , and JOB TITLE.

Is there a better way to design the graph schema or relationships to make such queries more efficient in a graph database? Are there best practices for structuring date-based relationships in a graph database for querying temporal data effectively? I am using a Gremlin-compatible graph database, but the suggestions can be general.

Current Setup I have three vertices:

EMPLOYEE VERTEX: Contains personal details like name, surname, address, and employee ID.

EMPLOYEE VERTEX

POSITION VERTEX: Represents a specific role in the company that can host different job titles over time.

https://preview.redd.it/yvx2gxk9jree1.png?width=374&format=png&auto=webp&s=07b322020ed2419818f3ebd764d3edef03749d23

Includes:

• DTDEBUT: Date the position started in the organization.
• DTEND: Date the position was dissolved.

JOB TITLE VERTEX: Describes the work performed by employees (e.g., Data Scientist, Engineer).

JOB TITLE VERTEX

Includes:

• DTDEBUT: Date the job title became active.
• DTEND: Date the job title was discontinued.

RELATIONSHIP DESIGN

RELATIONSHIP DESIGN

1. EMPLOYEE → POSITION: Tracks which position an employee occupied, including:

• DTDEBUT: Start date.
• DTEND: End date.
• STATUS: Employment status.

1. POSITION → JOB TITLE: Tracks the job titles hosted by a position, including:

• DTDEBUT: Start date of the hosting.
• DTEND: End date of the hosting.

1. POSITION_EMPLOYEE_JOBTITLE_HISTORY: A table summarizing the history of all employees, positions, and job titles, including start and end dates, and status.

POSITION_EMPLOYEE_JOBTITLE_HISTORY

I’m working on an idea and I’m pretty lacking in db design skills.

I’d like to insert records into a table for 3 fields. Each field would contain a choice from a list. That list is available on a form connected to the table.

For example I’d like someone to pick 3 cars they like. They can pick a car from the list in the first field, second and third. The unique id would be a variable.

Now this is where I get lost. I’m thinking if I could order the insert to place the lowest id value in column1, next in 2, etc.

Anyone know a method in sql that would do this?

Good Morning!

First of all, I'm sorry for the lack of misuse of techincal terms , my not so good english and the long text.

I'm developing an Desktop App in C# MVVM Winui that is supposed to receive data from objects ( for now only focusing on receiving position [lat,long,alt] speed and direction) and represent it on a map . My estimation for max number of objects at the same time would be a few thousands and thats already a very positive estimate for what will probably be the real number.

The program follows an hierarchy let's say an owner has 20 objects, it receives 20 object tracks and will share those 20 object tracks with others owner( and vice versa) in a single message. Therefore, even if there are 1000 objects that are, there won't be an owner receiving 1k single message in a space of seconds, it will probably come in batches of tens
Data is received by a singleton class (services.AddSingleton<IncomingDataHandler>();)

My initial idea was a global variable that would hold all that data in observable collections/property changed and through Dependecy Injection, the viewModel would just read from there .

I had a lot of problems because of memory leaks, the viewModels were acumulating to the a lot of subscription because of those.

So I'm trying to move even more to the reliance of Databases (the app has another purposes outside of tracking, but this is the biggest challenge because is real-time data, the other data doesn't change so frequently and I can support some lag)

My new ideia is for the app to receive data , , store in a database so the ViewModel-View responsible for displaying the data can constantly read from the db for the updates. So I need fast writes and reads, and no need for ACID, some data can be lost, so i focused in NonSQL

Do you guys know any database that is reliable for this? Or is this idea not even feasible and I should stay with a global Variable but with better event subscription( using Reactive or something else ?

I'm focusing in embedded Database so the user does not need to install and/or setup a server

For reference, my first option was RocksDB but i'm having an hard time to understand it because it is information in internet is mostly C++.

Thank you guys for your attention.