Do I need to sanitize my CSVs before importing?  database

2 years ago | 6 comments | self.Database | Score: 3 Reddit


Questions about RDBMS: how easy it is to change schemas midway through production?  database

2 years ago | 15 comments | self.Database | Score: 8 Reddit


Database Workbench 5.3.2 released  database

2 years ago | comments | upscene.com | Score: 2 Reddit


How to find unused indexes in a MySQL database?  database

2 years ago | comments | eversql.com | Score: 7 Reddit


Will hire Database Designer/Website Developer for special project  database

2 years ago | 15 comments | self.Database | Score: 2 Reddit


Need someone to evaluate my database  database

2 years ago | 13 comments | self.Database | Score: 5 Reddit


Can't get a distinct column no matter what i try :(  database

2 years ago | comments | self.Database | Score: 1 Reddit


Unique Column checker for SQL Server  database

2 years ago | 9 comments | i.redd.it | Score: 12 Reddit


Architectural Comparison between NoSQL Databases (includes GridDB)  database

2 years ago | comments | griddb.net | Score: 1 Reddit


Created a db solution in MS Access. It has gained traction and now I need to consider upgrading to something more robust.  database

2 years ago | 9 comments | self.Database | Score: 5 Reddit


Firebird support for Decfloat will be enabled in Firebird 4.0  database

2 years ago | comments | firebirdnews.org | Score: 1 Reddit


New, free tool for DBMS browsing / spatial SQL / Analysis  database

2 years ago | comments | reddit.com | Score: 4 Reddit


How would I make this into a sortable database?  database

2 years ago | 28 comments | i.redd.it | Score: 2 Reddit


How to prevent SQL Server from adding 1 to each Row  database

2 years ago | 1 comment | self.Database | Score: Reddit


Anyone interested in alpha testing a tool that does sparse column analysis? • r/SQLServer  database

2 years ago | comments | reddit.com | Score: 9 Reddit


Looking for a List of ANSI SQL data types  database

2 years ago | 2 comments | self.Database | Score: 7 Reddit

Latest Comment

One easy and free way is to look into the BNF syntax:

The one from SQL:2011 is the latest freely available I know of: http://jakewheat.github.io/sql-overview/sql-2011-foundation-grammar.html#predefined-type

(I guess you are interested in the predefined types).

In my article about SQL:2016, I also mention that DECFLOAT was introduced.

That gives you a full list of predefined types in SQL:2016 (part 2).


2 years ago


Not the exact job I want but close  database

2 years ago | 9 comments | self.Database | Score: 9 Reddit

Latest Comment

Honestly, unless you like data work. I would not recommend this position for you. It would be better to get an SDE position. You will learn skills that would help you much more than SQL. I am a data engineer/ scientist. This is kind of where many people start that path. Since you want to do web dev, doesn't really make sense.


2 years ago


How to remark someone availability in a database  database

2 years ago | 5 comments | self.Database | Score: Reddit

Latest Comment

If you are just looking to use one field and you only care about the days, you could use bitwise to calculate that. If you need times as well, I would recommend a separate table for the values like others have recommended.


2 years ago


What's the best way to let users create groups and invite other users?  database

2 years ago | 2 comments | self.Database | Score: 1 Reddit

Latest Comment

There are questions that you will also run into such as:

What if someone wants to create a private group, only known to its members?

Can a user specify their username to be blocked from being added to a group?

Additional security table(s) would need to be created and views added to restrict read access to only the users who have opted in to being added.


2 years ago


Meta: where to after MySQL?  database

2 years ago | 10 comments | self.Database | Score: 1 Reddit

Latest Comment

Regardless of which you choose I think talking a dip into MongoDB, just to experience NoSQL.


2 years ago


Terark, a YC database startup, built a new storage engine based on the succinct nested trie structure, that is 200X faster with 15X storage savings  database

2 years ago | 3 comments | techinasia.com | Score: 22 Reddit

Latest Comment

Fascinating thanks for the share


2 years ago


trouble with case statement in sql server  database

2 years ago | 7 comments | self.Database | Score: 2 Reddit

Latest Comment

right joins, table functions oh my. Atleast it's nicely formatted!

add the case statements to the group by, that I have a feeling doesn't need to exist.

is this what you're asking for when you mean an IIF? IIF(u1.id IS NULL,'',-1)


2 years ago


How Indexes work in SQLite  database

2 years ago | comments | medium.com | Score: 16 Reddit


How big were the first hard drives?  database

2 years ago | 3 comments | blog.sqlizer.io | Score: 5 Reddit

Latest Comment

The disk drive created a new level in the computer data hierarchy. It was cheaper and slower than main memory but faster and more expensive than tape drives.

Also cheaper and slowe than drum. Before core memory was invented, back when mercury delay-line was possible but avoided, drum was used for working memory in a lot of machines, especially the smaller ones. Then with core, drum was used for fast swapping, while disk was used for slower storage and tape, slower and more portable yet.


2 years ago


x-post [AMA] Azure Database for PostgreSQL team - 6/22  database

2 years ago | comments | reddit.com | Score: 3 Reddit


Database Training Recommendations  database

2 years ago | 1 comment | self.Database | Score: 18 Reddit

Latest Comment

MariaDB is the future and is identical to Mysql.

There are corner cases where it isn't identical but you probably won't run into those.


2 years ago


Not sure what software to go with  database

2 years ago | 4 comments | self.Database | Score: 3 Reddit

Latest Comment

No Microsoft. It's not suited to the task.

Postgresql is very well suited. The best part is you set up an ODBC connection and use an Access form to enter data.

You can tighten up the access a number of ways. But, basically, Postgresql will get you there.


2 years ago


Search many to many mysql table  database

2 years ago | 3 comments | self.Database | Score: 4 Reddit

Latest Comment

If the id_video/id_tag combinations are unique, you could do this:

select id_video from
(
    select id_video, count(*) from table
    where id_tag in (1,3,4)
    group by id_video
    having count(*) = 3
);

2 years ago


I feel bad for including flags/types in parent tables in rDBMS. Should I?  database

2 years ago | 9 comments | self.Database | Score: 5 Reddit

Latest Comment


2 years ago


The data inside of Mongo lives basically in a bunch of JSON documents; how are SQL tables actually stored?  database

2 years ago | 7 comments | self.Database | Score: 1 Reddit

Latest Comment

For MSSQL, I'll preface the link I'm about to post with a little context you need to understand the link.

Everything in SQL Server is stored on a "page". A page is a 8kb block of data on disk / memory. Every disk / memory lookup, is done by page. So everything is read and cached on 8kb chunks of binary data.

As to how the actual data is structured, I'll point you to the guy, that for quite some time was responsible for the storage engine on SQL Server :

https://www.sqlskills.com/blogs/paul/inside-the-storage-engine-anatomy-of-a-record/

This pretty much is the place to go, if you want to know how deep down, very deep down, SQL Server handles the actual data.


2 years ago


Need advice on correct software or programming direction  database

2 years ago | 5 comments | self.Database | Score: 1 Reddit

Latest Comment

Access should be replaced with any modern RDBMS: PostgreSQL, MariaDB/MySQL, Microsoft SQL Server, probably even Firebird (though it's less common).

Be aware that a "SQL database" is a generic term that applies to any of the above products, while "Microsoft SQL Server" is just one specific database among many. Which one is best for you depends on your environment, budget, growth potential among other things.


2 years ago


Can anyone suggest a database architecture for my given use case?  database

2 years ago | 4 comments | self.Database | Score: 3 Reddit

Latest Comment

It wasn't clear if you were asking about the data model, or which specific rdbms, or instance specs, etc. Other replies referenced data model, so...

Since you're already invested in AWS, look at RDS Postgres, RDS MySQL, or Aurora. Last I looked Aurora wasn't much more expensive than RDS MySQL.

If you're asking "how many cpus and GB of memory do I need?", I still don't think there's enough information. You said 1000 concurrent threads, but what would that equate to in queries per second? Are you read heavy? Write heavy? Balanced read/write? Slaves can possibly be used to handle reads depending on how much latency your app can handle.


2 years ago


What's New in SQL:2016  database

2 years ago | comments | modern-sql.com | Score: 8 Reddit


Running SQL Queries Against Baby Names from Social Security Card Applications  database

2 years ago | comments | sqlservercode.blogspot.com | Score: 1 Reddit


Time-series data: Why (and how) to use a relational database instead of NoSQL  database

2 years ago | 1 comment | blog.timescale.com | Score: 11 Reddit

Latest Comment

I've been writing time-series databases for years. We called them data warehouses, data marts or anything that uses a dimensional model. I'd love to see more a description of how a new product makes time-series any easier than what we've always built from scratch.

Beyond that, this is an excellent posting.


2 years ago


Best software to use for analysis of small Business data  database

2 years ago | 8 comments | self.Database | Score: Reddit

Latest Comment

How much data are we talking about here? Too much and Access is going to croak.


2 years ago


How to compare and contrast two data Models? Best Practices?  database

2 years ago | comments | self.Database | Score: 1 Reddit


SQLite small blob storage: 35% Faster Than The Filesystem  database

2 years ago | 2 comments | sqlite.org | Score: 19 Reddit

Latest Comment

The real WTF here is what are both Windows 7 and 10 doing to roundly beat out Ubuntu in SQLite performance?


2 years ago


Come join the Rocket Squirrels, a team of webdevs on Slack  database

2 years ago | 1 comment | self.Database | Score: 1 Reddit

Latest Comment

Sorry to point that out .... but why are you posting this on /r/database ?

Most of us are die hard backend developers, that would cut their own hand off, before touching java script. Or WordPress. Or Node. Or Angular, Or PHP, damn the only programming languages you listed that I'd touch are .Net and pyhton, and on phyton I'd answer why not powershell?.


2 years ago


Database Admins of Reddit, what do you enjoy most about your job? What do you not like? What lessons/advice would you give to a prospective coworker? What qualities produce the best DBAs, in your opinion?  database

2 years ago | 11 comments | self.Database | Score: 17 Reddit

Latest Comment

I like the puzzles. I like to make things that help others.

I like that it is a pretty powerful high-level language so my results are pretty instantaneous.


2 years ago


A brief History of JSON  database

2 years ago | 3 comments | blog.sqlizer.io | Score: 20 Reddit

Latest Comment

It bothers me that nobody seems to be able to write an article about the benefits of JSON without ripping on XML.


2 years ago


Arguments for composite keys vs single key?  database

2 years ago | 17 comments | self.Database | Score: 8 Reddit

Latest Comment

But do you need composite keys? Half of the databases that I've worked with, had no reason to use composite keys. It is not something every database needs. Unless you are just combining keys for no reason.


2 years ago


High level questions about alwayson  database

2 years ago | 3 comments | self.Database | Score: 3 Reddit

Latest Comment

First off - you're right, this is a LARGE task ;)

What OS and SQL Server version are you running? You may not be able to use AlwaysOn in your case until you upgrade (defeating the point).

Licensing cost - it will likely need Enterprise licenses. Will your project have the budget for it?

Migration strategy - do you want to cut all apps over at once? If you're using one name your options are limited. It will be more work to change your connection strings, but you'll have fewer headaches when you cut over. Also, depending on how much downtime is allowed will dictate if you can dump and load each database, or if you need mirroring/log shipping setup to reduce time to cut over.

Look into DNS CNAME records. You can have multiple names pointing to the same IP Address. You can update connection strings ahead of time, then only worry about the database at cutover - just update the cnames that the migrating apps rely on. Hopefully that made sense.

Good luck!


2 years ago


what is the name for the structures stored in a database  database

2 years ago | 17 comments | self.Database | Score: 9 Reddit


I'm programming a web db app in MS VS Community 2017 with a localDB Sql Server db. Is it possible to link Access to its tables (to use Access as a development tool).  database

2 years ago | 4 comments | self.Database | Score: Reddit


Ordering Based on a "Previous Primary Key" Column  database

2 years ago | 2 comments | self.Database | Score: 1 Reddit


Database question?  database

2 years ago | 11 comments | self.Database | Score: 1 Reddit


Implicit join  database

2 years ago | 9 comments | self.Database | Score: 2 Reddit


Is it possible to store a variable inside of a datapoint? read more for explanation  database

2 years ago | 7 comments | self.Database | Score: 2 Reddit

Latest Comment

You probably want to use some sort of templating engine rather than rolling your own text substitution. They will have encountered and dealt with a lot more edge cases already so you don't have to encounter them all one by one in the wild.


2 years ago


Azure Import Export Services – Notes from the field  database

2 years ago | comments | dcac.co | Score: 1 Reddit