Reddit/database - Rennetti.com

Do I need to sanitize my CSVs before importing? database

7 years ago | 6 comments | self.Database | Score: 3

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

7 years ago | 15 comments | self.Database | Score: 8

Database Workbench 5.3.2 released database

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

How to find unused indexes in a MySQL database? database

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

Will hire Database Designer/Website Developer for special project database

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

Need someone to evaluate my database database

7 years ago | 13 comments | self.Database | Score: 5

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

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

Unique Column checker for SQL Server database

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

Architectural Comparison between NoSQL Databases (includes GridDB) database

7 years ago | comments | griddb.net | Score: 1

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

7 years ago | 9 comments | self.Database | Score: 5

Firebird support for Decfloat will be enabled in Firebird 4.0 database

7 years ago | comments | firebirdnews.org | Score: 1

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

7 years ago | comments | reddit.com | Score: 4

How would I make this into a sortable database? database

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

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

7 years ago | 1 comment | self.Database | Score:

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

7 years ago | comments | reddit.com | Score: 9

Looking for a List of ANSI SQL data types database

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

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).

7 years ago

Not the exact job I want but close database

7 years ago | 9 comments | self.Database | Score: 9

How to remark someone availability in a database database

7 years ago | 5 comments | self.Database | Score:

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

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

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.

7 years ago

Meta: where to after MySQL? database

7 years ago | 10 comments | self.Database | Score: 1

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

7 years ago | 3 comments | techinasia.com | Score: 22

trouble with case statement in sql server database

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

How Indexes work in SQLite database

7 years ago | comments | medium.com | Score: 16

How big were the first hard drives? database

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

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.

7 years ago

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

7 years ago | comments | reddit.com | Score: 3

Database Training Recommendations database

7 years ago | 1 comment | self.Database | Score: 18

Not sure what software to go with database

7 years ago | 4 comments | self.Database | Score: 3

Search many to many mysql table database

7 years ago | 3 comments | self.Database | Score: 4

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
);

7 years ago

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

7 years ago | 9 comments | self.Database | Score: 5

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

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

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.

7 years ago

Need advice on correct software or programming direction database

7 years ago | 5 comments | self.Database | Score: 1

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.

7 years ago

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

7 years ago | 4 comments | self.Database | Score: 3

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.

7 years ago

What's New in SQL:2016 database

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

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

7 years ago | comments | sqlservercode.blogspot.com | Score: 1

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

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

Best software to use for analysis of small Business data database

7 years ago | 8 comments | self.Database | Score:

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

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

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

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

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

7 years ago | 1 comment | self.Database | Score: 1

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?.

7 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

7 years ago | 11 comments | self.Database | Score: 17

A brief History of JSON database

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

Arguments for composite keys vs single key? database

7 years ago | 17 comments | self.Database | Score: 8

High level questions about alwayson database

7 years ago | 3 comments | self.Database | Score: 3

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!

7 years ago

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

7 years ago | 17 comments | self.Database | Score: 9

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

7 years ago | 4 comments | self.Database | Score:

Ordering Based on a "Previous Primary Key" Column database

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

Database question? database

7 years ago | 11 comments | self.Database | Score: 1

Implicit join database

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

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

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

Azure Import Export Services – Notes from the field database

7 years ago | comments | dcac.co | Score: 1